Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Running a batch file: need help

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

4 Replies
Not applicable

Re: Running a batch file: need help

Any idea about it?

kamakshisuram
Contributor

Re: Running a batch file: need help

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

kamakshisuram
Contributor

Re: Running a batch file: need help

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

Bill_Britt
Esteemed Contributor III

Re: Running a batch file: need help

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