Details
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
- is supplemented by
-
CRM-18830 Google Geocoding - use SSL, restore API key
- Done/Fixed