Discussion Board for collaboration on QlikView Management.
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
Firewall or antivirus? Perhaps the executable is not allowed to create http connections to servers outside the organisations domain (or at all).
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