CDR Tickets

Issue Number 4816
Summary [DIS] Global to preserve processing status data
Created 2020-04-17 14:02:54
Issue Type Improvement
Submitted By Osei-Poku, William (NIH/NCI) [C]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2020-04-20 23:55:41
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.260578
Description

We decided in OCECDR-4612 to preserve the data in the existing processing status element in DIS documents before deleting the element. Please run a global to preserve the data in a Comment element and delete the existing processing status element.

Comment entered 2020-04-20 23:55:41 by Kline, Bob (NIH/NCI) [C]

Test run results on DEV.

Comment entered 2020-05-06 08:24:55 by Osei-Poku, William (NIH/NCI) [C]

I was surprised to see only 4 documents for this global.

Verified. Please run in live mode on DEV.

Comment entered 2020-05-06 09:04:53 by Kline, Bob (NIH/NCI) [C]

Are you thinking there might be a flaw in the script's logic? Do you have any examples of documents which should have been picked up but weren't?

Comment entered 2020-05-06 11:45:09 by Osei-Poku, William (NIH/NCI) [C]

No. It is an accurate count. I was surprised because I thought there would be more. If I knew then that there were only 4 DISs, we would have transferred the comments manually.

Comment entered 2020-05-06 12:21:03 by Kline, Bob (NIH/NCI) [C]

I wondered about that, too.

Comment entered 2020-05-07 09:40:21 by Kline, Bob (NIH/NCI) [C]

Please run in live mode on DEV.

Waiting for OCECDR-4825.

Comment entered 2020-05-07 12:41:01 by Kline, Bob (NIH/NCI) [C]

Live run completed on DEV.

2020-05-07 12:38:01.203 [INFO] Running in real mode, updating the database
2020-05-07 12:38:01.203 [INFO] Running on DEV
2020-05-07 12:38:04.078 [INFO] 6 documents selected
2020-05-07 12:38:04.078 [INFO] Purpose: 'Capture old ProcessingStatus elements as comments (OCECDR-4816)'
2020-05-07 12:38:13.163 [INFO] Processing CDR0000544267 (BLOCKED) [pub:59/last:61/cwd:unversioned]
2020-05-07 12:38:13.179 [INFO] save(544267, ver='Y' pub='N' val='N' old cwd)
2020-05-07 12:38:14.278 [INFO] save(544267, ver='Y' pub='Y' val='Y' new pub)
2020-05-07 12:38:15.608 [WARNING] CDR0000544267: Failed link target rule: /GlossaryTermName/TermNameStatus != "Rejected"
2020-05-07 12:38:15.608 [WARNING] CDR0000544267: Non-publishable version will be created.
2020-05-07 12:38:15.623 [INFO] save(544267, ver='Y' pub='N' val='Y' new ver)
2020-05-07 12:38:16.545 [WARNING] CDR0000544267: Failed link target rule: /GlossaryTermName/TermNameStatus != "Rejected"
2020-05-07 12:38:16.576 [WARNING] CDR0000544267: b'Failed link target rule: /GlossaryTermName/TermNameStatus != "Rejected"'
2020-05-07 12:38:20.984 [INFO] Processing CDR0000632567 [pub:47/last:47/cwd:47]
2020-05-07 12:38:21.000 [INFO] save(632567, ver='Y' pub='Y' val='Y' new pub)
2020-05-07 12:38:22.078 [WARNING] CDR0000632567: Element 'Comment': This element is not expected.
2020-05-07 12:38:22.093 [WARNING] CDR0000632567: Non-publishable version will be created.
2020-05-07 12:38:22.093 [WARNING] CDR0000632567: b"Element 'Comment': This element is not expected."
2020-05-07 12:38:26.468 [INFO] Processing CDR0000688302 [pub:20/last:20/cwd:20]
2020-05-07 12:38:26.484 [INFO] save(688302, ver='Y' pub='Y' val='Y' new pub)
2020-05-07 12:38:31.750 [INFO] Processing CDR0000767018 [pub:15/last:15/cwd:15]
2020-05-07 12:38:31.750 [INFO] save(767018, ver='Y' pub='Y' val='Y' new pub)
2020-05-07 12:38:32.828 [WARNING] CDR0000767018: Element 'Comment': This element is not expected.
2020-05-07 12:38:32.828 [WARNING] CDR0000767018: Non-publishable version will be created.
2020-05-07 12:38:32.828 [WARNING] CDR0000767018: b"Element 'Comment': This element is not expected."
2020-05-07 12:38:39.625 [INFO] Processing CDR0000767077 [pub:41/last:41/cwd:unversioned]
2020-05-07 12:38:39.625 [INFO] save(767077, ver='Y' pub='N' val='N' old cwd)
2020-05-07 12:38:40.578 [INFO] save(767077, ver='N' pub='N' val='Y' new cwd)
2020-05-07 12:38:48.610 [INFO] Processing CDR0000787910 [pub:39/last:39/cwd:unversioned]
2020-05-07 12:38:48.625 [INFO] save(787910, ver='Y' pub='N' val='N' old cwd)
2020-05-07 12:38:49.672 [INFO] save(787910, ver='N' pub='N' val='Y' new cwd)
2020-05-07 12:38:51.391 [INFO] Run completed.
   Docs examined    = 6
   Docs changed     = 6
   Versions changed = 11
   Could not lock   = 0
   Errors           = 0
   Time             = 0:00:50.172332
Specific versions saved:
  new cwd = 2
  new pub = 4
  new ver = 1
  old cwd = 3
Comment entered 2020-05-08 13:23:46 by Osei-Poku, William (NIH/NCI) [C]

Verified on DEV. Thanks!

Comment entered 2020-05-29 09:56:09 by Kline, Bob (NIH/NCI) [C]

Live mode run on QA:

2020-05-29 09:54:29.825 [INFO] Running in real mode, updating the database
2020-05-29 09:54:29.825 [INFO] Running on QA
2020-05-29 09:54:44.358 [INFO] 3 documents selected
2020-05-29 09:54:44.358 [INFO] Purpose: 'Capture old ProcessingStatus elements as comments (OCECDR-4816)'
2020-05-29 09:54:53.244 [INFO] Processing CDR0000544267 (BLOCKED) [pub:59/last:63/cwd:63]
2020-05-29 09:54:53.244 [INFO] save(544267, ver='Y' pub='Y' val='Y' new pub)
2020-05-29 09:54:55.610 [WARNING] CDR0000544267: Failed link target rule: /GlossaryTermName/TermNameStatus != "Rejected"
2020-05-29 09:54:55.610 [WARNING] CDR0000544267: Non-publishable version will be created.
2020-05-29 09:54:55.610 [INFO] save(544267, ver='Y' pub='N' val='Y' new ver)
2020-05-29 09:54:56.648 [WARNING] CDR0000544267: Failed link target rule: /GlossaryTermName/TermNameStatus != "Rejected"
2020-05-29 09:54:56.648 [WARNING] CDR0000544267: b'Failed link target rule: /GlossaryTermName/TermNameStatus != "Rejected"'
2020-05-29 09:55:01.775 [INFO] Processing CDR0000632567 [pub:45/last:45/cwd:45]
2020-05-29 09:55:01.775 [INFO] save(632567, ver='Y' pub='Y' val='Y' new pub)
2020-05-29 09:55:08.421 [INFO] Processing CDR0000688302 [pub:20/last:20/cwd:20]
2020-05-29 09:55:08.421 [INFO] save(688302, ver='Y' pub='Y' val='Y' new pub)
2020-05-29 09:55:11.174 [INFO] Run completed.
   Docs examined    = 3
   Docs changed     = 3
   Versions changed = 7
   Could not lock   = 0
   Errors           = 0
   Time             = 0:00:41.349399
Specific versions saved:
  new pub = 3
  new ver = 1
Comment entered 2020-06-11 11:39:30 by Osei-Poku, William (NIH/NCI) [C]

Verified on QA. Thanks!

Comment entered 2020-06-19 16:18:59 by Kline, Bob (NIH/NCI) [C]

Global completed in live mode on STAGE.

Comment entered 2020-06-23 18:09:05 by Kline, Bob (NIH/NCI) [C]

Global completed in live mode on PROD.

Comment entered 2020-06-23 18:18:52 by Kline, Bob (NIH/NCI) [C]

2020-06-23 18:06:10.346 [INFO] Running in real mode, updating the database
2020-06-23 18:06:10.346 [INFO] Running on PROD
2020-06-23 18:06:13.580 [INFO] 3 documents selected
2020-06-23 18:06:13.580 [INFO] Purpose: 'Capture old ProcessingStatus elements as comments (OCECDR-4816)'
2020-06-23 18:06:19.112 [INFO] Processing CDR0000544267 (BLOCKED) [pub:59/last:63/cwd:63]
2020-06-23 18:06:19.112 [INFO] save(544267, ver='Y' pub='Y' val='Y' new pub)
2020-06-23 18:06:20.112 [WARNING] CDR0000544267: Failed link target rule: /GlossaryTermName/TermNameStatus != "Rejected"
2020-06-23 18:06:20.112 [WARNING] CDR0000544267: Non-publishable version will be created.
2020-06-23 18:06:20.112 [INFO] save(544267, ver='Y' pub='N' val='Y' new ver)
2020-06-23 18:06:21.471 [WARNING] CDR0000544267: Failed link target rule: /GlossaryTermName/TermNameStatus != "Rejected"
2020-06-23 18:06:21.471 [WARNING] CDR0000544267: b'Failed link target rule: /GlossaryTermName/TermNameStatus != "Rejected"'
2020-06-23 18:06:25.049 [INFO] Processing CDR0000632567 [pub:45/last:45/cwd:45]
2020-06-23 18:06:25.049 [INFO] save(632567, ver='Y' pub='Y' val='Y' new pub)
2020-06-23 18:06:29.331 [INFO] Processing CDR0000688302 [pub:20/last:20/cwd:20]
2020-06-23 18:06:29.331 [INFO] save(688302, ver='Y' pub='Y' val='Y' new pub)
2020-06-23 18:06:31.066 [INFO] Run completed.
Docs examined = 3
Docs changed = 3
Versions changed = 7
Could not lock = 0
Errors = 0
Time = 0:00:20.719671
Specific versions saved:
new pub = 3
new ver = 1

Elapsed: 0:00:00.000565