Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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);
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.
Can you try building the script again? using the wizard, I can't see where the problem is.
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...
If I reload in client desktop the document, it works fine.
Are you executing the client on the server or on a different PC?
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
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.