Welcome to the Inedo Forums! Check out the Forums Guide for help getting started.
If you are experiencing any issues with the forum software, please visit the Contact Form on our website and let us know!
Service won't start after 2.1.1 Upgrade
-
I get a "Service cannot be started. System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> " in my event log. I have restarted the machine after trying to restart services, no change yet. SQL is working as other DB's for other apps are working fine. Ideas?
Product: Otter
Version: 2.1.1
-
Hello; this errro means that OTter can't connect to the database. Maybe the connection string changed?
I would check the database connection string in Otter's configuration file.
-
If I try like 10 times or so, it will finally start. The DB has not changed as other services are still connecting and working to the same instance. 9/10 times, the Otter service will time out and I have to try again. Seems to be some type of timeout after 15-20 seconds or so.
-
There have been no changes to the way our products connect to databases in many years, so this is unrelated to an upgrade.
However, it seems to be some sort of indication that SQL Server must be overloaded, or a network problem. This can typically be diagnosed / reviewed by the SQL Server DBA, who can see incoming connections, and which queries are taking too long, etc.
But in my experience, just restarting the server you have SQL Server installed on fixes it like 80% of the time.
