- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I added QVB.exe and QVS.exe as exceptions under windows firewall
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Not sure, but make sure that the ftp port is open on server.
Regards,
Kaushik Solanki
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
As I said. It works in QlikView Desktop on the same hardware as the QlikView Server.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I added QVB.exe and QVS.exe as exceptions under windows firewall
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Jan - this old response has just saved me a whole heap of head scratching!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I'm glad that it helped you.