My Oracle Support Banner

Batch Validation Fails with the 'unique constraint (RXC.RESPONSE_PK_IDX) violated' error during TMS Processing. (Doc ID 1568961.1)

Last updated on JULY 23, 2018

Applies to:

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

Symptoms

i.
Batch Validation fails with the following error :

TMS Thesaurus Validation Execution
exec_tms_procs second time
Derived questions exist for TMS. Calling TMS_OCL_DERV.DERIVATION second time
value of :last_tms_deriv_ts 08-JUL-2013 23:15:02
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:

ii.
It has been confirmed no duplicate response records exist (ie sql query in this note returns no rows).

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
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.