TMS Derivation Fails with ORA-00001: Unique Constraint Error on RESPONSES_PK_IDX
(Doc ID 1307584.1)
Last updated on AUGUST 07, 2020
Applies to:Oracle Clinical - Version 4.5.1 and later
Information in this document applies to any platform.
When attempting to run the Batch Validation, the process fails in the TMS Derivation part with the following error:
No modified univariate question definitions since last execution.
TMS Thesaurus Validation Execution
calling TMS_OCL_DERV.DERIVATION first time
Error during TMS Thesaurus Validation
Batch Validation aborted due to an error
SQL error during TMS Thesaurus Validation: SQLERROR ORA-00001: unique constraint
(RXC.RESPONSE_PK_IDX) violated ORA-06512:
1. Log in to OC
2. Navigation: Conduct > Data Validation > Batch Validation
3. Select study and Submit Job
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document