SugarChimp

Hi, I created leads And I cannot delete them. Is it a known issue ? Here is the response I got from sugar suport. Mathieu, 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. Regards, Technical Support Engineer http://support.sugarcrm.com http://community.sugarcrm.com