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

Advertisement

andy g.
Guest

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

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

Reply with quote

Advertisement

ZMS, LLC
Guest

Re: Informatica Session

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

Reply with quote

andy g.
Guest

thanks!

hi, Kumar

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


Andy

Reply with quote

Advertisement

You can post new topics in this forum