'ORA-12899: value too large for column' Error Is Signalled When Running ODI Integration Interface / Mapping When Transferring Data Including Mutli-bytes Characters (Doc ID 1909394.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Data Integrator - Version 11.1.1.3.0 and later
Information in this document applies to any platform.

Symptoms

The following message is signalled when running an ODI Integration Interface / Mapping loading multi-byte data from one database to another when both source and target columns have the same length:

ODI-1228: Task SrcSet0 (Loading) fails on the target ORACLE connection Target.
Caused By: java.sql.BatchUpdateException: ORA-12899: value too large for column "CDW_DW"."C$_0WC_PARTY_DS"."C6_CUST_CONTACT_717" (actual: 39, maximum: 36)

 at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:13349)
 at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:248)
 at oracle.odi.runtime.agent.execution.sql.BatchSQLCommand.execute(BatchSQLCommand.java:44)
 at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:102)
 at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:1)
 at oracle.odi.runtime.agent.execution.DataMovementTaskExecutionHandler.handleTask(DataMovementTaskExecutionHandler.java:87)
 at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)
 at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms