CDR Tickets

Issue Number 4761
Summary GTN and GTC Documents modified Report errors
Created 2020-01-14 21:13:33
Issue Type Bug
Submitted By Osei-Poku, William (NIH/NCI) [C]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2020-01-15 12:22:59
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.255091
Description

Both the GTC and GTN Documents Modified reports are not working as they should. They get stuck on Excel with the attached errors so no data is displayed.

Comment entered 2020-01-15 05:39:22 by Kline, Bob (NIH/NCI) [C]

Please attach one of the files to this ticket.

Comment entered 2020-01-15 09:18:41 by Osei-Poku, William (NIH/NCI) [C]
Comment entered 2020-01-15 12:22:59 by Kline, Bob (NIH/NCI) [C]

This was a bug which snuck in with version 3.0.2 of the openpyxl package. I have asked CBIIT (NCI-RITM0212231) to apply version 3.0.3, which fixes the bug. The bug pretty much broke all of the Excel reports. Fixed on DEV and QA.

Comment entered 2020-01-15 13:57:54 by Kline, Bob (NIH/NCI) [C]

Fixed on STAGE and PROD. Please verify.

Comment entered 2020-01-15 14:19:49 by Osei-Poku, William (NIH/NCI) [C]

Verified on PROD. Thanks!

Attachments
File Name Posted User
CDR_Administration-20200115091333.xlsx 2020-01-15 09:18:17 Osei-Poku, William (NIH/NCI) [C]
CDR_Administration-20200115091413.xlsx 2020-01-15 09:18:17 Osei-Poku, William (NIH/NCI) [C]
GTCDocumentsModifiedReport.PNG 2020-01-14 21:12:33 Osei-Poku, William (NIH/NCI) [C]
GTCDocumentsModifiedReport1.PNG 2020-01-14 21:12:33 Osei-Poku, William (NIH/NCI) [C]

Elapsed: 0:00:00.001410