I have this flow Service (we call it fullProcess)
– invoke adapterReading (with implicit transaction) (Kind of reading database)
– invoke updateFull
In updateFull
– invoke pub.art.transaction:beginTransaction
– SEQUENCE (Exit on SUCESS)
---- SEQUENCE (Exit on FAILURE)
------ invoke adapterUpdateTable1
------ invoke adapterUpdateTable2
------ pub.art.transaction:commitTransaction
---- SEQUENCE (Exit on DONE)
------ pub.flow:getLastError
------ pub.art.transaction:rollbackTransaction
– BRANCH on lastError
---- $null : MAP (Nothing)
---- $default : pub.flow:throwExceptionForRetry
When I start (not in debug) the fullProcess flow service I have the following error :
The resource is already being used in a parent transaction.
After searching a lot, I found if I disable step invoke adapterReading, the error vanished.
So my conclusion is the LOCAL_TRANSACTION connection (using for all my adapters) open implicit transaction but I don’t know how to close it.
Have you an idea ?