CDR Tickets

Issue Number 4261
Summary Unicode Decode Error in Notify_VOL Report
Created 2017-04-24 19:06:19
Issue Type Bug
Submitted By Englisch, Volker (NIH/NCI) [C]
Assigned To Englisch, Volker (NIH/NCI) [C]
Status Closed
Resolved 2017-04-26 19:08:36
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.207030
Description

The Notify_VOL report is created and submitted by email as part of the weekly publishing job. The HTML output includes the comment entered when the media document was versioned. It appears that in April users started using non-ASCII characters within the comments and the program is not setup to handle these characters properly. As a result the Notify_VOL report fails on PROD.

This is a bug that needs to be fixed soon.

Comment entered 2017-04-26 19:06:06 by Englisch, Volker (NIH/NCI) [C]

The report has been updated and tested on DEV and copied to QA. We will need to discuss how to get it through the tiers.

Comment entered 2017-04-27 15:53:56 by Englisch, Volker (NIH/NCI) [C]

As discussed at our status meeting, will create a publishable version of media documents with special characters (i.e. Spanish characters) in the comment. These media document versions should then get picked up with the report as part of the weekend publishing.

Comment entered 2017-05-01 21:43:48 by Osei-Poku, William (NIH/NCI) [C]

We updated several documents on QA last week but we didn't get the notification.

Comment entered 2017-05-02 10:12:17 by Englisch, Volker (NIH/NCI) [C]

That's because the publishing jobs are currently turned off on QA because the QA Gatekeeper system is used for testing clinical trials changes.

I will have to run the report manually.

Comment entered 2017-05-02 11:25:14 by Englisch, Volker (NIH/NCI) [C]

, I ran the report manually. You should be receiving the report from QA shortly.

Comment entered 2017-05-02 15:35:46 by Englisch, Volker (NIH/NCI) [C]

Assigning ticket to Bob in case a CDR hot-fix is happening during the time that I'm on vacation.

The change has been saved in subversion:

  • R14688: Notify_VOL.py

The program is part of the directory

  D:\cdr\Publishing
Comment entered 2017-05-03 12:17:17 by Osei-Poku, William (NIH/NCI) [C]

Verified on QA.

Comment entered 2017-05-03 13:10:24 by Englisch, Volker (NIH/NCI) [C]

, please note, once this program has been updated on PROD it needs to run for a specific time frame that CIAT is waiting for. Here are the instructions I submitted originally to CBIIT before I new we had a bug in the report:

Our publishing job failed last weekend and we need to manually rerun a missing report.
On the CDR production server nciws-p193-v please run the following job from the D-drive:

C:> d:
D:> cd \cdr\publishing
D:> Notify_VOL.py --livemode --startdate=2017-04-07 --enddate=2017-04-13

The above command will submit a report in an email.
Please attach the console output for me to confirm successful execution of the job.

Comment entered 2017-05-15 15:06:33 by Kline, Bob (NIH/NCI) [C]

The revised version of the program just landed on PROD.

Comment entered 2017-07-27 16:53:03 by Englisch, Volker (NIH/NCI) [C]

These changes are on PROD since May. Closing issue.

Elapsed: 0:00:00.001327