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 |
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.
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:
I ran a nightly publishing job on DEV. The partner documents aren't picked up anymore.
Any objections to push these changes to QA for additional testing (since QA is running Oersted like PROD)?
No objections from me.
OK with me.
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.
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