Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-10783

Batch Dedupe hits OVER_QUERY_LIMIT error due to geocoding limits (?)

    Details

    • Type: Bug
    • Status: Won't Do
    • Priority: Major
    • Resolution: Won't Do
    • Affects Version/s: 4.2.0, 4.6.24, 4.7.14
    • Fix Version/s: None
    • Component/s: Dedupe
    • Versioning Impact:
      Patch (backwards-compatible bug fixes)
    • Documentation Required?:
      None
    • Funding Source:
      Needs Funding

      Description

      1. Searched for duplicates using contact/dedupefind
      2. Found about 350 duplicates.
      3. Hit the 'Batch dedupe' button
      4. After a few were deduped, maybe 10-15, received error OVER_QUERY_LIMIT
      5. This appears to be due to the Google mapserver/geocoding provider. When I went in & disabled both of those, the batch deupe run completed successfully. When I went in & enabled them again (Google), the error appeared again.

      It appears to be more related to the mapserver than the geocoder.

      It also may be due to the fact that I have an API key but it is entered only in the map provider API field, not in the geo provide API field. So maybe the google geo provider without API key only allows a very few queries before giving that error.

      Also, the OVER_QUERY_LIMIT error was not handled gracefully--white screen and plain error message on the screen, rather than the usual CiviCRM error handling as a message. There is no clue that the mapserver/geoserver might be the source of the problem.

      Here is what the error screen looks like (with backtrace):

      backTrace

      /our/web/site/directory/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 263
      /our/web/site/directory/sites/all/modules/civicrm/CRM/Utils/Geocode/Google.php, fatal, 150
      /our/web/site/directory/sites/all/modules/civicrm/CRM/Core/BAO/Address.php(405) : eval()'d code, format, 1
      /our/web/site/directory/sites/all/modules/civicrm/CRM/Core/BAO/Address.php, eval, 405
      /our/web/site/directory/sites/all/modules/civicrm/CRM/Dedupe/Merger.php, fixAddress, 927
      /our/web/site/directory/sites/all/modules/civicrm/CRM/Dedupe/Merger.php, getRowsElementsAndInfo, 626
      /our/web/site/directory/sites/all/modules/civicrm/CRM/Dedupe/Merger.php, merge, 580
      /our/web/site/directory/sites/all/modules/civicrm/CRM/Contact/Page/DedupeFind.php, batchMerge, 94
      /our/web/site/directory/sites/all/modules/civicrm/CRM/Core/Invoke.php, run, 228
      /our/web/site/directory/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 382
      , civicrm_invoke,
      /our/web/site/directory/includes/menu.inc, call_user_func_array, 349
      /our/web/site/directory/index.php, menu_execute_active_handler, 17
      SimpleXMLElement Object ( [0] => OVER_QUERY_LIMIT ) object
      Fatal error: Wrong parameters for Exception([string $exception [, long $code [, Exception $previous = NULL]]]) in /our/web/site/directory/sites/all/modules/civicrm/CRM/Core/Error.php on line 265

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                bhugh Brent Hugh
              • Votes:
                1 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: