0 Replies Latest reply on Nov 16, 2012 11:19 AM by 929250


      I am using LKM File to SQL and IKM Oracle Incremental Update. It gives me the following error in Loading SS_0 - Load data step.

      Return Code: 7000


      at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:7846)

      at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:7546)

      at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:7919)

      at com.sunopsis.sql.SnpsQuery.updateExecStatement(SnpsQuery.java)

      at com.sunopsis.sql.SnpsQuery.addBatch(SnpsQuery.java)

      at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execCollOrders(SnpSessTaskSql.java)

      at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(SnpSessTaskSql.java)

      at com.sunopsis.dwg.dbobj.SnpSessTaskSqlC.treatTaskTrt(SnpSessTaskSqlC.java)

      at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java)

      at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java)

      at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java)

      at com.sunopsis.dwg.cmd.DwgCommandSession.treatCommand(DwgCommandSession.java)

      at com.sunopsis.dwg.cmd.DwgCommandBase.execute(DwgCommandBase.java)

      at com.sunopsis.dwg.cmd.e.i(e.java)

      at com.sunopsis.dwg.cmd.g.y(g.java)

      at com.sunopsis.dwg.cmd.e.run(e.java)

      at java.lang.Thread.run(Unknown Source)

      While using LKM File to Oracle (SQLLDR) and IKM Oracle Incremental Update. It gives me the following error in Loading SS_0 - Call sqlldr step.

      Record 3: Rejected - Error on table ODI_STAGE.C$_0SRC_SCARS_ACTIVE, column C15_PRODUCT_INFO.
      Field in data file exceeds maximum length
      I am trying to load data from a file into oracle 10g using ODI. One column in the file is of huge size. I have declared it as varchar2(10000) in file structure. I get the corresponding errors when the declaration for that column in oracle table is as listed below.

      If its varchar2(2000) => ORA-12899: value too large for column "ODI_STAGE"."C$_0SRC_SCARS_ACTIVE"."C15_PRODUCT_INFO" (actual: 2052, maximum: 2000)

      If its varchar2(4000) => ORA-01461: can bind a LONG value only for insert into a LONG column

      If its long => ORA-00997: illegal use of LONG datatype

      If its clob => java.lang.NumberFormatException: For input string: "4294967295"

      I tried below options but no luck.


      ODI_ADDITIONAL_JAVA_OPTIONS=$ODI_ADDITIONAL_JAVA_OPTIONS "-Doracledatabasemetadata.get_lob_precision=false"

      Restart ODI and then retry and if the issue still persists please let know. Also could you confirm you are using the correct KM.

      Can you please help me with the field size error? As per my understanding we can hold 4GB data using CLOB datatype then why is it restricting us over this small value.

      Thanks in Advance.