5 Replies Latest reply: May 15, 2013 6:15 AM by 814960 RSS

    ODI error occurs while flat file to oracle loading.

    811487
      Hi ,

      I have created a interface to load data from flat file to oracle. After execution i am getting follwoing

      ODI-1227: Task SrcSet0 (Loading) fails on the source FILE connection LOCAL.
      Caused By: java.sql.SQLException: File not found: C:\ODI/EMP
           at com.sunopsis.jdbc.driver.file.FileResultSet.<init>(FileResultSet.java:160)
           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:131)
           at com.sunopsis.sql.SnpsQuery.executeQuery(SnpsQuery.java:602)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeQuery(SnpSessTaskSql.java:3078)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execCollOrders(SnpSessTaskSql.java:571)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(SnpSessTaskSql.java:2815)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2515)
           at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:534)
           at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:449)
           at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1954)
           at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:322)
           at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:224)
           at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:246)
           at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:237)
           at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:794)
           at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:114)
           at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
           at java.lang.Thread.run(Thread.java:619)


      Please let me know how to overcome this.

      Edited by: 808484 on Nov 8, 2010 9:20 PM