Save Your Team Countless Hours. SugarChimp syncs your lists in both directions so that you can work in your preferred application. Segment and Group your MailChimp subscribers based on SugarCRM data so you can market to the right people at the right time. Fully compatible with all versions and editions of Sugar and SuiteCRM.
#2935 - Unable to delete records
I created leads And I cannot delete them. Is it a known issue ?
Here is the response I got from sugar suport.
I traced this issue to specific records that cannot be deleted. The mass delete action begins working and then fails when it hits specific records. In troubleshooting, I found that these records have exorbitantly high numbers of relationships in the prospect_lists_prospects. This table houses the lead and target list relationships. When the lead is deleted Sugar also attempts to set the target list relationship to deleted as well. I believe that SugarChimp has been somehow creating thousands of these relationships for some reason.
Below is the query showing the specific lead IDs and the number of entries in the prospect_lists_prospects table.
mysql> select related_id, count() from prospect_lists_prospects group by related_id order by count() desc;
| related_id | count(*) |
| 8ebac7ec-54c5-11e6-80d8-069e4fa9cd4b | 31248 |
| edebb406-59a2-11e6-b051-02d9144ab1cf | 10758 |
| 801d3b96-63d6-11e6-9f3d-02d9144ab1cf | 6702 |
| eb8ef65e-5421-11e6-8b70-02d9144ab1cf | 5861 |
| 6cda10cd-fad4-f0d7-393c-579690734810 | 5861 |
| 263c640c-54e6-11e6-8f12-02d9144ab1cf | 5845 |
| 6d4b65ac-5421-11e6-a663-02d9144ab1cf | 4511 |
| afb80fe2-6a12-11e6-8bef-06e14280fdab | 3623 |
| dce9a972-79e3-11e6-aa55-0230eed5e4fb | 3216 |
| 40d78568-69f8-11e6-823c-0230eed5e4fb | 2395 |
| 1f65b9de-54ba-11e6-98ad-0230eed5e4fb | 1616 |
In the top example, when you attempt to delete lead ID 8ebac..., Sugar must also delete 31K relationship records. This is why you are timing out.
I can delete these relationship records for you in the database however you need to tell me which records you would like deleted. If I delete all of them that have high relationship counts I could be removing a lead that you do not want to delete.
Technical Support Engineer
Other add-ons of interest
Advanced Marketing Lists
Advanced Marketing Lists automatically fill Target Lists and keep updated the Campaigns to which they are associated.