Understand stored procedure transactions

The transaction that corresponds to the middleware event needs to complete executing the custom stored procedure configured for the pre-hook, complete executing the middleware stored procedure, and complete executing the custom stored procedure configured for the post-hook. All three of these stored procedures must be executed within the allotted transaction time; otherwise, the middleware raises a timeout exception to the caller.

It is not recommended to have an autonomous transaction or nested transactions inside custom stored procedures, because that might affect the transaction flow built inside the MES product.