Batch Validation Fails with the 'unique constraint (RXC.RESPONSE_PK_IDX) violated' error during TMS Processing.
(Doc ID 1568961.1)
Last updated on JULY 20, 2023
Applies to:Oracle Clinical - Version 4.6.0 and later
Information in this document applies to any platform.
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
It has been confirmed no duplicate response records exist (ie sql query in this note returns no rows).
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