My Oracle Support Banner

Mart Incremental ETL Unique Constraint Error : ORA-20010: ORA-00001: unique constraint (AM_MART_USER.PK_RM_CASE_ACTIONS) violated (Doc ID 2739147.1)

Last updated on APRIL 22, 2021

Applies to:

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

Symptoms

Mart ETL is Failing with Unique Constraint Error

Failing at step 94 (PKG_INC_AM) with below error

ODI-1519: Serial step "root_step (InternalID:266)" failed because child step "PKG_INC_AM (InternalID:300)" is in error.
ODI-1217: Session PKG_INC_AM (42330) fails with return code 20010.
ODI-1226: Step PRC_populate_case_tables_RM_CASE_ACTIONS fails after 1 attempt(s).
ODI-1232: Procedure PRC_populate_case_tables_RM_CASE_ACTIONS execution fails.
ODI-1228: Task Procedure-PRC_populate_case_tables_RM_CASE_ACTIONS-Command 0 fails on the target connection DS_AM_ARGUSMART.
Caused By: java.sql.SQLException: ORA-20010: ORA-00001: unique constraint (AM_MART_USER.PK_RM_CASE_ACTIONS) violated
ORA-06512: at "AM_MART_USER.PKG_SM_STORM", line 2075

-- ERROR while processing p_populate_case_tables at 02-Nov-2020 08:36:27
ORA-06512: at "AM_MART_USER.PKG_SM_LOGGING", line 134
ORA-06512: at "AM_MART_USER.PKG_SM_STORM", line 2086
ORA-06512: at line 3

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:495)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:447)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1055)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:624)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:253)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:613)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:214)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:38)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:891)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1194)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1835)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1790)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:301)
at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:205)
at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute

 

Changes

 Recent MedDRA load.

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
 Restart the Failed Initial ETL (Rerun)
References


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