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()