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 job fails with error ""column_name" is of type numeric but expression is of type character varying"


Article ID: 221608


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


Full Load Data Warehouse (DWH) Job fails with the below error.

Error ENCOUNTERED EXCEPTION WHILE INSERTING INTO DWH_ODF_Z_TEST. column "column_name" is of type numeric but expression is of type character varying


Caused by changing the type of the attribute from string to numeric without unchecking it for DWH and re-running the load DWH job.


Release : 15.9.2

Component : Clarity Data Warehouse (DWH)


  1. Uncheck include in DWH for the attribute which needs to be changed to a different data type.
  2. Run the full DWH load.
  3. Create the attribute with the new data type and include it in the DWH.
  4. Run the full DWH load.

Additional Information

See also: Data Warehouse (DWH) known issues