DB connectivity error

smp

Hi Team,

We are frequently DB connectivity issues from our Orion application server. While checking the DB manually we are able to connect it. But we used to get the below alerts frequently.

Service was unable to open new database connection when requested.

Exception Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

Connection string - Data Source=________;Initial Catalog=NetPerfMon;User ID=SolarWindsNPM;Password=*******;Connect Timeout=20;Load Balance Timeout=120;Application Name=SolarWinds.DataProcessor@domain-DataProcessorHost-0;Workstation ID=______

2016-07-27 11:06:33,766 [AlertCheckingThread] ERROR Error - Error in UpdateRowsThatAreTriggered() - GetNetObjects

System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)

   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

   at System.Data.SqlClient.SqlConnection.Open()

   at SolarWinds.Orion.Common.DatabaseFunctions.CreateConnection(IsolationLevel isolationLevel, Boolean throwException)

   at SolarWinds.Orion.Common.SqlHelper.ExecuteReader(SqlCommand command, SqlConnection connection, SqlTransaction transaction, CommandBehavior behavior)

   at AlertingEngine.CheckAlert.UpdateRowsThatAreTriggered()

ClientConnectionId:b35a1e35-f9a0-44ce-b6ce-6e82ed45ae16

Can someone please help me to get this resolved.

xtraspecialj

Have you tried turning up the timeout values?  If not go to "%InstallVolume%\Program Files (x86)\SolarWinds\Orion\SWNetperfmon.DB" on your Primary Orion server and your Additional Polling Engines, scroll all the way to the bottom and Increase your Connection "Timeout" (mine is 60) and perhaps your "Load Balance Timeout" (I'm guessing that is a new feature of NPM 12).  I also increased my "Command Timeout" to 180 (not my "SQLCommandTimeout".  Leaving that at the default of 0 means it is an indefinite timeout value.  I don't recommend adjusting that).

Try increasing the timeouts and restarting your Orion services. See if it helps reduce these errors.