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 laterInformation 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
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 |