4 Replies Latest reply: Dec 22, 2015 9:09 PM by Bill Britt RSS

    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

        • Re: Running a batch file: need help

          Any idea about it?

          • Re: Running a batch file: need help
            Kamakshi Suram

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

              • Re: Running a batch file: need help
                Bill Britt

                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