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. If you have results there ask the DBA to copy all the CREATE statements, modify the schema to the correct one, and then run them again DWH.
3. Once the objects are all created, truncate DWH_INTERNAL_MD
4. Re-run Load Data Warehouse - Full - this will complete successfully.