SQLERRM : ORA-00904: invalid identifier

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Receive Error - 
[CA Clarity][Oracle JDBC Driver][Oracle]ORA-20100: ENCOUNTERED EXCEPTION IN DWH_DIM_LOAD (<>)SQLERRM : ORA-00904: "<>": invalid identifier 

Environment

v15.4.1

Cause

Custom Object ID and one of its attributes has the same ID

Resolution

The fix is to avoid writing duplicate IDs to the DWH meta tables and related PPM views and indirectly breaking the load DWH job. 

Please make sure you use unique IDs between the Custom Object and its attributes.