Raiser's Edge hangs when matching records in Connect RE plug in

When users access the Connect RE plugin to match records from the Core database, the Raiser's Edge may hang and stop matching. Sometimes it appears the plugin stops loading or gets stuck on one specific record.
Users must use the Task Manager on their machines to close The Raiser's Edge.
 
Please check the following to resolve:

1. Issue can be caused by a record with invalid or special characters. In one instance we found the issue was isolated to one record with a school relationship on the Raiser's Edge record has a special character. Please review the affected record and check for any inconsistencies or invalid characters.

2. Duplicate records can also cause the issue where the integration attempts to match to both records at once. To resolve please remove the duplicate from the Core database.
 
3. Invalid business addresses will cause this issue.
  1. Navigate in Raiser's Edge to the specific record causing the load issue.
  2. Click the Address tab.
  3. Un-mark the 'Hide addresses that do not receive mail' checkbox and select the table to show <All Addresses>.
  4. Each constituent in Raiser’s Edge should allow for a single ‘Preferred’ and ‘Business’ indicator on the addresses tab. If there is a second Business address with an Indicator of ‘Business’ users should temporarily change the indicator by marking the invalid address as ‘Preferred’.
  5. Navigate back to the correct Preferred address and check the ‘Set this address to the preferred address’. Note the invalid Business address now has an indicator of ‘Alternate’.

Steps to Duplicate

1. Launch Raisers' Edge
2. Access Connect RE plug in
3. Matching process begins.
4. Process hangs
5. Must use Task Manager on machine to close Raiser's Edge.

Environment

 SQL Server 2008 R2
 Citrix
 Raiser's Edge
 7.94

Was this article helpful?