SQLERRM : ORA-00904: invalid identifier 

Document ID : KB000112559
Last Modified Date : 05/09/2018
Show Technical Document Details
Issue:
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.