1 Reply Latest reply: Mar 11, 2014 7:35 AM by Jose Luis Dengra RSS

    Load from FTP fails in QlikView Server

    Jose Luis Dengra

      When I reload my document in QlikView Desktop on my PC, it works to load data from a .csv file from a FTP server. But when I reload the same document in QlikView Server with the same QlikView version it does not work to load data from the same .csv file from the same FTP server.

       

      The error message in the log file is Error: Cannot open file

       

      Our system administrator says that it is required a FTP passive mode, and QlikView seems not to allow it. There is an option called "Passive Semantic" in the assistant for the FTP connection at design time, but it seems not to work since when I check it, the generated code is the same as when I do not check it.

      Is this a bug?

      What can I do to enforce my script to perform a FTP connection using the passive mode?

      Does anyone have any idea to fix this?

       

      At this moment I am "fixing it" by performing the reload from a batch process calling the client from my machine, and it properly obtains the files from the FTP Server and make an incremental load into QVDs, but I want to do it by a Publisher task by reloading the QlikView document from the QlikView server.

       

      My question is related to this issue, but this time the firewall is off:

      Load from ftp failes in QlikView Server but works in QlikView Desktop

       

      Thank you in advance.

        • Re: Load from FTP fails in QlikView Server
          Jose Luis Dengra

          From Qlikview Support, they told me to check the Passive Sematics for FTP option at document level, and not in the assistant for the FTP connection at design time, which does not work. It properly connects FTP using passive mode by checking this option at Configuration / Document Properties.


          This definitively fix it and make possible to reload the document by a Publisher task in the server.