Unintended execution of SAVEPOINT

0
Hi all, I wonder when "SAVEPOINT" sql queries executed. Does anybody have idea on which microflow activity generates "SAVE POINT" query? The query takes time and it is causing performance problem.   Possible activities I am considering -delete object(s) always execute "SAVE POINT" sql queries in the background. -filter persistent entity always execute "SAVE POINT" sql queries in the background.  
asked
1 answers
1

Hi Yuki,

In Studio Pro you can set certain lognodes to Trace for checking of SQL queries. You can then debug a microflow and check which queries are executed at what point. Maybe this can help you get to the bottom of this. You might have to experiment with which lognodes to check.

It also sounds transaction related, so you might try debugging the End/Start transaction Java actions and see if they produce this query. 

answered