|
Database Connection Random Issues
I am getting the following in my logs every couple days randomly - A restart of the Altiris service fixes it, and I have had my DBAs look at the database logs and nothing shows in there.
Log File Name: C:\Program Files\Altiris\Notification Server\Logs\a36.log
Priority: 1
Date: 11/12/2009 8:16:55 AM
Tick Count: 1273057421
Host Name: CORALTIRIS5
Process: aexsvc.exe (5980)
Thread ID: 12256
Module: AltirisNativeHelper.dll
Source: Altiris.NS.ClientConfigManagement.ClientConfigMana ger.GetClientConfigImpl
Description: Unable to get the client policies for specified resource (Resource: W078108, Exception: Altiris.NS.Exceptions.DatabaseNotReadyException: Failed to construct DatabaseContext object. Connection to database failed. ---> Altiris.NS.Exceptions.AeXException: Failed to open database connection. Current user is NCOGROUP\altirissvc2. Error: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. ---> System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
at System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString options, Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
at Altiris.NS.Utilities.DbUtils.OpenConnection(SqlCon nection dbConn)
--- End of inner exception stack trace ---
at Altiris.NS.Utilities.DbUtils.OpenConnection(SqlCon nection dbConn)
at Altiris.NS.Utilities.DbUtils.CreateConnection(Stri ng configKey)
at Altiris.NS.Utilities.DbUtils.CreateConnection()
at Altiris.NS.ContextManagement.DatabaseContext..ctor (ContextIdentity identity, Boolean beginTransaction, IsolationLevel isolationLevel)
--- End of inner exception stack trace ---
at Altiris.NS.ContextManagement.DatabaseContext..ctor (ContextIdentity identity, Boolean beginTransaction, IsolationLevel isolationLevel)
at Altiris.NS.ContextManagement.DatabaseContext.GetCo ntext(Boolean createNewTransaction, IsolationLevel isolationLevel, ContextIdentity identity, Boolean independentContext)
at Altiris.NS.ClientConfigManagement.ClientConfigMana ger.GetClientConfigImpl(String requestXml))
|