Forum Stats

  • 3,815,263 Users
  • 2,258,987 Discussions
  • 7,893,019 Comments

Discussions

Getting error in ODI interface..

2690379
2690379 Member Posts: 3
edited Jul 15, 2014 10:06AM in Data Integrator

ODI-1227: Task SrcSet0 (Loading) fails on the source FILE connection FILE_GENERIC.

Caused By: 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)

Checked the source model and tried already to see view data in source model. Got same error message. I have checked the physical connection which connecting fine and schema definition is correct.

Please let me know how to fixed this error.

Tagged:

Answers

This discussion has been closed.