My Oracle Support Banner

Transformation Execution Runs Multiple Times and Fails With ORA-20002: Two records inserted with same unique/primary key but different data result in key violation (Doc ID 2520066.1)

Last updated on OCTOBER 09, 2019

Applies to:

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

Symptoms

On Oracle Health Sciences Data Management Workbench (DMW) 2.4.7 version,

Transformation execution is submitted multiple times and fails with ORA-20002: Two records inserted with same unique/primary key but different data result in key violation.

Changes

DMW creates multiple LSH Program Instances for one DMW Transformation.

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
Changes
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.