Load DWH full fails with "ORA-00955: name is already used by an existing object"

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

The Load Data Warehouse - Full (DWH) job 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 

Environment

Release: 15.4.1
Component: Data Warehouse

Cause

Caused by DE39650
 

Resolution

Fixed in 15.5.

Workaround:

(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.

Additional Information

Reference also:

• Load DWH job failures - troubleshooting
• Data Warehouse (DWH) known issues
• Load DWH Full - When to run to prevent failures