Operating system comand to copy files in Unix through ODI
rosy91Aug 21 2012 — edited Aug 21 2012HI All,
I am using ODI 11 and Oracle 11 g.
I need to copy some files and put in another folder using the OS command as
“cp /dean/sc/ready_file_*.dat /dean/sc/lony”
But when i execute the OS command in ODI it gives error as
ODI-1226: Step OS Command 1 fails after 1 attempt(s).
ODI-1242: Operating system command execution fails.
at com.sunopsis.dwg.dbobj.SnpSessTaskSqlS.getExceptionOnStepTaskFailure(SnpSessTaskSqlS.java:49)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatStepTaskError(SnpSessStep.java:1101)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:575)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:464)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:366)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:300)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:292)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:855)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
at java.lang.Thread.run(Thread.java:736)
Plz suggest any inputs.
Thanks,
Lony