ORA-00001: Unique Constraint (RXC.RESPONSE_PK_IDX) Violated
Last updated on MAY 17, 2010
Applies to:Oracle Clinical Remote Data Capture Option - Version: 4.5
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