Deleted emails in 7.93 appear in 7.94 following upgrade

After upgrading, deleted emails that were removed from a constituent record and any associated relationship are reappearing on a constituent's record in Version 7.94.
We are aware that a number of customers have been affected by this critical issue and we have deployed all possible resources to resolve. By subscribing to the Knowledgebase solution you will receive immediate updates on timelines and/or solutions as they are confirmed. We will continue to post general updates around the 7.94 release on our 7.94 landing page to ensure our clients have the most up to date information: https://www.blackbaud.com/fundraising-and-relationship-management/raisers-edge-794-updates.

Based on evaluating various databases, we have found that this issue is actually related to the fact that Relationship contact information for specific constituents moved to the Phone Grids on the Bio 1 tab, as documented in this solution (BB755143). Phones that are appearing on the Phones Grid on constituent records are actually appearing from Relationships where that specific Constituent is listed as the Relationship. As an example: 

Bob Hernandez is a constituent in our database, and he has many relationships listed on his Relationships tab. However, it's completely possible that we have Bob Hernandez linked and listed as a Relationship on another constituent's Relationships tab, but that relationship is not reciprocated. If it is not reciprocated, it would not appear on Bob's Relationships tab. There are ways to find this data, if you have a backup of your 7.93 database to load. In your 7.93 database, you can run the following query to find other relationships that this phone or email could have come from:
 

 

  1. Create a New Constituent Query
  2. For the Criteria, select Relationships > Individuals > Specific Individual Record equals [Constituent in Question]
  3. For the Output, select: 
  • Constituent Information > Name
  • Relationships > Individuals > Name
  • Relationships > Individuals > Address > Phones > Phone Number


Run the query, and this will output all possible relationships where the phone number could have appeared in 7.93, and then would have been moved to the Phones Grid in 7.94. Again, this information can be found in a backup copy of your 7.93 database.
 

Environment

 7.94

Was this article helpful?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.