6 Replies Latest reply on Aug 8, 2011 12:46 PM by GurcanOrhan

    12899 : 72000 : java.sql.BatchUpdateException: ORA-12899: value too large f

    835246
      Gurus,
      I am trying to load data from Source to Target,

      Length of TITLE COlumn in source is Varchar2(35) and Target it is Varchar2(80) but i dont why it is creating Varchar2(35) for C$ table and getting the below error.

      Please help me

      Below is the C$ table script:

      create table C$_0WC_PCM_RFI_F
      (
           C1_RFI_CREATED_DATE_WID     NUMBER(10) NULL,
           C2_INTEGRATION_ID     VARCHAR2(80) NULL,
           C3_RFI_CLOSED_DATE_WID     NUMBER(10) NULL,
           C4_RFI_CREATED_DATE     DATE NULL,
           C5_RFI_CLOSED_DATE     DATE NULL,
           C6_TITLE     VARCHAR2(35) NULL,
           C7_PROJECT_NAME     VARCHAR2(8) NULL,
           C12_CHANGE_NUMBER     VARCHAR2(8) NULL,
           C8_CONTRACT_NUMBER     VARCHAR2(12) NULL,
           C10_CONTRACT_TYPE     VARCHAR2(4) NULL,
           C9_STATUS     VARCHAR2(4) NULL,
           C11_APPROVED_COMPANY1     VARCHAR2(36) NULL
      )
      NOLOGGING

      I am getting below Error:
      12899 : 72000 : java.sql.BatchUpdateException: ORA-12899: value too large for column "BIW_STG_ODI"."C$_0WC_PCM_RFI_F"."C6_TITLE" (actual: 37, maximum: 35)
      12899 : 72000 : java.sql.SQLException: ORA-12899: value too large for column "BIW_STG_ODI"."C$_0WC_PCM_RFI_F"."C6_TITLE" (actual: 37, maximum: 35)

      java.sql.BatchUpdateException: ORA-12899: value too large for column "BIW_STG_ODI"."C$_0WC_PCM_RFI_F"."C6_TITLE" (actual: 37, maximum: 35)

           at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:629)
           at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9467)
           at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:211)
           at com.sunopsis.sql.SnpsQuery.executeBatch(SnpsQuery.java:527)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeUpdate(SnpSessTaskSql.java:3038)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execCollOrders(SnpSessTaskSql.java:729)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(SnpSessTaskSql.java:2815)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2515)
           at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:534)
           at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:449)
           at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1954)
           at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1818)
           at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:559)
           at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:224)
           at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:481)
           at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1040)
           at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:114)
           at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:49)
           at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
           at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)
           at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:93)
           at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:84)
           at oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:49)
           at oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:502)
           at oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:454)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
           at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)
           at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:389)
           at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
           at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
           at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
           at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417)
           at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
           at org.mortbay.jetty.Server.handle(Server.java:326)
           at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:534)
           at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:879)
           at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:747)
           at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
           at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
           at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228)
           at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:520)