Table Cleanup for the Counties table is not deleting the table entries

Error: The table entry cannot be deleted because it is in use by one or more records in the program when deleting a county or a country after running the Table Cleanup Wizard on the entry. Occurs when the Table Cleanup for the table is not deleting the table entries and no error occurs when running the Wizard.
After querying for all possible locations where the table entry could exist, download and run the Delete Table Entry plugin:

How to download and run the Delete Table Entry plug-in for The Raiser's Edge

To query for the County on existing records, create the following queries:
  • Constituent, All Addresses
  • Relationship, Banks
  • Relationship (Organization & Individual Address)
If the Events module is unlocked:
  • Participant, Addresses
  • Events, Location
  • Events, Guests, Addresses
If the above queries contain no records, check the following:
  • Configuration, Financial Institutions
  • Configuration, General
  • Config, Attributes (Note: Confirm that no attributes are using the Country or County tables)
Please also check the following record: Gift, CURRENCY_COUNTRY", if you continue to receive error after successfully following aforementioned steps.


To remove the table entry from County dropdowns in records without fully deleting the table entry:

Make the table entry for the county inactive so that it doesn't appear in the County drop-down menu

Environment

 Reported in version 7.61.790

Was this article helpful?