2 Replies Latest reply: Mar 26, 2012 9:25 AM by Drona RSS

    LKM SAP ERP to Oracle (SQLLDR) - ERROR!!!

    642770
      Hi ,
      I have error on the step Extract Data with this error

      oracle.odi.sdk.opentools.OpenToolExecutionException: Error occured in open tool execute methodError in executing ABAP programUnable to connect FTP. Check ABAP program
           at oracle.odi.sap.km._OdiSapAbapExecute.execute(_OdiSapAbapExecute.java:466)
           at com.sunopsis.dwg.function.SnpsOpenToolFunction.actionExecute(SnpsOpenToolFunction.java)
           at com.sunopsis.dwg.function.SnpsOpenToolFunction.execute(SnpsOpenToolFunction.java)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(SnpSessTaskSql.java)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(SnpSessTaskSql.java)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSqlC.treatTaskTrt(SnpSessTaskSqlC.java)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java)
           at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java)
           at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java)
           at com.sunopsis.dwg.cmd.DwgCommandSession.treatCommand(DwgCommandSession.java)
           at com.sunopsis.dwg.cmd.DwgCommandBase.execute(DwgCommandBase.java)
           at com.sunopsis.dwg.cmd.e.j(e.java)
           at com.sunopsis.dwg.cmd.g.z(g.java)
           at com.sunopsis.dwg.cmd.e.run(e.java)
           at java.lang.Thread.run(Thread.java:619)

      and the description of ABAB code is ( cut from the whole ABAB code to show you the part of FTP Coding on ABAB language)

      CALL FUNCTION 'FTP_CONNECT'

      EXPORTING
           
      user = 'odiadmin'

      password = 'odiadmin'

      host = '10.8.61.200'

      rfc_destination = 'SAPFTPA'

      IMPORTING

      handle = lv_hdl

      EXCEPTIONS

      not_connected = 1

      OTHERS = 2.

      IF sy-subrc <> 0.

      clear et_file_return.

      et_file_return-TYPE = gc_error.

      et_file_return-message = 'Unable to connect FTP.'.

      Append et_file_return.

      ELSE.

      IF NOT lc_pasv IS INITIAL.

      REFRESH lt_result.

      lv_cmd = lc_cmd1.

      CALL FUNCTION 'FTP_COMMAND'

      EXPORTING

      handle = lv_hdl

      command = lv_cmd

      TABLES

      data = lt_result

      EXCEPTIONS

      tcpip_error = 1

      command_error = 2

      data_error = 3.

      IF sy-subrc <> 0.

      clear et_file_return.

      et_file_return-TYPE = gc_error.

      et_file_return-message = 'Error in passing FTP .'.

      Append et_file_return.

      ENDIF.

      CALL FUNCTION 'FTP_R3_TO_CLIENT'

      EXPORTING

      fname = iv_filename

      rfc_destination = lc_dest

      character_mode = lc_pasv

      TABLES

      text = gt_result

      EXCEPTIONS

      command_error = 1

      data_error = 2

      OTHERS = 3.

      IF sy-subrc <> 0.

      clear et_file_return.

      et_file_return-TYPE = gc_error.

      et_file_return-message = 'Error passing data to FTP .'.

      Append et_file_return.

      ENDIF.

      free : gt_result.

      CONCATENATE lc_cmd2 iv_filename

      INTO lv_cmd SEPARATED BY ' '.

      REFRESH lt_result.

      CALL FUNCTION 'FTP_COMMAND'

      EXPORTING

      handle = lv_hdl

      command = lv_cmd

      TABLES

      data = lt_result

      EXCEPTIONS

      tcpip_error = 1

      command_error = 2

      data_error = 3.

      IF sy-subrc NE 0.

      clear et_file_return.

      et_file_return-TYPE = gc_error.

      et_file_return-message = 'Error in passing FTP .'.

      Append et_file_return.

      EXIT.

      ELSE.

      clear et_file_return.

      et_file_return-TYPE = gc_success.

      et_file_return-message = 'Data Transfer Successful'.

      Append et_file_return.

      ENDIF.

      ELSE.

      clear et_file_return.

      et_file_return-TYPE = gc_error.

      et_file_return-message = 'No data Available.'.

      Append et_file_return.

      CALL FUNCTION 'FTP_DISCONNECT'

      EXPORTING

      handle = lv_hdl.

      CALL FUNCTION 'RFC_CONNECTION_CLOSE'

      EXPORTING

      destination = lc_dest

      EXCEPTIONS

      OTHERS = 1.

      IF sy-subrc <> 0.

      clear et_file_return.

      et_file_return-TYPE = gc_error.

      et_file_return-message = 'Error in RFC connection.'.

      Append et_file_return.

      ENDIF.

      ENDIF.

      ENDIF.

      ELSE.

      clear et_file_return.

      et_file_return-TYPE = gc_error.

      et_file_return-message =

      'Installed ABAP program does not match interface definition'.

      Append et_file_return.

      ENDIF."

      it seem that the error stop on the first exception that will return the message "Unable to connect FTP Server"

      I don't know why ,
      This SAP is 4.6C

      Thanks

      Edited by: somchai on Sep 16, 2009 11:27 PM