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 | 3 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    ODI issue with java.Integer overflow

    Oracle Community | 3 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 | 1 year 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 | 1 year 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