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

Oracle Community | 2996902 | 1 year 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 Interface/Scenario Issue

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

    Using linux file as a source

    Oracle Community | 5 years ago | Sai
    java.sql.SQLException: ODI-40438: File not found: linux_001/DOC1_FAT/TR_Manual_KPI_09052012_1.csv
  6. 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

    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