SQLERRM : ORA-00904: invalid identifier
Article ID: 112559
Clarity PPM SaaS
Clarity PPM On Premise
Receive Error -
[CA Clarity][Oracle JDBC Driver][Oracle]ORA-20100: ENCOUNTERED EXCEPTION IN DWH_DIM_LOAD (<>)SQLERRM : ORA-00904: "<>": invalid identifier
Custom Object ID and one of its attributes has the same ID
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.