Orphaned 'TMS IN PROGRESS' Discrepancies remain after retiring the TMS Related Derivation Procedure in Oracle Clinical.
Last updated on DECEMBER 19, 2016
Applies to:Oracle Clinical - Version 4.5.1 and later
Oracle Clinical Remote Data Capture Option - Version 4.5.3 and later
Oracle Thesaurus Management System - Version 4.5.1 and later
Information in this document applies to any platform.
1) Set up a TMS/OC Derivation configuration similar to below:
Questions in QG/DCM:
No Question Set assigned
Meddra Question Set assigned
Question AETRT in above is linked to MEDDRA Question Set
with linked derived Questions LLTL, LLTC, PTL, PTC, SOCL, SOCC, VERSION)
Derivation procedure was created to Derive values manually entered in AETERM directly into AETRT which is then validated against TMS Meddra Question Set to create omissions and
derive back data.
Later a change of design amended the definition to enter directly into AETRT so that AETERM was no longer required.
To do this switched the Question Set to Question AETRT from AETERM and retired question AETERM, and made derivation procedure that previously populated retired.
However this can result in TMS IN PROGRESS discrepancies against old parent/retired Question AETERM, which can no longer be updated/closed.
2) When this issue occurs then the following errors can also appear in the Remote Data Capture application => Data Entry Window :
The data entry window has encountered an unexpected error and
will shut down. If the problem recurs, please report the following
information for diagnostic purposes:
Log code xxxxxx, internal error
Invalid JSON received
and the log.xml / dump file contain errors like :
Exception Details:SQL Exception. Unable to proceed further.
oracle.pharma.rdc.de.exception.FailedOperationException: SQL Exception. Unable to proceed further.
Caused by: java.sql.SQLException: ORA-20001: Could not find data for discrep id xxxxxx
ORA-06512: at "RXC.OCL_DISC", line 576
ORA-06512: at "RXC.OCL_DISC", line 667
Retire a Derivation Procedure against a TMS Validated Question
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms