java.sql.SQLException: ODI-40768: Could not save the file /tmp/customer-0-0.xml because a class java.sql.SQLException occurred and said: java.sql.SQLException: java.sql.SQLException: incompatible data type in conversion: from SQL type NUMERIC to java.lang.Integer, value: 3782511387

Oracle Community | user775218 | 2 years ago
  1. 0

    ODI issue with java.Integer overflow

    Oracle Community | 2 years ago | user775218
    java.sql.SQLException: ODI-40768: Could not save the file /tmp/customer-0-0.xml because a class java.sql.SQLException occurred and said: java.sql.SQLException: java.sql.SQLException: incompatible data type in conversion: from SQL type NUMERIC to java.lang.Integer, value: 3782511387
  2. 0

    ODI - XML FILE

    Oracle Community | 3 years ago | 3d606779-4d2f-42d9-b015-c7423ab5347a
    java.sql.SQLException: ODI-15227: Multiple keys found on table PROPERTYSET
  3. 0

    db:: 4.47::ODI -1228 - Error while writing data into Integration Tool zs

    hivmr.com | 11 months ago
    java.sql.SQLException: ODI-40768: Could not save the file default:C:\DATA_FILE\www.xml because a class java.io.IOException occurred and said: The filename, directory name, or volume label syntax is incorrect
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    db:: 5.31::ODI-1228: Task emp(Integration) fails on the target ORACLE connection Target zj

    hivmr.com | 8 months ago
    java.sql.SQLException: ODI-40768: Could not save the file default:C:\DATA_FILE\www.xml because a class java.io.IOException occurred and said: The filename, directory name, or volume label syntax is incorrect
  6. 0

    issue to load data from database to XML file. error: ODI-40768

    Oracle Community | 5 years ago | 778223
    java.sql.SQLException: ODI-40768: Could not save the file <default>:C:\DATA_FILE\www.xml because a class java.io.IOException occurred and said: The filename, directory name, or volume label syntax is incorrect

    1 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.SQLException

      ODI-40768: Could not save the file /tmp/customer-0-0.xml because a class java.sql.SQLException occurred and said: java.sql.SQLException: java.sql.SQLException: incompatible data type in conversion: from SQL type NUMERIC to java.lang.Integer, value: 3782511387

      at com.sunopsis.jdbc.driver.xml.SnpsXmlFile.writeToFile()
    2. com.sunopsis.jdbc
      SnpsXmlPreparedStatement.execute
      1. com.sunopsis.jdbc.driver.xml.SnpsXmlFile.writeToFile(SnpsXmlFile.java:751)
      2. com.sunopsis.jdbc.driver.xml.SnpsXmlConnection.internalExecute(SnpsXmlConnection.java:769)
      3. com.sunopsis.jdbc.driver.xml.SnpsXmlPreparedStatement.execute(SnpsXmlPreparedStatement.java:46)
      3 frames
    3. oracle.odi.runtime
      TaskExecutionHandler.handleTask
      1. oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:166)
      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.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)
      4 frames
    4. com.sunopsis.dwg
      SnpSession.treatSession
      1. com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2906)
      2. com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2609)
      3. com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:540)
      4. com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:453)
      5. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1740)
      6. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1596)
      6 frames
    5. oracle.odi.runtime
      StartScenRequestProcessor$2.doAction
      1. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:582)
      1 frame
    6. oracle.odi.core
      DwgObjectTemplate.execute
      1. oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:214)
      1 frame
    7. oracle.odi.runtime
      DefaultAgentTaskExecutor$2.run
      1. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)
      2. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1070)
      3. oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:123)
      4. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:83)
      4 frames
    8. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:662)
      1 frame