Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
jan_gunnars
Partner - Contributor III
Partner - 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://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

1 Solution

Accepted Solutions
jan_gunnars
Partner - Contributor III
Partner - Contributor III
Author

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

View solution in original post

7 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

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

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
jan_gunnars
Partner - Contributor III
Partner - Contributor III
Author

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

Gustav_Guldberg
Employee
Employee

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
Partner - Contributor III
Partner - Contributor III
Author

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
Partner - Contributor III
Partner - Contributor III
Author

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

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

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

jan_gunnars
Partner - Contributor III
Partner - Contributor III
Author

I'm glad that it helped you.