ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Load DWH error: "Invalid column name" on custom field (SQL Server)
Article ID: 111744
Clarity PPM SaaSClarity PPM On Premise
Running the Load Data Warehouse - Full on Clarity with SQL server fails with the below 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 a mismatch in the PPM and DWH databases 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
Release: Any Database: SQL Server
In Clarity go to Objects -> <OBJECT NAME> -> Attributes and uncheck TEST_FIELD from being included in Data Warehouse. Unchecking the field forces the DWH_<OBJECT>_V to be rebuilt and it should no longer throw the above error message
Run a Full Load of the DWH job
Once it runs fine, we recommend enabling the field again out of peak hours and see if it goes through fine to the DWH database.