Merge function for Accounts orphans related Cases

Hi,

We currently use Enterprise v11.0.3 but we have found this bug. The system orphans related records when merging. Looking at the portal, this was identified in v7.8 (2017-02-17).

What is the status of this bug? It seems quite a significant issue, has anyone else noticed this?

Kind regards john

Status
New
Priority
High
Type
Defect
Sugar Edition
Found In Release
7.8.0.0
Fixed In Release
Product
Sugar (CRM application)
Resolution
Product Category
Merge Duplicates
Date Created - 2017-02-17 21:26
Private Bug

Date Modified
2022-04-12 22:01
Description
Steps to reproduce:
In Sugar 7.8.0.0
- Create two Accounts, Company A and Company B
- Create 5 Cases related to Company A
- Create 105 Cases related to Company B
- Merge Company B into Company A from Accounts listview

Expected results:
Post merge Company A has 110 related Cases.

Actual results:
Post merge Company A has less than 110 related Cases. In testing this was 94 but the number can vary.

Notes:
Looking at the cases table in the database reveals that the account_id field on the missing cases is NULLless

Parents
  • Hi John and Julia -

    I looked into bug 78302 and it has been recently escalated. I'll keep an eye on it to make sure it does not lose focus or priority.

    For now if you plan to merge accounts that have > 75 related records, please contact support to coordinate any needed post merge cleanup. We can identify the orphaned related records by date_modified and then manually set these to the correct account_id. Alternately this could also be done through the UI by filtering for records without a related account and then mass updating these. 

Reply
  • Hi John and Julia -

    I looked into bug 78302 and it has been recently escalated. I'll keep an eye on it to make sure it does not lose focus or priority.

    For now if you plan to merge accounts that have > 75 related records, please contact support to coordinate any needed post merge cleanup. We can identify the orphaned related records by date_modified and then manually set these to the correct account_id. Alternately this could also be done through the UI by filtering for records without a related account and then mass updating these. 

Children