1 Reply Latest reply on Apr 9, 2014 7:47 AM by Phanikanth

    ODI MS SQLSERVER TO ORACLE -  ODI-30038: OS command returned 127

    Venkata Rachuri

      Hi Experts,

       

      I have a table with three rows in Microsoft sqlserver. I am trying to load the table into Oracle. My  interface execution is failing at step 7. BCP out data to temporary bcp file


      Code for the STEP :


      OdiOSCommand -ERR_FILE=/tmp/X70011.out.err  -OUT_FILE=/tmp/X70011.out.log

      bcp  Hydra.dbo.C$_0GLOBAL_REGIONS out /tmp/X70011.bcp  -c   -SSRVHOUDHTSQL03 -Uappdev -P<@=snpRef.getInfo("SRC_PASS") @>   -t\b 

       

       

      Error :

       

       

      I am using LKM  = LKM MSSQL to Oracle(BCP/SQLLDR)

                      IKM=  IKM Oracle Incremental update.

       

      Any help is appreciated

       

       

      Error :

       

      com.sunopsis.dwg.function.SnpsFunctionBaseException: ODI-30038: OS command returned 127.

          at com.sunopsis.dwg.tools.OSCommand.actionExecute(OSCommand.java:294)

          at com.sunopsis.dwg.function.SnpsFunctionBase.execute(SnpsFunctionBase.java:276)

          at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(SnpSessTaskSql.java:3437)

          at com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeOdiCommand(SnpSessTaskSql.java:1509)

          at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:44)

          at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.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:577)

          at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)

          at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)

          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:662)

       

       

       

       

      Thanks

      Venkat