Load Data Warehouse job failing: MODIFY INVESTMENT_NAME 15.9.3

Products

• Clarity PPM SaaS

Issue/Introduction

With the recent upgrade to 15.9.3.740 00 01 22 the Load Data Warehouse job is failing with error 

 

 Couldn't execute SQL: ALTER TABLE DWH_FIN_TRANSACTION MODIFY INVESTMENT_NAME VARCHAR(768)...

Cause

This may be caused by a change in the size of the investment_name table in 15.9.3.

Environment

Release :

Component :

Resolution

Run full load of the data warehouse to reset the size of the field.