topic Re: Problems loading internet files on the server in QlikView

Problems loading internet files on the server

marcel_olmo — Wed, 16 Jan 2013 16:09:22 GMT

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!!

Re: Problems loading internet files on the server

danielrozental — Wed, 16 Jan 2013 16:20:48 GMT

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);

Re: Problems loading internet files on the server

marcel_olmo — Wed, 16 Jan 2013 16:28:06 GMT

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.

Re: Problems loading internet files on the server

danielrozental — Wed, 16 Jan 2013 16:43:51 GMT

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

Re: Problems loading internet files on the server

marcel_olmo — Wed, 16 Jan 2013 16:45:54 GMT

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...

Re: Problems loading internet files on the server

swuehl — Wed, 16 Jan 2013 17:09:51 GMT

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

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

Re: Problems loading internet files on the server

erichshiino — Wed, 16 Jan 2013 17:12:32 GMT

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

Re: Problems loading internet files on the server

danielrozental — Wed, 16 Jan 2013 17:22:41 GMT

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.