My Oracle Support Banner

Argus Mart Initial ETL fails with ODI Error - ORA-00001: unique constraint (AMODI_ODI_REPO.PK_SESSION) violated (Doc ID 2776526.1)

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences Argus Mart - Version 8.1.3 and later
Information in this document applies to any platform.

Symptoms

While running Argus Mart Initial ETL from the ODI screen, below error is encountered:  

ODI-1519: Serial step "root_step (InternalID:2)" failed because child step
"SCN_compile_schema_stage (InternalID:49)" is in error.
ODI-1526: Error encountered while trying to start scenario "SCN_compile_schema_stage001"
(step "SCN_compile_schema_stage"):
ODI-1219: Session preparation failure: database error while connecting to work repository WORKREP.
Caused By: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (AMODI_ODI_REPO.PK_SESSION) violated.  

Changes

Recently, a Restore Point was applied on the Argus Mart Database.

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

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