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 Data Warehouse job failing: MODIFY INVESTMENT_NAME 15.9.3
Article ID: 222953
Updated On:
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.
Feedback
Yes
No
Powered by
