Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

mov
Esteemed Contributor III

Google geocoding fails on QMC reload

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


Labels (1)
2 Replies

Re: Google geocoding fails on QMC reload

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


talk is cheap, supply exceeds demand
mov
Esteemed Contributor III

Re: Google geocoding fails on QMC reload

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

Community Browser