TMS Derivation Fails with ORA-00001: Unique Constraint Error on RESPONSES_PK_IDX

(Doc ID 1307584.1)

Last updated on APRIL 07, 2011

Applies to:

Oracle Clinical - Version: 4.5.1 and later   [Release: 4.5 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:

Modified Univariate Validation Resolution
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


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