I have a WF Custom Action Script that deletes Chil...
# suitescriptj
jen
03/28/2022, 5:00 PMI have a WF Custom Action Script that deletes Child Custom Records when a parent record is deleted. I’m running into SCRIPT_EXECUTION_LIMIT_EXCEEDED on this. Would a MapReduce be a way around this?
c
creece
03/28/2022, 5:12 PMFor a parent-child record relationship, you should be able to do a UE an beforeSubmit on a delete, spin through the child record sublist and remove the lines which deletes them and then save. It'll take like 10 units at most and you don't have to go governance crazy.
j
jen
03/28/2022, 5:19 PMSo this is actually for a ‘reverse approval’ which we do with a Suitelet (deletes Invoice, purchase Orders, Bills for a Sales Order, and sets Sales Order back to unapproved). There could be many purchase orders / bills, and each could have several child records.
jen
03/28/2022, 5:19 PMThe child records are being deleted due to a WF that runs on delete of parent transaction
jen
03/28/2022, 5:19 PMnot happening in UI so I don’t think the UE idea will work in this case.
jen
03/28/2022, 5:20 PMreally my question is more of a general one: Does a MR use a separate governance queue since it is pushing execution off into a “task”
s
Sandii
03/28/2022, 5:23 PMEach invocation of each stage of the MR has its own governance, so if designed properly then it could fix your problem in theory
s
Shawn Talbert
03/28/2022, 8:29 PMthough potentially introduce other problems that come along for the ride with MR scripts 🙂
j
jen
03/28/2022, 11:21 PMyeah
jen
03/28/2022, 11:21 PM😐