10
Views
2
Comments
BPT and Transaction Rollback on SQL Server
Question
Application Type
Mobile

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.

Rank: #7875

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.