After attempting to run a Data Warehouse Full Load in an upgraded environment, the following error is seen:
Error occurred while processing domain attributes.
SQL error code: 904
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00904: "ATTRIBUTE_NAME": invalid identifier
Data warehouse is not up to date, DWH meta column ATTRIBUTE_NAME is not in DWH table TABLE_NAME hence quiting from domain updates
When reviewing the DWH database, the column is missing. It was not created by the Data Warehouse Full Load.
Release : 15.8.1
Component : CA PPM APPLICATION
Attempt to run the "Restore Domains" job to resolve the problem.