2 Replies Latest reply on Jun 14, 2013 6:19 AM by user5912565

    OdiOSCommand settings for SqlLdr ?


      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?