Transaction cancelled: maximum execution time exceeded

Jazz1 · ‎01-10-2020

Hello,

Been running into this error while processing a row count of 4800 rows and the transform gets aborted after an hour. There is a setting somewhere I suppose which limits the process time to 3600 secs. I have checked the quotas related to REST API but I don't see any value close to 3600. Now where can I set it to a higher number? It is not the outbound REST API call that is aborting. It is after all the data is materialized from the external source and after the transforms start that the process gets cancelled after an hour.

Thanks

Tony Chatfield1 · ‎01-10-2020

Hi, without any details of your scripts there isn't anything to assess. Have you reviewed the slow transaction/system logs for indications that your transform script is slow/is calling slow or recursive functions? Or confirmed that any call back function is successful/not timeing out?

Jazz1 · ‎01-13-2020

Hi, I found out where the quota needs to be changed. Changed it to a reasonable number but the process died without the indicated error this time around and did not complete either. The slowness was also due to another custom update a colleague was running. However my import of 4800 rows took over four hours (allotted time), generated over 60,000 lines of logs and it all because of the 27 business rules on the core table sn_vul_vulnerable_item. Seems like there is a few script includes it runs and erroring out on come columns which have nothing to do with my import. This one-size fits all code creates all kinds of headaches with no recourse such as filters/conditions.

Thanks