Topic "Unable to run winscp from Informatica (8.5.1) Session/WFM"

Author Message
andy g.

Guest


Hello Winscp gurus,

Greetings! I am looking at a weird situation here- when I run the winscp ver. 4.2.1 in a wsf file, it runs perfectly and downloads the remote SFtp server file to our secure client directory.

Following are the commands in the abc.wsf file-

Set ScriptShell = CreateObject("WScript.Shell")
ScriptShell.run "%comspec% /c ""c:\Program Files\WinSCP\WinSCP.com"" -console -script=" &scriptFile& " -log=" & scriptResults

I run above on dos command line- cscript abc.wsf, it runs fine and it shows scriptResults correctly. Also, how do we do know that remote file is copied correctly to our client directory since winscp doesn't return a safe exit code?
2009-04-14 10:36:08.721 Type: SSH_FXP_READDIR, Size: 22, Number: 524
< 2009-04-14 10:36:08.737 Type: SSH_FXP_NAME, Size: 209, Number: 524
> 2009-04-14 10:36:08.737 Type: SSH_FXP_READDIR, Size: 22, Number: 780
< 2009-04-14 10:36:08.784 Type: SSH_FXP_NAME, Size: 2661, Number: 780
> 2009-04-14 10:36:08.784 Type: SSH_FXP_READDIR, Size: 22, Number: 1036
< 2009-04-14 10:36:08.799 Type: SSH_FXP_STATUS, Size: 28, Number: 1036
< 2009-04-14 10:36:08.799 Status/error code: 1

However, when I run the same in a batch file in Informatica Pre session of Work Flow Manager, the winscp seems to never run and I see two blank lines inserted into the scriptResults log file of winscp. Am I doing something wrong in the batch file which disables the winscp?

All I am doing in batch file is calling the above command

myabc.bat
rem myabc.bat is called from Informatica WFM pre session

cscript abc.wsf


Please help,

Andy
Advertisements
ZMS, LLC

Guest


Andy,

This issue is more related to scheduler using winscp process which uses different windows user id from the one when winscp is installed.

The winscp uses .INI file for generating the key. Use INI as an option and point to winscp.ini.
Alternatively, use portable winscp which does not use INI file.

Read FAQ in this forum.

Thanks

R. Kumar
Zilch Medical Solutions, LLC
andy g.

Guest


hi, Kumar

ini configuration worked and the informatica scheduler is able to download the files successfully.


Andy
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 24512
Location: Prague, Czechia
Please read FAQ.
_________________
Martin Prikryl
Advertisements

You can post new topics in this forum






Search Site

What is WinSCP?

It is award-winning SFTP client, SCP client, FTPS client and FTP client integrated into one software program for file transfer to FTP server or secure SFTP server. [More]

And it's free!

Donate

About donations

$9   $19   $49   $99

About donations

Recommend

WinSCP Privacy Policy

WinSCP License