Uploaded image for project: 'OpenNMS'
  1. OpenNMS
  2. NMS-6129

Google Maps API rate-limit leads to persistent (-Inf,-Inf) coordinates in DB

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.12.1
    • Fix Version/s: 1.12.2
    • Security Level: Default (Default Security Scheme)
    • Labels:
    • Environment:
      Any system configured (e.g. by default) to use the Google Maps API geolocation service and having >= 2500 nodes with address asset fields

      Description

      If the Google geocoder hits the daily rate-limit (currently quoted as 2500 requests per day) then it appears that coordinates of (-Infinity, -Infinity) start to go into the longitude and latitude fields. Worse, it appears these values never get recognized as invalid, so the geocoder never attempts to replace them with valid coordinates. The only workaround seems to be to delete the invalid records manually from the database.

      Creating this issue in response to commercial support ticket https://mynms.opennms.com/Ticket/Display.html?id=2504

        Attachments

          Activity

            People

            • Assignee:
              ranger Benjamin Reed
              Reporter:
              jeffg Jeff Gehlbach
            • Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: