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';
P_DBLINK => 'PPMDBLINK',
P_FULL_RELOAD => 'Y'
[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
Caused by DE39650, fixed in 15.5.
Release: CODFSS99000-15.4.1-PPM SAAS FedRAMP-Sandbox-Small Environment
(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.