My Oracle Support Banner

Clinical One Data Load Fails with 'ORA-20002: Two records inserted with same unique/primary key but different data result in key violation' (Doc ID 2997847.1)

Last updated on JANUARY 12, 2024

Applies to:

Oracle Life Sciences Data Management Workbench - Version 3.2 and later
Information in this document applies to any platform.


On Oracle Life Sciences Data Management Workbench (DMW) 3.2 version,

When attempting to submit a Clinical One data load job,
the following error occurs:


The issue can be reproduced with the following steps:
1. Submit a Clinical One Data load job.
2. Verify the job status.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.