ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Load DWH 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 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 

Cause

Caused by DE39650
 

Environment

Release: 15.4.1
Component: Data Warehouse

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: