Load DWH job fails with error ""column_name" is of type numeric but expression is of type character varying"

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

The 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 

Environment

Release : Any

Cause

This happens when you change the type of an attribute from string to numeric without unchecking it for DWH and re-running the load DWH job.

Resolution

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