java.sql.SQLException: ODI-40438: File not found: \\swdvnazcifp0059\cerqt0581\JADE\LOGS\O_FORECASTLOAD_LOG /OUTLOOK_FORECAST_REJECTIONS.txt

Oracle Community | 2996902 | 10 months ago
  1. 0

    ODI Interface/Scenario Issue

    Oracle Community | 10 months ago | 2996902
    java.sql.SQLException: ODI-40438: File not found: \\swdvnazcifp0059\cerqt0581\JADE\LOGS\O_FORECASTLOAD_LOG /OUTLOOK_FORECAST_REJECTIONS.txt
  2. 0

    ODI 11.1.1.7 File Technology

    Oracle Community | 3 years ago | user11307717
    java.sql.SQLException: ODI-40438: File not found: C:\Holiday_ODI/Data_File/
  3. 0

    ODI ERROR

    Oracle Community | 3 years ago | 1060867
    java.sql.SQLException: ODI-40438: File not found: C:\Holiday_ODI/Data_File/
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    ODI Load File error (can't read heading rows)

    Oracle Community | 3 years ago | 862411
    java.sql.SQLException: ODI-40439: Could not read heading rows from file
  6. 0

    Getting error in ODI interface..

    Oracle Community | 2 years ago | 2690379
    java.sql.SQLException: ODI-40438: File not found: /interface/j_p4ul/TP4U8O/outgoing/customer_feed.csv

    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-40438: File not found: \\swdvnazcifp0059\cerqt0581\JADE\LOGS\O_FORECASTLOAD_LOG /OUTLOOK_FORECAST_REJECTIONS.txt

      at com.sunopsis.jdbc.driver.file.FileResultSet.<init>()
    2. com.sunopsis.jdbc
      FilePreparedStatement.executeQuery
      1. com.sunopsis.jdbc.driver.file.FileResultSet.<init>(FileResultSet.java:160)
      2. com.sunopsis.jdbc.driver.file.impl.commands.CommandSelect.execute(CommandSelect.java:57)
      3. com.sunopsis.jdbc.driver.file.CommandExecutor.executeCommand(CommandExecutor.java:33)
      4. com.sunopsis.jdbc.driver.file.FilePreparedStatement.executeQuery(FilePreparedStatement.java:135)
      4 frames
    3. oracle.odi.query
      JDBCTemplate.executeQuery
      1. oracle.odi.query.JDBCTemplate.executeQuery(JDBCTemplate.java:189)
      1 frame
    4. oracle.odi.runtime
      DataMovementTaskExecutionHandler.handleTask
      1. oracle.odi.runtime.agent.execution.sql.SQLDataProvider.readData(SQLDataProvider.java:94)
      2. oracle.odi.runtime.agent.execution.sql.SQLDataProvider.readData(SQLDataProvider.java:1)
      3. oracle.odi.runtime.agent.execution.DataMovementTaskExecutionHandler.handleTask(DataMovementTaskExecutionHandler.java:70)
      3 frames
    5. 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
    6. oracle.odi.runtime
      StartScenRequestProcessor$2.doAction
      1. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)
      1 frame
    7. oracle.odi.core
      DwgObjectTemplate.execute
      1. oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
      1 frame
    8. oracle.odi.runtime
      DefaultAgentTaskExecutor$1.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$1.run(DefaultAgentTaskExecutor.java:49)
      4 frames
    9. Spring Core
      SyncTaskExecutor.execute
      1. org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
      1 frame
    10. oracle.odi.runtime
      AgentServlet.doPost
      1. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)
      2. oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:92)
      3. oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83)
      4. oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:68)
      5. oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:562)
      6. oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:516)
      6 frames
    11. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
      2 frames
    12. Jetty Server
      SocketConnector$Connection.run
      1. org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)
      2. org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:389)
      3. org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
      4. org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
      5. org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
      6. org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417)
      7. org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
      8. org.mortbay.jetty.Server.handle(Server.java:326)
      9. org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:534)
      10. org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:879)
      11. org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:747)
      12. org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
      13. org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
      14. org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228)
      14 frames
    13. Jetty Util
      QueuedThreadPool$PoolThread.run
      1. org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:520)
      1 frame