My Oracle Support Banner

Error Adding New Responses Entry(2).Msg:ORA-00001: Unique Constraint (RXC.RESPONSE) While Running Batch Validation (Doc ID 884545.1)

Last updated on FEBRUARY 06, 2019

Applies to:

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


Symptoms

-- Problem Statement:
On 4.5.0 in Production:
When running the Batch Validation process in OC,
the following error occurs in the Batch Log:

ERROR
Indicator Question Checks for Patients with modified data
0 new, 0 remain current, 0 became obsolete
Batch Validation aborted due to an error
Error adding new responses entry(2).Msg:ORA-00001: unique constraint (RXC.RESPONSE_PK_IDX) violated
.

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1) Logon to OC
2) Select Study
3) Run Batch Validation




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.