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 JULY 13, 2023

Applies to:

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


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(
at oracle.jdbc.driver.T4CTTIoer11.processError(
at oracle.jdbc.driver.T4C8Oall.processError(
at oracle.jdbc.driver.T4CTTIfun.receive(
at oracle.jdbc.driver.T4CTTIfun.doRPC(
at oracle.jdbc.driver.T4C8Oall.doOALL(
at oracle.jdbc.driver.T4CStatement.doOall8(
at oracle.jdbc.driver.T4CStatement.doOall8(
at oracle.jdbc.driver.T4CStatement.executeForRows(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OracleStatement.executeInternal(
at oracle.jdbc.driver.OracleStatement.execute(
at oracle.jdbc.driver.OracleStatementWrapper.execute(
at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(
at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute



 Recent MedDRA load.


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

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