Load Data Warehouse job fails with Error code ORA-00955

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

A full load of the Load Data Warehouse job failed with the following error message:

ORA-20100: ENCOUNTERED EXCEPTION IN DWH_DIM_LOAD (DWH_FIN_PLAN). SQLERRM : ORA-20100: ENCOUNTERED EXCEPTION WHILE INSERTING INTO DWH_INTERNAL_MD. SQLERRM : ORA-00955: name is already used by an existing object
ORA-06512: at line 41

Resolution

A subsequent full load completed without this error message.