Skip to main content
Solved

MySqlConnection error when trying to complete large appointments


Forum|alt.badge.img

We get an error that says - ‘This MySqlConnection is already in use. See https://fl.vu/mysql-conn-reuse’ when we try to ‘complete’ large appointments.  Once we get this error message we are unable to cancel, alter, save, complete or bill this appointment.

This has happened on appointments ranging from  25-45 lines.

Anyone have any idea why this is happening and how we can get around the issue?

Best answer by steph23

If anyone else comes across this issue, we had this issue fixed the other day. This error happened even after customisations were removed.  My understanding is that an index was added on one of the appointment tables.

View original
Did this topic help you find an answer to your question?

2 replies

Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 24 replies
  • Answer
  • August 28, 2024

If anyone else comes across this issue, we had this issue fixed the other day. This error happened even after customisations were removed.  My understanding is that an index was added on one of the appointment tables.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2640 replies
  • August 28, 2024

Thank you for sharing your solution with the community @steph23!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings