Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
marcel_olmo
Partner Ambassador
Partner Ambassador

Problems loading internet files on the server

Hi guys, I've got a qw file that gets actual currencies of the world from the net. And I've been reloading the file perfectly in the server since now.

I had the QV10 SR1 server version installed on my server, and I decided to install QV10 SR6 in order to solve some dummy bugs.

But now I can't reload this document anymore. It always get me the same error shown in the log file. It says it cannot find the fields of the table that I'm accessing from the net.

I reinstalled the SR5 and SR4 versions instead, and the result is still the same.

If I reload the document in the client it works perfectly. It only fails when I'm trying to reload the document on the server.

Anybody knows what is happening?

Many thanks in advance!!

7 Replies
danielrozental
Master II
Master II

Why are you using filters?

This load works fine

LOAD Name,

          subfield(Name,'/',1) as Name1,

          subfield(Name,'/',1) as Name2,

     Last,

     [Last Time]

FROM

[http://www.fxstreet.com/rates-charts/currency-rates/]

(html, codepage is 1252, embedded labels, table is @1);

marcel_olmo
Partner Ambassador
Partner Ambassador
Author

Thanks Daniel for your answer,

I think the problem is not about the filters. I quit the filters as you did, and I still have the same message :

16/01/2013 17:26:24: 0045  LOAD Name,

16/01/2013 17:26:24: 0046            subfield(Name,'/',1) as Name1,

16/01/2013 17:26:24: 0047            subfield(Name,'/',1) as Name2,

16/01/2013 17:26:24: 0048       Last,

16/01/2013 17:26:24: 0049       [Last Time]

16/01/2013 17:26:24: 0050  FROM

16/01/2013 17:26:24: 0051  [http://www.fxstreet.com/rates-charts/currency-rates/]

16/01/2013 17:26:24: 0052  (html, codepage is 1252, embedded labels, table is @1)

16/01/2013 17:26:24:       Error: Field not found - <Name>

16/01/2013 17:26:24:       General Script Error

16/01/2013 17:26:24:       Execution Failed

16/01/2013 17:26:24:      Execution finished.

danielrozental
Master II
Master II

Can you try building the script again? using the wizard, I can't see where the problem is.

marcel_olmo
Partner Ambassador
Partner Ambassador
Author

I'm pretty sure that is a Server problem. If I reload in client desktop the document, it works fine.

But if I do it in the server, it doesn't work...

swuehl
MVP
MVP

If I reload in client desktop the document, it works fine.

Are you executing the client on the server or on a different PC?

erichshiino
Partner - Master
Partner - Master

Hi, Marcel,

You can try to rebuild it on Qv Desktop running on the server machine.

If you try the following script, you can check the fields names that the server can identify in your URL.

Hope it helps,

Erich

danielrozental
Master II
Master II

It's also possible that the internet settings for the user running the services has been changed, try logging in with that user and check if you can access the URL.