Argus Mart Initial ETL failed due to ORA-00001: unique constraint (AM_MART_USER.PK_RM_CFG_USER_ENTERPRISE_APPS) violated
(Doc ID 2954357.1)
Last updated on JULY 13, 2023
Applies to:
Oracle Life Sciences Argus Mart - Version 8.2.3 and laterInformation in this document applies to any platform.
Symptoms
The following error is being received when executing Argus Mart Initial ETL:
ODI-1519: Serial step "root_step (InternalID:472)" failed because child step "SCN_pop_cfg_user_enterprise_apps (InternalID:603)" is in error.
ODI-1217: Session SCN_pop_cfg_user_enterprise_apps (896) fails with return code 20010.
ODI-1226: Step PRC_pop_cfg_user_enterprise_apps fails after 1 attempt(s).
ODI-1232: Procedure PRC_pop_cfg_user_enterprise_apps execution fails.
ODI-1228: Task Procedure-PRC_pop_cfg_user_enterprise_apps-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_CFG_USER_ENTERPRISE_APPS) violated
ORA-06512: at "AM_MART_USER.PKG_SM_STORM", line 2176
-- ERROR while processing p_pop_cfg_user_enterprise_apps at 30-May-2023 14:20:20
ORA-06512: at "AM_MART_USER.PKG_SM_LOGGING", line 134
ORA-06512: at "AM_MART_USER.PKG_SM_STORM", line 2190
ORA-06512: at line 3
...
Caused by: Error : 20010, Position : 0, Sql = BEGIN
pkg_sm_stage_util.p_set_context(-1);
pkg_sm_storm.p_pop_cfg_user_enterprise_apps;
END;, OriginalSql = BEGIN
pkg_sm_stage_util.p_set_context(-1);
pkg_sm_storm.p_pop_cfg_user_enterprise_apps;
END;, Error Msg = ORA-20010: ORA-00001: unique constraint (AM_MART_USER.PK_RM_CFG_USER_ENTERPRISE_APPS) violated
ORA-06512: at "AM_MART_USER.PKG_SM_STORM", line 2176
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 |
| Cause |
| Solution |
| References |