I am running Load Data Warehouse (DWH) - 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
Note: The name of the field and the object table may vary.
Release: All Supported Releases
Component: Clarity Data Warehouse (DWH)
Uncheck/check the attribute to trigger the view regeneration:
How to prevent this issue from happening?
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.
Tip: To find out which attribute a lookup is associated with see: Load DWH is failing on a custom lookup, how to find out which attribute to disable?