After Upgrade of ODI From 11g To ODI 12.2.1.1.0, a Mapping Fails While Inserting the Records Into the C$ table with Error "ORA-01438: value larger than specified precision allowed for this column" (Doc ID 2228420.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Data Integrator - Version 12.2.1.1.0 to 12.2.1.1.0 [Release 12c]
Information in this document applies to any platform.

Symptoms

A Mapping upgraded from Oracle Data Integrator (ODI) 11g to ODI 12.2.1.1.0 fails while inserting the records into the C$ table:

Caused By: java.sql.BatchUpdateException: ORA-01438: value larger than specified precision allowed for this column

  at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:15709)
  at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:264)
  at oracle.odi.runtime.agent.execution.sql.BatchSQLCommand.executeBatch(BatchSQLCommand.java:110)
  at oracle.odi.runtime.agent.execution.sql.BatchSQLCommand.execute(BatchSQLCommand.java:68)
  at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:141)
  at ...

 

Changes

 

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