Load DWH Job Failure with Error ENCOUNTERED EXCEPTION WHILE INSERTING INTO DWH_ODF_Z_TEST. column "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 DWH Job fails with 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-run the load job.

Environment

Release : 15.9.2

Component :

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 for DWH.

4. Run the full DWH load.