java.sql.SQLException: No more data to read from socket

Oracle Community | Hesh | 7 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    ODI XML error

    Oracle Community | 7 months ago | Hesh
    java.sql.SQLException: No more data to read from socket
  2. 0

    ODi - error loading xml file

    Oracle Community | 5 years ago | user2582704
    java.sql.SQLException: unexpected token: CALL

    Root Cause Analysis

    1. java.sql.SQLException

      No more data to read from socket

      at com.sunopsis.jdbc.driver.xml.SnpsXmlStatementRedirector.execute()
    2. com.sunopsis.jdbc
      SnpsXmlStatement.execute
      1. com.sunopsis.jdbc.driver.xml.SnpsXmlStatementRedirector.execute(SnpsXmlStatementRedirector.java:125)
      2. com.sunopsis.jdbc.driver.xml.SnpsXmlStatement.execute(SnpsXmlStatement.java:31)
      2 frames
    3. com.sunopsis.rdb
      SnpsRDBStructCreator.truncateStructure
      1. com.sunopsis.rdb.manager.SnpsRDBHelperOracle.truncateTable(SnpsRDBHelperOracle.java:153)
      2. com.sunopsis.rdb.manager.SnpsRDBStructCreator.truncateTable(SnpsRDBStructCreator.java:170)
      3. com.sunopsis.rdb.manager.SnpsRDBStructCreator.truncateStructure(SnpsRDBStructCreator.java:161)
      3 frames
    4. com.sunopsis.jdbc
      SnpsXmlPreparedStatement.execute
      1. com.sunopsis.jdbc.driver.xml.SnpsXmlSchema.truncate(SnpsXmlSchema.java:1734)
      2. com.sunopsis.jdbc.driver.xml.SnpsXmlFile.synchronizeFromFile(SnpsXmlFile.java:637)
      3. com.sunopsis.jdbc.driver.xml.SnpsXmlSchema.synchronizeSchema(SnpsXmlSchema.java:1688)
      4. com.sunopsis.jdbc.driver.xml.SnpsXmlConnection.internalExecute(SnpsXmlConnection.java:604)
      5. com.sunopsis.jdbc.driver.xml.SnpsXmlPreparedStatement.execute(SnpsXmlPreparedStatement.java:46)
      5 frames
    5. oracle.odi.runtime
      TaskExecutionHandler.handleTask
      1. oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:163)
      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
    6. 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:577)
      4. com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)
      5. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)
      6. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1930)
      6 frames
    7. oracle.odi.runtime
      StartScenRequestProcessor$2.doAction
      1. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)
      1 frame
    8. oracle.odi.core
      DwgObjectTemplate.execute
      1. oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
      1 frame
    9. 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:1073)
      3. oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
      4. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
      4 frames
    10. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:745)
      1 frame