topic Google geocoding fails on QMC reload in QlikView

Google geocoding fails on QMC reload

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

Here is a puzzle to resolve.

The application script:

Data:
LOAD
[result/geometry/location/lat] as latitude,
[result/geometry/location/lng] as longitude
FROM [http://maps.googleapis.com/maps/api/geocode/xml?address='$(address)'&sensor=false] (XmlSimple, Table is [GeocodeResponse]);

Works fine in the QV Desktop in client's environment, but fails in QVS reload on the same box, with the message "The download failed". To make sure it's not a user permissions issue, I changed service user to the same user that runs Windows. Compared log file from both reloads. Besides the error itself, the only difference is in "Process Executing" - it is QlikView Desktop in one case and QVB in the other.

To make things more complicated... I copied this file from client to our internal QVS, and reload works here. That is, it can be reloaded by Server - but not by the one I need it. I didn't find any relevant difference in the settings.

Any ideas why this happens?

Thanks,

Michael

Re: Google geocoding fails on QMC reload

Gysbert_Wassenaar — Fri, 27 Mar 2015 13:20:49 GMT

Firewall or antivirus? Perhaps the executable is not allowed to create http connections to servers outside the organisations domain (or at all).

Re: Google geocoding fails on QMC reload

Anonymous — Fri, 27 Mar 2015 13:40:40 GMT

Thanks Gysbert, I didn't expect any answers already.

Doesn't look like this. I've changed geocoding from Google to mapquest, and it works this way. It is slower, but I don't expect more than a few addresses per reload. So, the problem has been fixed for the client.

Still, it bothers me. I thought that maybe Google blocked the requests, because a few weeks ago the app was sending hundreds of requests with the blank addresses and possibly extended Google limit - but why only for QVB and not for Desktop?

Thanks,

Michael