CDR Tickets

Issue Number 4938
Summary [Summary] Display appropriate denormalization error for missing LOE document
Created 2021-02-10 10:41:26
Issue Type Improvement
Submitted By Osei-Poku, William (NIH/NCI) [C]
Assigned To Englisch, Volker (NIH/NCI) [C]
Status Closed
Resolved 2021-02-10 19:37:58
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.284608
Description

We have just started creating new module documents for Patient Summaries and the B/U and RLSO QC reports do not work for these documents when the Genetics Editorial Board is selected (See attached error message). Changing the Board to other Editorial Boards allows us to retrieve the QC reports without any problem. Please modify the reports so they work with the PDQ Cancer Genetics Editorial Board.  

Sample docs on PROD:

803532
803534
803537
803540

Comment entered 2021-02-10 12:12:40 by Englisch, Volker (NIH/NCI) [C]

, is it intentional that the module is listed as a treatment summary but the board is the genetics board?

I'm looking at "Von Hippel-Landau Disease".

Comment entered 2021-02-10 12:24:04 by Osei-Poku, William (NIH/NCI) [C]

No. That must be an error. They should be typed as Genetics. Is that the cause of the error message?

Comment entered 2021-02-10 12:36:03 by Osei-Poku, William (NIH/NCI) [C]

  That appears to be the problem. Changing the Type to Genetics worked. Thanks for catching this.

Comment entered 2021-02-10 18:22:14 by Englisch, Volker (NIH/NCI) [C]

What happened is that the filter is looking for the LOE Summary document that's linked to the specified board.   If the specific summary were a Spanish document, the filter is looking for the TranslationOf element in order to identify the English board information because we don't have Spanish boards.  This check is only done for summary types with Spanish translations.  Since the document was marked as a Treatment summary, the system expected to find a Spanish LOE Summary but that does not exist for the Genetics board and that's the reason why the QC report failed.

I have added a test to display a more meaningful error message if we come across this situation again which hopefully will help us find the issue more quickly. I will therefore reopen this ticket to push the changes to PROD.

Comment entered 2021-02-10 19:37:50 by Englisch, Volker (NIH/NCI) [C]

The following filter has been modified:

This is ready for testing on DEV.

Comment entered 2021-02-10 19:55:56 by Osei-Poku, William (NIH/NCI) [C]

Verified on DEV. The new message is better. Thanks!

An error has occurred

filtering error: Spanish LOE translation missing for this summary type and board!

Comment entered 2021-02-11 20:40:35 by Englisch, Volker (NIH/NCI) [C]

I copied the changes to QA and ran summary QC and vendor output jobs.  There were no differences between the "before" and "after" output.

Please go ahead, , and double-check on QA before I'll move the changes to STAGE and PROD.

Comment entered 2021-02-25 09:23:34 by Osei-Poku, William (NIH/NCI) [C]

Verified on QA. Please copy to PROD. Thanks!

Comment entered 2021-02-25 12:02:20 by Englisch, Volker (NIH/NCI) [C]

The filter changes have been copied to PROD.

Comment entered 2021-03-04 10:16:50 by Osei-Poku, William (NIH/NCI) [C]

I am unable to confirm that this is working on PROD. Using this test document on PROD - CDR0000668479 and changing the board and summary type information, I get the same error as before. 

Comment entered 2021-03-04 13:27:13 by Englisch, Volker (NIH/NCI) [C]

I checked the filter making sure the changes did make it to PROD.  This appears to be the same error message as before but it's triggered by something else.  I will take a look after our meeting.

Comment entered 2021-03-18 00:57:07 by Englisch, Volker (NIH/NCI) [C]

Originally, the filter checked if a version of the LOE document existed which did not.  However, I should have checked if a publishable version of the LOE document exists.  I have now modified the internal SQL query and in addition improved the error message displayed slightly.

In addition, I've modified the Quick&Dirty QC report to ignore the error and display a hint of why the QC report is failing.  The required three additional filters to be modified:

  • CDR0000335424.xml - Filter title: Denormalization Filter: Summary

  • CDR0000699063.xml - Filter title: Denormalization Filter: Summary - QD

  • CDR0000409593.xml - Filter title: Copy XML for Summary Report

  • CDR0000434822.xml - Filter title: Module: QC Filter Templates - Summary
    https://github.com/NCIOCPL/cdr-server/commit/5898083

Please use CDR62902 to see the effect of the changes for the QD version of the report. This is ready for review on DEV.

Comment entered 2021-03-18 10:22:59 by Osei-Poku, William (NIH/NCI) [C]

Verified on DEV. Thanks!

Comment entered 2021-03-25 20:13:06 by Englisch, Volker (NIH/NCI) [C]

The filter changes have been copied to QA.

Please review on QA.

Comment entered 2021-03-25 20:46:07 by Englisch, Volker (NIH/NCI) [C]

All diff reports for the Summary and DIS QC reports came out without any differences.

Comment entered 2021-03-31 18:35:31 by Englisch, Volker (NIH/NCI) [C]

, please let me know when you are ready to have these filter changes copied to PROD.

Comment entered 2021-03-31 18:54:54 by Osei-Poku, William (NIH/NCI) [C]

Please proceed to copy it to PROD. Thanks!

Comment entered 2021-04-02 14:42:49 by Englisch, Volker (NIH/NCI) [C]

The filter changes have been copied to STAGE and PROD.  Please confirm and close this issue.

Comment entered 2021-04-06 12:35:26 by Osei-Poku, William (NIH/NCI) [C]

Verified on PROD. Thanks!

Attachments
File Name Posted User
GeneticsModuleErrorMessage.PNG 2021-03-04 10:16:35 Osei-Poku, William (NIH/NCI) [C]
Patient Module Error.png 2021-02-10 10:36:08 Osei-Poku, William (NIH/NCI) [C]

Elapsed: 0:00:00.000403