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.
Release: MSPPPM99000-15.5-PPM-Core License-MSP
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:
This can also happen if an attribute is deleted from the UI before being removed from the data warehouse.
Before you delete an attribute make sure it is not included in the data warehouse and the Load DWH job has run to ensure it has come out.