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 08, 2021
Applies to:Oracle Argus Mart - Version 8.1.3 and later
Information in this document applies to any platform.
While running Argus Mart Initial ETL from the ODI screen, below error is encountered:
"SCN_compile_schema_stage (InternalID:49)" is in error.
ODI-1526: Error encountered while trying to start scenario "SCN_compile_schema_stage001"
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.
Recently, a Restore Point was applied on the Argus Mart Database.
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