Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

jan_gunnars
New Contributor III

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

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://USERSmiley Tonguewd@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

1 Solution

Accepted Solutions
jan_gunnars
New Contributor III

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

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

7 Replies

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

Hi,

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

Regards,

Kaushik Solanki

jan_gunnars
New Contributor III

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

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

ggg
Contributor II

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

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
New Contributor III

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

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
New Contributor III

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

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

MVP
MVP

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

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

jan_gunnars
New Contributor III

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

I'm glad that it helped you.

Community Browser