AnsweredAssumed Answered

How to massively remove relationships between two modules?

Question asked by Jaume Albaigès on Jul 20, 2015
Latest reply on Jul 20, 2015 by Jaume Albaigès
We have a relationship 1-N between two modules. For one record in module A there are about 4000 related records in module B. Now we need to delete the record in module A (or simply remove the 4000 relationships, think it as you want).

If we try to delete this record in module A, the operation ends unsuccessfully with a typical SugarCRM error message. Our assumption is that SugarCRM is trying to remove the 4000 relationships with module B before deleting the record in module A and that there is a PHP timeout before successfully ending the operation (although we set a very high value in PHP timeout config).

Other unsuccessfull ways:

- As you can't select multiple rows in a subpanel in order to remove them, you can't manually remove relationships before deleting the main record.

- Mass update for records in module B: you can't set a blank value for a related field.

Is there any other way to achieve this goal?

Thank you very much!

Btw, SugarCRM CE 6.5.11.