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"

book

Article ID: 221608

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

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

Cause

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

Environment

Release : 15.9.2

Component : Clarity Data Warehouse (DWH)

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