Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am running a batch file to move files from local to sftp server using psftp.exe. It is executing fine in local machine. But when I run the file in publisher, job is going to infinite loop, never ending. I refered the following link.
http://unconventionalqlikview.tumblr.com/post/20920052130/qlikview-and-secure-ftp-sftp
So, can someone please figure it out?
Thanks,
Murali
Any idea about it?
Hi Murali,
I am facing the same issue. When I am running batch file from local it is executing successsfully and coping file . But When I tried to execute from publisher, it is showing running but not completing.
Can you please tell me whether you succeeded in this case?
Regards,
Kamakshi Suram
Hi ,
I rectified this issue.
When I am trying to execute batch file from publisher, batch file asked below pop up. Because of this reason qlikview job showing executing but not completing.
So I opened publisher server and executed batch file by presses Y for the first time. Now the Qlikview Job executed
successfully from publisher without any issues.
Batch file Pop up:
The server's host key is not cached in the registry. You
have no guarantee that the server is the computer you
think it is.
The server's rsa2 key fingerprint is:
ssh-rsa 2222 b2:56:91:c7:83:38:f8:bf:2a:9a:53:ab:bb:1d:e8:76
If you trust this host, enter "y" to add the key to
PuTTY's cache and carry on connecting.
If you want to carry on connecting just once, without
adding the key to the cache, enter "n".
If you do not trust this host, press Return to abandon the
connection.
Store key in cache? (y/n)
Regards,
Kamakshi Suram
Hi,
The issue you are facing is that Publisher doesn't know when psftp.exe is finished. This is best to run Windows commands.
Bill