My Oracle Support Banner

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


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.