Load Data Warehouse - Full fails with ORA-00955: name is already used by an existing object

Document ID : KB000104988
Last Modified Date : 05/07/2018
Show Technical Document Details
Issue:
Load Data Warehouse - Full fails with error:
 
Executing ETL Job.
NJS-0401: Execution of job failed.
Oracle? - An error occurred executing this job entry :
Couldn't execute SQL: BEGIN
EXECUTE IMMEDIATE 'TRUNCATE TABLE DWH_CMN_ERROR_MESSAGE';
DWH_CFG_PRE_CONFIG_SP(
P_DBLINK => 'PPMDBLINK',
P_FULL_RELOAD => 'Y'
);
END;
 
[CA Clarity][Oracle JDBC Driver][Oracle]ORA-00955: name is already used by an existing object
ORA-06512: at "PPM_DWH.DWH_CFG_PRE_CONFIG_SP", line 42
ORA-06512: at line 3
 
Cause:
Caused by DE39650, fixed in 15.5.
 
Resolution:
Workaround:
(note this is usually a very rare occurrence)

1. Check table DWH_INTERNAL_MD on the DWH database for any records.
 
2. Re-run Load Data Warehouse - Full - this will complete successfully.