Skip to main content

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
mov
Employee
Employee

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
Gysbert_Wassenaar

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
Employee
Employee
Author

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