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


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?


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;



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