java.sql.BatchUpdateException: ORA-12899: value too large for column "KDD_EPMA_WB"."C$_0ASO_ACT_INTERMEDIATE_DATA"."C2_CUST_CODE" (actual: 12, maximum: 10)

Oracle Community | 994472 | 11 months ago
  1. 0

    Worktable Column size error

    Oracle Community | 11 months ago | 994472
    java.sql.BatchUpdateException: ORA-12899: value too large for column "KDD_EPMA_WB"."C$_0ASO_ACT_INTERMEDIATE_DATA"."C2_CUST_CODE" (actual: 12, maximum: 10)
  2. 0

    Error while loading from Netezza to Oracle

    Oracle Community | 3 years ago | pt_user1
    java.sql.BatchUpdateException: ORA-12899: value too large for column "ODI"."C$_0ABC"."C8_TERM" (actual: 119, maximum: 100)
  3. 0

    value larger than specified precision Error

    Oracle Community | 3 years ago | bfc139a0-c9f1-40e0-ad6b-aa65987ecf90
    java.sql.BatchUpdateException: ORA-01438: value larger than specified precision allowed for this column
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    ODI-1241: Oracle Data Integrator tool execution fails.

    Oracle Community | 2 months ago | 3236194
    java.sql.BatchUpdateException: IO Error: Connection reset
  6. 0

    FDMEE loading data to People Soft error out

    Oracle Community | 9 months ago | 1059384
    java.sql.BatchUpdateException: ORA-01031: insufficient privileges

  1. r1chjames 10 times, last 6 months ago
12 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.BatchUpdateException

    ORA-12899: value too large for column "KDD_EPMA_WB"."C$_0ASO_ACT_INTERMEDIATE_DATA"."C2_CUST_CODE" (actual: 12, maximum: 10)

    at oracle.jdbc.driver.OraclePreparedStatement.executeBatch()
  2. Oracle jdbc
    OracleStatementWrapper.executeBatch
    1. oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:13349)
    2. oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:248)
    2 frames
  3. oracle.odi.runtime
    DataMovementTaskExecutionHandler.handleTask
    1. oracle.odi.runtime.agent.execution.sql.BatchSQLCommand.execute(BatchSQLCommand.java:44)
    2. oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:102)
    3. oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:1)
    4. oracle.odi.runtime.agent.execution.DataMovementTaskExecutionHandler.handleTask(DataMovementTaskExecutionHandler.java:87)
    4 frames
  4. com.sunopsis.dwg
    SnpSession.treatSession
    1. com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)
    2. com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)
    3. com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:558)
    4. com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:464)
    5. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)
    5 frames
  5. oracle.odi.runtime
    StartSessRequestProcessor$2.doAction
    1. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:366)
    1 frame
  6. oracle.odi.core
    DwgObjectTemplate.execute
    1. oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
    1 frame
  7. oracle.odi.runtime
    DefaultAgentTaskExecutor$2.run
    1. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:300)
    2. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:292)
    3. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:855)
    4. oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
    5. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
    5 frames
  8. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:662)
    1 frame