Data Warehouse - failed with "Invalid column name" on custom field (SQL Server)

Document ID : KB000111744
Last Modified Date : 21/08/2018
Show Technical Document Details
Question:
Running Load Data Warehouse - Full on CA PPM with SQL server, it fails with error message:
 
2018/08/18 22:04:58 - User Defined Java Class.0 - 2018/08/18 22:04:58 - Oracle? - [CA Clarity][SQLServer JDBC Driver][SQLServer]Invalid column name 'TEST_FIELD'.  
 
This usually happens due to mismatch in PPM and DWH database on a custom field. If you check the object referenced by the bg-dwh log, you will be able to find a custom field "TEST_FIELD" in the object attributes
 
Answer:
To resolve the issue please connect to CA PPM UI - Objects - <OBJECT NAME> - Attributes and uncheck TEST_FIELD from being included in Data Warehouse.
Then run a Full Load and see how it goes.
 
Unchecking the field forces the DWH_<OBJECT>_V to be rebuild and it should no longer throw this message.
Once it runs fine, we recommend to enable the field again out of peak hours and see if it goes through fine to the DWH database.