ORA-00001: Unique Constraint (RXC.RESPONSE_PK_IDX) Violated (Doc ID 466747.1)

Last updated on MAY 17, 2010

Applies to:

Oracle Clinical Remote Data Capture Option - Version: 4.5 and later   [Release: 4.5 and later ]
Information in this document applies to any platform.
***Checked for relevance on 17-May-2010***

Goal

Batch Data load is failing.
The resulting log file contains the error:


ORA-00001: unique constraint (RXC.RESPONSE_PK_IDX) violated


how can this be corrected?

 

Notes:
a) You are running OC 4.5.0

b) verified response_id sequence is over 10 digits via below query as DBA user:

 

select response_seq.nextval from dual;

 






Solution

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