CDR Tickets

Issue Number 4383
Summary [Media] Media Doc Publishing Report errors
Created 2018-01-12 10:35:34
Issue Type Bug
Submitted By Osei-Poku, William (NIH/NCI) [C]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2018-04-04 16:32:21
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.219701
Description

When selecting "Both" as the Audience parameter, it works fine. When selecting "Patient", there is a Python Script error. When selecting "Health Professional", an "Invalid Parameter Value Received" error occurs. This is both on QA and PROD.

Comment entered 2018-03-07 11:11:19 by Kline, Bob (NIH/NCI) [C]
Comment entered 2018-03-08 11:49:57 by Osei-Poku, William (NIH/NCI) [C]

Verified on QA. Thanks!

Comment entered 2018-04-03 18:27:29 by Osei-Poku, William (NIH/NCI) [C]

When you select "Health Professional", the report displays "Unrecognized audience" in the title and and the retrieved docs include both Patient and HP docs. The same error is on DEV as well. Also, the date range does not appear to work. A selection of 2018-02-01 and 2018-04-03 retrieves documents out of that range (This error appears to be happening only on QA).

Comment entered 2018-04-04 16:21:42 by Kline, Bob (NIH/NCI) [C]

The cosmetic problem with audience labeling has been fixed.

However the date selection is working exactly as it has since the report was first implemented back in 2006, in accordance with the specified requirements.

I am reasonably confident that if you bring up the version history report for any of the documents listed in the Published Media Documents report ...

... you'll find at least one job within the specified date range publishing a changed copy of the document to cancer.gov. Some (probably most) of the changes are triggered by new versions of the documents being published, but some are the result of other changes, such as modifications to export filters, alterations of linked documents, or other system factors.

If you want to change the requirements for this report, please open another ticket for a future release. Before doing so, you should probably consult with Kevin Broun and other users of the report to ensure that such changes do not break existing assumptions and dependencies.

Comment entered 2018-04-04 17:40:31 by Osei-Poku, William (NIH/NCI) [C]

The cosmetic problem with audience labeling has been fixed.

Verified.

However the date selection is working exactly as it has since the report was first implemented back in 2006, in accordance with the specified requirements.

This is right, the documents being picked up are the ones to be picked up but why is the report displaying an earlier date for the "Version Date" instead of the date of the last version, which appears to be what was in the requirements? I looked at the requirements in OCECDR-2727 and didn't see anything to indicate that the Version Date should be an earlier version. In the original document Margaret posted, the version date was labeled "Date of Last Version". Unless there have been changes over the years, I am not sure why an earlier date than the last version date would be displayed.

Comment entered 2018-04-04 17:48:54 by Kline, Bob (NIH/NCI) [C]

Did you actually look at the Version History report for the documents as I suggested?

Comment entered 2018-04-04 18:30:04 by Osei-Poku, William (NIH/NCI) [C]

I did and I did confirm above that the documents being retrieved are the right documents.

What I am not clear about is why in the Media Doc Publishing report, the date of the last version is not displayed but rather an earlier date than that is displayed. What is supposed to be displayed in the "Version Date" column? It seems to me that it should be the date of the last publishable version but that is not what is displayed and that is what I am trying to find out. If the earlier date is what is supposed to be displayed, then I have no further questions and we can consider the report verified on QA.

Comment entered 2018-04-04 18:34:53 by Kline, Bob (NIH/NCI) [C]

Give me an example of a document which has the wrong date.

Comment entered 2018-04-04 18:59:16 by Osei-Poku, William (NIH/NCI) [C]

When I run the report with the following date range 2018-02-01 and 2018-04-04 and "Both" selected for Audience, I get the attached results (partial screenshot). The very first document on the list 686617 has 2015-11-02 09:39 displayed in the "Version Date". The doc history of 686617, has the last publishable version date of 2018-04-02(V-15527. What I don't understand is why the Version Date column does not have 2018-04-02(V-15527 but instead has 2015-11-02 09:39 which indeed is in the doc history but it is earlier than the latest version date.

Comment entered 2018-04-04 19:55:30 by Kline, Bob (NIH/NCI) [C]

The headers of the columns of the Document Version History report actually mean something. The last column is not showing you different versions of the document but the dates and numbers of each of the different Vendor or Cancer.gov publishing jobs which have exported or pushed that version of the document.

The last version of CDR686616 (at least on QA) is version 7, which was created back in November of 2015.

Comment entered 2018-04-05 11:09:07 by Osei-Poku, William (NIH/NCI) [C]

Thanks! You are right about that. What I am still confused about is why CDR686616 with a last version date of 2015-11-02 is included in the report when I specified a date range of 2018-02-01 and 2018-04-04 and I suppose the date range is actually based on the publication date and not the document version date. Maybe we can talk about this in the CDR meeting today.

Comment entered 2018-04-05 11:15:02 by Kline, Bob (NIH/NCI) [C]

... I suppose the date range is actually based on the publication date and not the document version date ...

Right. Once again:

See my note above about changing the requirements.

Comment entered 2018-05-31 13:14:16 by Osei-Poku, William (NIH/NCI) [C]

Verified on PROD.

Attachments
File Name Posted User
MediaDocPublishReportDateIssues.JPG 2018-04-04 19:00:40 Osei-Poku, William (NIH/NCI) [C]
screenshot-1.png 2018-04-04 16:04:51 Kline, Bob (NIH/NCI) [C]
screenshot-2.png 2018-04-04 16:06:33 Kline, Bob (NIH/NCI) [C]
screenshot-3.png 2018-04-04 16:09:26 Kline, Bob (NIH/NCI) [C]
screenshot-4.png 2018-04-04 16:13:36 Kline, Bob (NIH/NCI) [C]
screenshot-5.png 2018-04-04 19:46:14 Kline, Bob (NIH/NCI) [C]

Elapsed: 0:00:00.001457