This discussion is archived
7 Replies Latest reply: Dec 4, 2012 7:36 AM by 948255 RSS

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

Sasmit Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points