Load Data Warehouse job fails with ORA-00904 invalid identifier on a custom field

Document ID : KB000108003
Last Modified Date : 26/07/2018
Show Technical Document Details
Question:
I am running Load Data Warehouse - Full Load, and hitting a similar to this error on a custom field:
 
[CA Clarity][Oracle JDBC Driver][Oracle]ORA-20100: ENCOUNTERED EXCEPTION IN DWH_DIM_LOAD (DWH_INV_PROJECT). SQLERRM : ORA-00904: "CUSTOM_FIELD": invalid identifier
ORA-06512: at line 31
 
The name of the field and the object table may vary.
 
Answer:
This issue occurs sometimes when there is a mismatch in what's included in the DWH object View on the PPM side. Unchecking/checking the attribute triggers the view regeneration.
 
To resolve the problem:
  1. Connect to PPM UI - Administration - Objects
  2. Open the affected object
  3. Go to Attributes
  4. Find the attribute affected
  5. If it's unchecked, Enable it for Data Warehouse
  6. If it's checked, then uncheck it from being Enabled in Data Warehouse
  7. Now run Load Data Warehouse - Full Load