2 Replies Latest reply: Jun 14, 2013 1:19 AM by user5912565 RSS

    OdiOSCommand settings for SqlLdr ?

    user5912565

      I am getting this error trying to use LKM File to Oracle (SQLLDR) via an agent.

       

      com.sunopsis.dwg.function.SnpsFunctionBaseException: OS command returned 127.

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

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

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

          at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(SnpSessTaskSql.java)

       

      The error is returned by Call sqlldr step of above KM. Here is the code generated by ODI

       

      OdiOSCommand "-OUT_FILE=/path/sample_table.out" "-ERR_FILE=/path/sample_table.err"

      sqlldr "control='/path/sample_table.ctl'" "log='/path/sample_table.log'" userid=user/<@=snpRef.getInfo("DEST_PASS") @>@tnsentry

       

      All files (out, err, ctl) are created in the remote folder since I am able to call sqlldr succesfully from term only.

       

      Does it require any system changes?