The ODI ETL Fails With Error "ORA-12899: value too large for column "ODI_TGT_USER"."I$W_xxxxx"."PROJECT_DESCRIPTION" (actual: xxx, maximum: 255) " (Doc ID 2619471.1)

Last updated on DECEMBER 16, 2019

Applies to:

Symptoms

When attempting to run ETL through ODI,
the following error occurs.

ERROR
-----------------------
ODI-1217: Session P6_SCD_W_PROJECT_HD_PHYSICAL (10044) fails with return code ODI-1298.
ODI-1226: Step Physical_STEP fails after 1 attempt(s).
ODI-1240: Flow Physical_STEP fails while performing a Insert flow into I$ table-IKM Oracle Slowly Changing Dimension- operation. This flow loads target table W_PROJECT_HD.
ODI-1298: Serial task "SERIAL-MAP_MAIN- (10)" failed because child task "SERIAL-EU-PRIMAVERA_ANALYTICS_TGT_LS_UNIT (80)" is in error.
ODI-1298: Serial task "SERIAL-EU-PRIMAVERA_ANALYTICS_TGT_LS_UNIT (80)" failed because child task "Insert flow into I$ table-IKM Oracle Slowly Changing Dimension- (110)" is in error.
ODI-1228: Task Insert flow into I$ table-IKM Oracle Slowly Changing Dimension- fails on the target connection PRIMAVERA_ANALYTICS_TGT_DS.
Caused By: java.sql.SQLException: ORA-12899: value too large for column "ODI_TGT_USER"."I$W_AO07GRPO88NQ10467GB5RFIVEI"."PROJECT_DESCRIPTION" (actual: XXX, maximum: 255) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:495)
  at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:447)



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run ETL through ODI, and the ETL job is failed.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete the ETL successfully.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.