java.sql.SQLException

tip

If you're using an agent, it might not have access privileges over this file, consider not using one or changing it. If you're using one, try to use an agent that might have this privilege.

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • Getting error in ODI interface..
    via by 2690379,
  • Issue with UNIX Flat file
    via by 885714,
  • Using linux file as a source
    via by Sai,
  • ODI 11.1.1.7 File Technology
    via by user11307717,
  • ODI ERROR
    via by 1060867,
  • ODI Interface/Scenario Issue
    via by 2996902,
  • Reg : Knowledge Module
    via by user132819,
    • java.sql.SQLException: ODI-40438: File not found: /interface/j_p4ul/TP4U8O/outgoing/customer_feed.csv at com.sunopsis.jdbc.driver.file.FileResultSet.<init>(FileResultSet.java:162) at com.sunopsis.jdbc.driver.file.impl.commands.CommandSelect.execute(CommandSelect.java:57) at com.sunopsis.jdbc.driver.file.CommandExecutor.executeCommand(CommandExecutor.java:33) at com.sunopsis.jdbc.driver.file.FilePreparedStatement.executeQuery(FilePreparedStatement.java:135) at oracle.odi.query.JDBCTemplate.executeQuery(JDBCTemplate.java:189) at oracle.odi.runtime.agent.execution.sql.SQLDataProvider.readData(SQLDataProvider.java:89) at oracle.odi.runtime.agent.execution.DataMovementTaskExecutionHandler.handleTask(DataMovementTaskExecutionHandler.java:70) at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2926) at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2638) at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:561) at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:464) at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2078) at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:368) at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216) at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:302) at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:294) at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:865) at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126) at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:86) at java.lang.Thread.run(Thread.java:662)

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,