I had problems with BPT on SQL Server with Read Uncommited Isolation Level that Outsystems Platform use.
I had offline mobile app which capture activities with many photo.
Then when synced to server via server action, it invoked Create<entity> action which then triggerred a BPT process.
BPT process then started and process some data.
But on a rare cases, sync server action had exception and force a rollback transaction, but the BPT process is already started, and produces data inconsistencies.
Is there any way to get around this?
Thanks.
Hi Harlin, Can we try to do 1 more verification at the start of BPT Process: to check if Record with that Input Entity Id is existed before proceed further.
We can do that, but what if at the time, it's not rollbacked yet?
So BPT Process can still see the record?
Is there any way to check if a record is commited yet?
Thanks for your suggestion though, it's helpful.