CDR Tickets

Issue Number 5117
Summary [Summary] Legacy documents picked up for nightly publishing job
Created 2022-05-31 18:35:00
Issue Type Improvement
Submitted By Englisch, Volker (NIH/NCI) [C]
Assigned To Englisch, Volker (NIH/NCI) [C]
Status Closed
Resolved 2022-06-02 13:03:12
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.319305
Description

The legacy PDQ summaries (Liver cancer) are being picked up and processed during every nightly publishing job although they aren't going to be pushed to Cancer.gov.

We want to adjust our SQL query to exclude these legacy documents from getting processed each night since they will never be pushed again.

Comment entered 2022-06-02 13:02:53 by Englisch, Volker (NIH/NCI) [C]

I've updated the SELECT statement for the Summary document type of the publishing subset Interim-Export, use for our nightly publishing job.  This select statement is supposed to only select brand new summaries to be published during the week.  The following file has been updated:

Comment entered 2022-06-02 13:05:01 by Englisch, Volker (NIH/NCI) [C]

I ran a nightly publishing job on DEV.  The partner documents aren't picked up anymore.

Comment entered 2022-06-06 18:26:44 by Englisch, Volker (NIH/NCI) [C]

Any objections to push these changes to QA for additional testing (since QA is running Oersted like PROD)?

Comment entered 2022-06-06 18:40:12 by Kline, Bob (NIH/NCI) [C]

No objections from me.

Comment entered 2022-06-06 19:54:51 by Osei-Poku, William (NIH/NCI) [C]

OK with me.

Comment entered 2022-06-08 12:02:34 by Englisch, Volker (NIH/NCI) [C]

I copied the control document to QA and ran a nightly and weekend publishing job.  The diff showed only the expected changes to the nightly job.

I will go ahead and update the control document on STAGE and PROD.

Comment entered 2022-06-08 12:30:13 by Englisch, Volker (NIH/NCI) [C]

The control document has been copied to STAGE and PROD.  The branch has been merged into master.

I will close this ticket after the next successful nightly publishing job.

Elapsed: 0:00:00.002031