2 Replies Latest reply: Mar 27, 2015 9:40 AM by Michael Solomovich RSS

    Google geocoding fails on QMC reload

    Michael Solomovich

      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