Solved

PXTransactionScope : Transaction not rolled back

  • 4 April 2024
  • 3 replies
  • 44 views

Userlevel 3
Badge

Hi Team,

Not sure if anyone has come across this issue before. We have an Automation schedule that generates invoices. Few days back we had quite a lot of invoices to be generated. When we checked the status of the schedule, we could see many of them were processed successfully, but some of them failed. In the logs we could see the following error for the failed ones “The transaction associated with this command is not the connection's active transaction; see https://fl.vu/mysql-trans”. On further analysis we could see the Invoice did get generated, but Invoices never got linked to their respective Contracts. Ideally the schedule generates the Invoice and links it to the respective Contract , but in this case the Invoices with errors never got linked to the Contract.

Functionality is defined within a transaction scope so not sure why first section of the function worked (generating invoices) , but not the 2nd section (linking the Invoice to a Contract) for some reason didn’t get through.

 

Any thoughts?

 

icon

Best answer by vibindas 2 May 2024, 07:34

View original

3 replies

Userlevel 3
Badge

Entire transaction should rollback in case of any error/timeouts.

Userlevel 3
Badge

It was issue with Acumatica, when the automation schedules overlapped,  in case of a failure/error inner transaction were not getting rolled back. Acumatica provided a hot fix and we have applied this in our prod env.

Userlevel 7
Badge

Thank you for sharing the solution with the community @vibindas!

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved