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

[jan_gunnars]

When I reload my document in QlikView Desktop on the QlikView Server Machine it works to load data from a .txt file from a ftp server. But when I reload the same document in QlikView Server on the same QlikView Server Machine it does not work to load data from the same .txt file from the same ftp server.

Does anyone have any idea what's wrong?

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

2011-07-07 10:47:01: 0310      table:
2011-07-07 10:47:01: 0311        LOAD 
2011-07-07 10:47:01: 0312            column1,
2011-07-07 10:47:01: 0356         column2,
2011-07-07 10:47:01: 0357         column3
2011-07-07 10:47:01: 0358        FROM ftp://USER:pwd@server.domain.se/Folder/file.txt (txt, codepage is 1252, embedded labels, delimiter is '\t', msq)
2011-07-07 11:17:01:           Error: Cannot open file 
2011-07-07 11:17:01:           General Script Error
2011-07-07 11:17:01:           Execution Failed

[kaushiknsolanki]

Hi,

   Not sure, but make sure that the ftp port is open on server.

Regards,

Kaushik Solanki

[jan_gunnars]

As I said. It works in QlikView Desktop on the same hardware as the QlikView Server.

[Gustav_Guldberg]

Hi Jan,

When you say reload via QlikView Server I assume this is from the management console.

Is the account running the Distribution Service the same as the account that you are currently logged in as?

A quick test would be to run the Distribution Service under your domain account, do the reload, and see if it makes any difference.

[jan_gunnars]

Hi Gustav

I have logged on to the server machine with the same account as the QV Services are running under. Then I opened the  document with QlikView Desktop and reloaded it and it worked. So that was not the problem.

Maybe I also should say that there are several other documents on the server that are able to reload. The difference is that they don't use ftp to load data.

[jan_gunnars · Accepted solution]

I added QVB.exe and QVS.exe as exceptions under windows firewall

[stevedark]

Thanks Jan - this old response has just saved me a whole heap of head scratching!

[jan_gunnars]

I'm glad that it helped you.