Google geocoding fails on QMC reload

[Anonymous]

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

[Gysbert_Wassenaar]

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

[Anonymous]

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