topic Re: Reloading data from the Internet through QV Mngmt Console in QlikView

Reloading data from the Internet through QV Mngmt Console

Mon, 10 Oct 2011 11:08:04 GMT

Hi all,

I've been experiencing an issue of not being able to reload a file from the Internet when my qvw is scheduled to reload from the QV Management Console every morning. I see this in the log file: "Error: Cannot open HTML file".

I find it strange as when I run it from the QV installed on the same server I'm able to reload it succesfully. Also, it works fine when I open the site from the IE on the same server.

Here is what can be found in the log file:

FCER:

12.10.2011 10:32:05: 0036 LOAD 'GBP' as GLCurrID,

12.10.2011 10:32:05: 0037 @2 as FCERate

12.10.2011 10:32:05: 0038 FROM

12.10.2011 10:32:05: 0039 [https://www.business.barclays.co.uk/BRC1/jsp/brcscontrol?site=bbb&task=ExchangeRatesDetail&currencyCode=USD]

12.10.2011 10:32:05: 0040 (html, codepage is 1250, no labels, table is @17)

12.10.2011 10:32:05: Error: Cannot open HTML file

Any ideas?

Thanks,

Nenad

Re: Reloading data from the Internet through QV Mngmt Console

Wed, 12 Oct 2011 13:45:21 GMT

Maybe a service account used on the server does not have access to the Internet? How/where can this be checked?

Where would you enter proxy information for accessing the internet through a report?

Thanks for ideas,

Nenad

Re: Reloading data from the Internet through QV Mngmt Console

Sat, 22 Oct 2011 15:35:25 GMT

For all,

The solution to this is to enable the service account on the QV server to have access to the Internet.

Nenad