My Oracle Support Banner

TMS Derivation Fails with ORA-00001: Unique Constraint Error on RESPONSES_PK_IDX (Doc ID 1307584.1)

Last updated on JULY 19, 2023

Applies to:

Oracle Clinical - Version 4.5.1 and later
Information in this document applies to any platform.

Symptoms

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:


Steps:

1. Log in to OC
2. Navigation: Conduct > Data Validation > Batch Validation
3. Select study and Submit Job

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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