SQLERRM : ORA-00904: invalid identifier
book
Article ID: 112559
calendar_today
Updated On:
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
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.
Feedback
thumb_up
Yes
thumb_down
No