Database connection issue

[beacondental]

Hi Team,

Today, while submitting an SQL query in the PUT API of open dental, it returned the below response message with an HTTP status code of 400,

""Error submitting query. Unable to connect to any of the specified MySQL hosts.""

Please help me understand the issue & how I can prevent this from happening.

Note: This was not because of Open Dental's database backup downtime, this has happened a few times in the past.

[justine]

Hi Team,

Today, while submitting an SQL query in the PUT API of open dental, it returned the below response message with an HTTP status code of 400,

""Error submitting query. Unable to connect to any of the specified MySQL hosts.""

Please help me understand the issue & how I can prevent this from happening.

Note: This was not because of Open Dental's database backup downtime, this has happened a few times in the past.

Good morning beacondental,

This message occurs when the eConnector is not able to make contact with and access the database on the server. However, our records indicate that you are successfully making thousands of ShortQuery requests.

See Troubleshooting MySQL Issues documentation for additional information and troubleshooting ideas.

Thanks!