CDR Tickets

Issue Number 3836
Summary Groundhog Day: Summary Module Publishing
Created 2014-12-05 15:24:13
Issue Type Bug
Submitted By Englisch, Volker (NIH/NCI) [C]
Assigned To Englisch, Volker (NIH/NCI) [C]
Status Closed
Resolved 2015-03-31 17:26:29
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.142788
Description

There exists a summary module that is being tried to be published every day since April 25th, 2013.
This summary module had been made publishable by accident back in April 2013 as a regular summary but it failed processing on Gatekeeper (the summary section is missing a mandatory Title element).
Every night, our publishing process is now checking if there exists a summary that has been created in the table pub_proc_cg (to go to Cancer.gov) but hasn't successfully been processed on Gatekeeper. This one document comes up every time.

We either will have to "clean up" the tables (send a remove request to GK) or find a way to exclude this (or similar) documents.

Comment entered 2014-12-05 15:28:37 by Englisch, Volker (NIH/NCI) [C]

I'm adding Robin as a watcher since I believe it's her summary and I'm sure Bob is thrilled to be the default assignee for this. :-)
We can talk about it and re-assign.

Comment entered 2014-12-05 15:39:39 by Juthe, Robin (NIH/NCI) [E]

What is the CDR ID?

Comment entered 2014-12-05 16:05:26 by Englisch, Volker (NIH/NCI) [C]

The CDR ID would be useful information, wouldn't it?
It's CDR743132 - Lynch Syndrome and Breast Cancer Risk [Module]

Comment entered 2015-03-31 17:26:19 by Englisch, Volker (NIH/NCI) [C]

I've updated the publishing document CDR178.xml on DEV to fix the SQL query.
I'm currently running a publishing test on DEV.

Comment entered 2015-04-01 19:49:41 by Englisch, Volker (NIH/NCI) [C]

The publishing job ran successfully on DEV with the expected result. Due to the NVCG work we aren't running publishing jobs on QA at this time. I could move the change to STAGE for another test or go directly to PROD.

Comment entered 2015-04-23 19:35:07 by Englisch, Volker (NIH/NCI) [C]

The publishing control document CDR178 has been copied to STAGE and PROD.
Since the weekend publishing job doesn't use the SQL query that was creating the problem we will have to wait until after Monday's nightly publishing job to confirm on PROD that the change is working properly.

Comment entered 2015-04-27 18:41:01 by Englisch, Volker (NIH/NCI) [C]

The nightly publishing job ran without including the module in the set of documents to be published on Monday.

Comment entered 2015-04-28 14:55:11 by Englisch, Volker (NIH/NCI) [C]

The publishing document has been versioned in SVN:

  • R13145: Primary.xml

Elapsed: 0:00:00.001758