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

book

Article ID: 104988

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

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.
 

Environment

Release: CODFSS99000-15.4.1-PPM SAAS FedRAMP-Sandbox-Small Environment
Component:

Resolution

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.