CDR Tickets

Issue Number 4530
Summary Audit Trail report broken
Created 2018-09-24 12:09:01
Issue Type Bug
Submitted By Osei-Poku, William (NIH/NCI) [C]
Assigned To Englisch, Volker (NIH/NCI) [C]
Status Closed
Resolved 2018-09-27 14:04:39
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.233519
Description

The audit trail report appears to be broken. Here is the error message displayed when you attempt to run the report.

Comment entered 2018-09-24 14:34:49 by Englisch, Volker (NIH/NCI) [C]

Is this a report run from XMetaL or from the Admin Interface?

Comment entered 2018-09-24 15:18:27 by Osei-Poku, William (NIH/NCI) [C]

From XMetal. Please see the attached screenshot.

Comment entered 2018-09-27 14:04:27 by Englisch, Volker (NIH/NCI) [C]

I'm wondering how often this report is being used. I'm thinking the report may have been broken since our SQL Server upgrade a couple of months ago.

Anyway, Bob helped me fixing the database access and the report is ready for review on DEV.
The following file has been updated:

  • AuditTrail.py [ cdr4530-audittrail 8697d7bf ]

Comment entered 2018-09-27 15:26:20 by Osei-Poku, William (NIH/NCI) [C]

The report does not get used often but it comes in handy when you need it.

Verified on DEV. Thanks!

Comment entered 2018-10-04 14:06:29 by Kline, Bob (NIH/NCI) [C]

will add a ticket for CBIIT to deploy this to the upper tiers.

Comment entered 2018-10-04 15:29:43 by Englisch, Volker (NIH/NCI) [C]

The Audit Trail report has been copied to QA.

Once you verified this report, , I will submit a ticket to CBIIT to move this fix along with the changes to OCECDR-4358 to STAGE and PROD.

Comment entered 2018-10-05 14:51:09 by Osei-Poku, William (NIH/NCI) [C]

Verified on QA. Thanks!

Comment entered 2018-10-05 17:17:59 by Englisch, Volker (NIH/NCI) [C]

The following file has been updated on STAGE and PROD:

Please verify on PROD and close this ticket.

Comment entered 2018-10-09 14:40:53 by Osei-Poku, William (NIH/NCI) [C]

Verified on PROD. Thank you!

Attachments
File Name Posted User
audit_trail_icon.JPG 2018-09-24 15:18:12 Osei-Poku, William (NIH/NCI) [C]
audit trail.png 2018-09-24 12:08:18 Osei-Poku, William (NIH/NCI) [C]

Elapsed: 0:00:00.001339