7 Replies Latest reply: Dec 4, 2012 9:36 AM by 948255 RSS

    ODI-40449: File not found error while Writing file to network location

    Sasmit
      Hi ,

      While executing scenario using OracleDIAgent , File not found error occurs .

      However when i execute same scenario using local agent of ODI Studio , I am able to write file on the network location .

      Should there be any additional configuration that needs to be done while executing scenario using OracleDIAgent wherein file needs to be placed at network path.

      The folder on network path has rights for 'Everyone' so I suppose problem ideally should not be about access rights.


      Error Message has been attached.

      ODI-1228: Task GL_LOAD_STATUS_ERROR_FILE_INT (Integration) fails on the target FILE connection GLLOAD_FILE_GENERIC2.
      Caused By: java.sql.SQLException: ODI-40449: File not found: \\usadev26\GL_LOAD/06074_ERROR_FILE.csv
           at com.sunopsis.jdbc.driver.file.FileTruncator.truncateFile(FileTruncator.java:40)
           at com.sunopsis.jdbc.driver.file.impl.commands.CommandTruncate.execute(CommandTruncate.java:39)
           at com.sunopsis.jdbc.driver.file.CommandExecutor.executeCommand(CommandExecutor.java:33)
           at com.sunopsis.jdbc.driver.file.FilePreparedStatement.execute(FilePreparedStatement.java:178)
           at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:163)
           at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:102)
           at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:1)
           at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)
           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:2093)
           at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1890)
           at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)
           at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
           at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)
           at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1066)
           at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
           at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:83)
           at java.lang.Thread.run(Thread.java:662)



      Thanks and Regards,
      Sasmit