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?
