topic Re: Running a batch file: need help in QlikView

Running a batch file: need help

Mon, 26 Jan 2026 18:19:17 GMT

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

Re: Running a batch file: need help

Mon, 31 Dec 2012 07:35:40 GMT

Any idea about it?

Re: Running a batch file: need help

kamakshisuram — Mon, 21 Dec 2015 09:28:14 GMT

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

Re: Running a batch file: need help

kamakshisuram — Mon, 21 Dec 2015 11:01:43 GMT

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

Re: Running a batch file: need help

Bill_Britt — Wed, 23 Dec 2015 02:09:14 GMT

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