Topic
  • No replies
geneK
geneK
7 Posts

Pinned topic Tips on how to get SFTP operator to work?

‏2011-03-04T00:52:37Z |
Hi folks,

I am trying to use the Secure FTP operator to automatically move a backup copy of my database to a production server (all Windows-based).

After considerable trial & error I managed to get the Secure FTP operator to work from within the Design Studio (i.e. on the Windows XP client workstation).

However when I deploy the same flow to the Windows 64-bit application server it fails without any diagnostic information.

I am using the public key authentication mechanism.

Dump of the server execution:
>>>
SQW03368I: Dumping variable values :
${BW_flow_var_group/DB2_backup_filename} =
${BW_flow_var_group/SFTP_passphrase} = ********
${BW_flow_var_group/SFTP_private_key_file} = D:\tmp\authorized_keys
...
SQW03267I: Start subprocess SFTP_tester_09.
Preparing command "D:\tmp\dir_list.bat"
SQW03201I: Command_04 task completed successfully
SQW03406E: Execution failed for activity SFTP tester_Secure_FTP_02
<<<

The "backup_filename" variable contains the filename of DB2 backup ... or at least it should (the name of the backup file is read during execution from a file generated by dir_list.bat).

As part of application deployment I created machine resource for the host asa "Plain Server", port 22, userid, and a dummy password "x" (which presumably is not being used by SFTP).

As a reference, here's the log from successful execution within Design Studio on the client machine:
>>>
Control-Flows Mar 3, 2011 7:46:48 PM SQW23001I: Connecting db2bwadm@db2bwvm.torolab.ibm.com on port 22
Control-Flows Mar 3, 2011 7:46:48 PM SQW23002I: Session opened.
Control-Flows Mar 3, 2011 7:46:48 PM cd "FTPhome"
Control-Flows Mar 3, 2011 7:46:48 PM put "D:\BW\Davor\testfile.txt"
Control-Flows Mar 3, 2011 7:46:48 PM PUT: D:\BW\Davor\testfile.txt
Control-Flows Mar 3, 2011 7:46:48 PM SQW23012I: Secured file transfer operation completed sucessfully.
Control-Flows Mar 3, 2011 7:46:49 PM
Control-Flows Mar 3, 2011 7:46:49 PM SQW03268I: End subprocess SFTP tester.
Control-Flows Mar 3, 2011 7:46:49 PM SQW03368I: Dumping variable values :
${BW_flow_var_group/DB2_backup_filename} = testfile.txt
${BW_flow_var_group/SFTP_passphrase} = ********
${BW_flow_var_group/SFTP_private_key_file} = D:\tmp\authorized_keys
<<<

Any suggestions?

Thanks in advance,

Gene