Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

Any idea about it?

kamakshisuram
Creator
Creator

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
Creator
Creator

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
Former Employee
Former Employee

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

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.