Article Details
Id: | 16428 |
Product: | finPOWER Connect |
Type: | FIX |
Version: | 3.02.03 |
Opened: | 08/10/2019 |
Closed: | 09/10/2019 |
Released: | 22/11/2019 |
Job: | J023076 |
Opening an Account; may fail with "Attempting to commit a Transaction where a nested Transaction rolled back" error
Opening an Account may fail with the error "Attempting to commit a Transaction where a nested Transaction rolled back.".
This issue may occur if you have a "StatusChangePost" event script that saves the Account. The underlying issue is the Account record's timestamp is getting updated by the Credit Enquiry Quotation confirmation functionality, and when the Account is saved in "StatusChangePost" the save fails. It errors with "Record in table 'Account' was not updated. This record may have been deleted or edited by another User.".
This issue has been fixed, but the immediate workaround is to add an Account.Refresh at the start of "StatusChangePost", see below.
Case "StatusChangePost"
Account = DirectCast(source, finAccount)
AccountStatusOld = DirectCast(contextData1, isefinAccountStatus)
AccountStatusNew = DirectCast(contextData2, isefinAccountStatus)
Account.Refresh()