none
MAP tool stops on regular base RRS feed

  • Question

  • Hi all,

    I'm currently trying to run the MAP tool to scan all our SQL servers within our domain. If I schedule the tool for a longer period of time, the MAP tool stops at a certain day/time.

    I've checked the logfile which I retrieved from: "C:\Program Files\Microsoft Assessment and Planning Toolkit\bin\log" and this logfile basically says that MAP has troubles connecting to a database.

    According to the logfile server named  "SERVER-A" was the last server successfully scanned, after that the log tells me that MAP can't make a connection to the database/server..

    Is the logfile referring to the next server I provided? Because this server is reachable.

    Below you can find the logfile.

    <2012-10-30 19:02:32.19 WorkerThread76@DeviceInventoryWorkItem,I> InventoryWorkCallback(Device(GUID={e0c8c331-207f-414b-b158-0acd9b271432},DnsHostName='SERVER-A')) - Device inventory starting.
    <2012-10-30 19:02:41.60 WorkerThread102@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 3 more time(s).  Retrying in 5000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:02:41.60 WorkerThread69@DataAccessCore,W> OpenConnection() - Caught an InvalidOperationException trying to connect to the database.  Will retry connection 3 more time(s).  Retrying in 5000 milliseconds.
       |Exception message = 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.
    <2012-10-30 19:02:41.62 WorkerThread134@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 3 more time(s).  Retrying in 5000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:02:41.62 WorkerThread76@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 3 more time(s).  Retrying in 5000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:02:41.62 WorkerThread70@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 3 more time(s).  Retrying in 5000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:02:41.62 WorkerThread78@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 3 more time(s).  Retrying in 5000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:02:42.60 WorkerThread88@DataAccessCore,W> OpenConnection() - Caught an InvalidOperationException trying to connect to the database.  Will retry connection 3 more time(s).  Retrying in 5000 milliseconds.
       |Exception message = 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.
    <2012-10-30 19:02:42.60 WorkerThread101@DataAccessCore,W> OpenConnection() - Caught an InvalidOperationException trying to connect to the database.  Will retry connection 3 more time(s).  Retrying in 5000 milliseconds.
       |Exception message = 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.
    <2012-10-30 19:02:42.60 WorkerThread119@DataAccessCore,W> OpenConnection() - Caught an InvalidOperationException trying to connect to the database.  Will retry connection 3 more time(s).  Retrying in 5000 milliseconds.
       |Exception message = 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.
    <2012-10-30 19:02:43.21 WorkerThread115@DataAccessCore,W> DoWorkInTransaction<T>() - Caught InvalidOperationException trying to roll back the transaction: This SqlTransaction has completed; it is no longer usable.
    <2012-10-30 19:02:43.21 WorkerThread115@DataAccessCore,W> DoWorkInTransaction<T>() - Caught a SQL transaction timeout exception. Will retry 3 more time(s). Retrying in 5000 milliseconds.
       |onSqlExceptionMessage = Caught SqlException running query for <CollectionTest Name='ShouldTryPerfmonPerfCollection'>.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:02:44.20 TID-400@WatchdogThreadPool,I> UpdateMaxThreadsWatermark() - currentCpuUtil = 100, error = -10, accumulatedCpuUtilError = -11, adjustment = -11.2, countOfThreadsToAdd = -12, maxThreadsWatermark = 10, numThreads = 10, PrivateMemorySize = 188223488, TotalManagedMemory = 51659888
    <2012-10-30 19:02:46.60 WorkerThread69@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 2 more time(s).  Retrying in 10000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:02:46.60 WorkerThread102@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 2 more time(s).  Retrying in 10000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:02:47.60 WorkerThread119@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 2 more time(s).  Retrying in 10000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:02:47.60 WorkerThread101@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 2 more time(s).  Retrying in 10000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:02:47.60 WorkerThread88@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 2 more time(s).  Retrying in 10000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:02:50.60 TID-381@WatchdogThreadPool,I> UpdateMaxThreadsWatermark() - currentCpuUtil = 100, error = -10, accumulatedCpuUtilError = -21, adjustment = -16.5333333333333, countOfThreadsToAdd = -17, maxThreadsWatermark = 10, numThreads = 10, PrivateMemorySize = 188223488, TotalManagedMemory = 51659888
    <2012-10-30 19:03:01.60 WorkerThread78@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 2 more time(s).  Retrying in 10000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:03:01.63 TID-462@WatchdogThreadPool,I> UpdateMaxThreadsWatermark() - currentCpuUtil = 100, error = -10, accumulatedCpuUtilError = -31, adjustment = -21.8666666666667, countOfThreadsToAdd = -22, maxThreadsWatermark = 10, numThreads = 10, PrivateMemorySize = 188223488, TotalManagedMemory = 51659888
    <2012-10-30 19:03:01.63 WorkerThread119@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 1 more time(s).  Retrying in 15000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:03:01.63 WorkerThread101@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 1 more time(s).  Retrying in 15000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:03:01.63 WorkerThread88@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 1 more time(s).  Retrying in 15000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:03:01.63 WorkerThread69@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 1 more time(s).  Retrying in 15000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:03:01.63 WorkerThread102@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 1 more time(s).  Retrying in 15000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:03:01.63 WorkerThread115@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 3 more time(s).  Retrying in 5000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:03:01.63 WorkerThread70@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 2 more time(s).  Retrying in 10000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:03:01.63 WorkerThread76@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 2 more time(s).  Retrying in 10000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:03:01.63 WorkerThread134@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 2 more time(s).  Retrying in 10000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:03:06.63 WorkerThread115@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 2 more time(s).  Retrying in 10000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:03:11.60 WorkerThread78@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 1 more time(s).  Retrying in 15000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:03:11.63 WorkerThread70@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 1 more time(s).  Retrying in 15000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:03:11.63 WorkerThread76@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 1 more time(s).  Retrying in 15000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:03:11.63 WorkerThread134@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 1 more time(s).  Retrying in 15000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:03:15.34 TID-382@WatchdogThreadPool,I> UpdateMaxThreadsWatermark() - currentCpuUtil = 100, error = -10, accumulatedCpuUtilError = -41, adjustment = -27.2, countOfThreadsToAdd = -28, maxThreadsWatermark = 10, numThreads = 10, PrivateMemorySize = 188223488, TotalManagedMemory = 51659888
    <2012-10-30 19:03:21.60 TID-400@WatchdogThreadPool,I> UpdateMaxThreadsWatermark() - currentCpuUtil = 100, error = -10, accumulatedCpuUtilError = -51, adjustment = -32.5333333333333, countOfThreadsToAdd = -33, maxThreadsWatermark = 10, numThreads = 10, PrivateMemorySize = 188223488, TotalManagedMemory = 51856496
    <2012-10-30 19:03:26.64 WorkerThread115@DataAccessCore,W> OpenConnection() - Caught an InvalidOperationException trying to connect to the database.  Will retry connection 1 more time(s).  Retrying in 15000 milliseconds.
       |Exception message = 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.
    <2012-10-30 19:03:26.64 WorkerThread101@CollectionTestEvaluationStep,W> CollectionTestEvaluationStep(Name='ShouldTryPerfmonPerfCollection').EvaluateCollectionTest(Device(GUID={342f84dc-feee-4a2b-9b15-1ff2057214a5},DnsHostName='dafehvvmrepos')) - Caught exception while evaluating CollectionTest. Using default value for the test.
       |Microsoft.AssessmentPlatform.MapException: Caught InvalidOperationException trying to open a connection to the database. ---> 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.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
       |   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
       |   at System.Data.SqlClient.SqlConnection.Open()
       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.OpenConnectionIfNecessary()
       |   --- End of inner exception stack trace ---
       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.OpenConnectionIfNecessary()
       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore..ctor(SecureString connectionString)
       |   at Microsoft.AssessmentPlatform.InventoryEngine.InventoryDataAccess.GetInstance(SecureString connectionString, DeviceCollectionState deviceState)
       |   at Microsoft.AssessmentPlatform.InventoryEngine.InventoryService.Microsoft.AssessmentPlatform.InventoryEngine.WorkItems.IWorkItemSupport.GetIInventoryDataAccess2(DeviceCollectionState deviceState)
       |   at Microsoft.AssessmentPlatform.InventoryEngine.DeviceInventory.CollectionTestEvaluationStep.EvaluateCollectionTest(DeviceCollectionState deviceState)
    <2012-10-30 19:03:26.64 WorkerThread101@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 3 more time(s).  Retrying in 5000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:03:30.60 TID-382@InventoryService,E> OnFatalDatabaseException() - Fatal inventory error - Received notification that a DB connection could not be created or an operation timed out after several retries. Exception:
       |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.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
       |   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
       |   at System.Data.SqlClient.SqlConnection.Open()
       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.OpenConnectionIfNecessary()
    <2012-10-30 19:03:30.60 TID-382@InventoryService,I> Stop() - Stopping the inventory engine.
    <2012-10-30 19:03:30.60 TID-382@InventoryService,W> Stop() - 73 work items are still pending in the inventory engine.
    <2012-10-30 19:03:30.60 TID-382@InventoryService,I> Stop() - Giving active work 10 seconds to complete before aborting the work.
    <2012-10-30 19:03:30.60 TID-382@WatchdogThreadPool,I> StopThreadPool() - The WatchdogThreadPool is stopping.
    <2012-10-30 19:03:30.67 Inv:FillWorkItemQueue@InventoryService,I> FillWorkItemQueueThreadProc() - The thread that fills the work item queue is exiting.
    <2012-10-30 19:03:31.81 WorkerThread101@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 2 more time(s).  Retrying in 10000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:03:32.60 WorkerThread134@CollectionTestEvaluationStep,W> CollectionTestEvaluationStep(Name='ShouldTryPerfmonPerfCollection').EvaluateCollectionTest(Device(GUID={aee43f57-42d1-4b23-a709-2497d6f5ebab},DnsHostName='dafehvvmsql5')) - Caught exception while evaluating CollectionTest. Using default value for the test.
       |Microsoft.AssessmentPlatform.MapException: Caught SqlException trying to open a connection to the database. ---> System.Data.SqlClient.SqlException: 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 Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.OpenConnectionIfNecessary()
       |   --- End of inner exception stack trace ---
       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.OpenConnectionIfNecessary()
       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore..ctor(SecureString connectionString)
       |   at Microsoft.AssessmentPlatform.InventoryEngine.InventoryDataAccess.GetInstance(SecureString connectionString, DeviceCollectionState deviceState)
       |   at Microsoft.AssessmentPlatform.InventoryEngine.InventoryService.Microsoft.AssessmentPlatform.InventoryEngine.WorkItems.IWorkItemSupport.GetIInventoryDataAccess2(DeviceCollectionState deviceState)
       |   at Microsoft.AssessmentPlatform.InventoryEngine.DeviceInventory.CollectionTestEvaluationStep.EvaluateCollectionTest(DeviceCollectionState deviceState)
    <2012-10-30 19:03:32.60 WorkerThread134@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 3 more time(s).  Retrying in 5000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:03:32.60 WorkerThread119@CollectionTestEvaluationStep,W> CollectionTestEvaluationStep(Name='ShouldTryPerfmonPerfCollection').EvaluateCollectionTest(Device(GUID={9d7dffe9-4800-4f17-a5be-1f370ff79f42},DnsHostName='dafehvvmmessql2')) - Caught exception while evaluating CollectionTest. Using default value for the test.
       |Microsoft.AssessmentPlatform.MapException: Caught SqlException trying to open a connection to the database. ---> System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
       |   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
       |   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
       |   at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
       |   at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
       |   at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
       |   at System.Data.SqlClient.TdsParser.ConsumePreLoginHandshake(Boolean encrypt, Boolean trustServerCert, Boolean& marsCapable)
       |   at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity)
       |   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject)
       |   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout)
       |   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
       |   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
       |   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
       |   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
       |   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
       |   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
       |   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 Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.OpenConnectionIfNecessary()
       |   --- End of inner exception stack trace ---
       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.OpenConnectionIfNecessary()
       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore..ctor(SecureString connectionString)
       |   at Microsoft.AssessmentPlatform.InventoryEngine.InventoryDataAccess.GetInstance(SecureString connectionString, DeviceCollectionState deviceState)
       |   at Microsoft.AssessmentPlatform.InventoryEngine.InventoryService.Microsoft.AssessmentPlatform.InventoryEngine.WorkItems.IWorkItemSupport.GetIInventoryDataAccess2(DeviceCollectionState deviceState)
       |   at Microsoft.AssessmentPlatform.InventoryEngine.DeviceInventory.CollectionTestEvaluationStep.EvaluateCollectionTest(DeviceCollectionState deviceState)
    <2012-10-30 19:03:32.60 WorkerThread119@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 3 more time(s).  Retrying in 5000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:03:32.60 WorkerThread102@CollectionTestEvaluationStep,W> CollectionTestEvaluationStep(Name='ShouldTryPerfmonPerfCollection').EvaluateCollectionTest(Device(GUID={46e9bc5b-5901-44d9-9e92-268a0ed33309},DnsHostName='dafehvmsql2')) - Caught exception while evaluating CollectionTest. Using default value for the test.
       |Microsoft.AssessmentPlatform.MapException: Caught InvalidOperationException trying to open a connection to the database. ---> 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.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
       |   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
       |   at System.Data.SqlClient.SqlConnection.Open()
       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.OpenConnectionIfNecessary()
       |   --- End of inner exception stack trace ---
       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.OpenConnectionIfNecessary()
       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore..ctor(SecureString connectionString)
       |   at Microsoft.AssessmentPlatform.InventoryEngine.InventoryDataAccess.GetInstance(SecureString connectionString, DeviceCollectionState deviceState)
       |   at Microsoft.AssessmentPlatform.InventoryEngine.InventoryService.Microsoft.AssessmentPlatform.InventoryEngine.WorkItems.IWorkItemSupport.GetIInventoryDataAccess2(DeviceCollectionState deviceState)
       |   at Microsoft.AssessmentPlatform.InventoryEngine.DeviceInventory.CollectionTestEvaluationStep.EvaluateCollectionTest(DeviceCollectionState deviceState)
    <2012-10-30 19:03:32.60 WorkerThread102@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 3 more time(s).  Retrying in 5000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:03:32.60 WorkerThread69@CollectionTestEvaluationStep,W> CollectionTestEvaluationStep(Name='ShouldTryPerfmonPerfCollection').EvaluateCollectionTest(Device(GUID={829af78b-26b5-453b-8e51-0d74474812c5},DnsHostName='dafehvvmlpm4')) - Caught exception while evaluating CollectionTest. Using default value for the test.
       |Microsoft.AssessmentPlatform.MapException: Caught InvalidOperationException trying to open a connection to the database. ---> 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.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
       |   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
       |   at System.Data.SqlClient.SqlConnection.Open()
       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.OpenConnectionIfNecessary()
       |   --- End of inner exception stack trace ---
       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.OpenConnectionIfNecessary()
       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore..ctor(SecureString connectionString)
       |   at Microsoft.AssessmentPlatform.InventoryEngine.InventoryDataAccess.GetInstance(SecureString connectionString, DeviceCollectionState deviceState)
       |   at Microsoft.AssessmentPlatform.InventoryEngine.InventoryService.Microsoft.AssessmentPlatform.InventoryEngine.WorkItems.IWorkItemSupport.GetIInventoryDataAccess2(DeviceCollectionState deviceState)
       |   at Microsoft.AssessmentPlatform.InventoryEngine.DeviceInventory.CollectionTestEvaluationStep.EvaluateCollectionTest(DeviceCollectionState deviceState)
    <2012-10-30 19:03:32.60 WorkerThread69@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 3 more time(s).  Retrying in 5000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:03:32.60 WorkerThread88@CollectionTestEvaluationStep,W> CollectionTestEvaluationStep(Name='ShouldTryPerfmonPerfCollection').EvaluateCollectionTest(Device(GUID={262927c7-7da0-441a-8711-0ed76fb278d5},DnsHostName='dafehvtexact1')) - Caught exception while evaluating CollectionTest. Using default value for the test.
       |Microsoft.AssessmentPlatform.MapException: Caught InvalidOperationException trying to open a connection to the database. ---> 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.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
       |   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
       |   at System.Data.SqlClient.SqlConnection.Open()
       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.OpenConnectionIfNecessary()
       |   --- End of inner exception stack trace ---
       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.OpenConnectionIfNecessary()
       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore..ctor(SecureString connectionString)
       |   at Microsoft.AssessmentPlatform.InventoryEngine.InventoryDataAccess.GetInstance(SecureString connectionString, DeviceCollectionState deviceState)
       |   at Microsoft.AssessmentPlatform.InventoryEngine.InventoryService.Microsoft.AssessmentPlatform.InventoryEngine.WorkItems.IWorkItemSupport.GetIInventoryDataAccess2(DeviceCollectionState deviceState)
       |   at Microsoft.AssessmentPlatform.InventoryEngine.DeviceInventory.CollectionTestEvaluationStep.EvaluateCollectionTest(DeviceCollectionState deviceState)
    <2012-10-30 19:03:32.60 WorkerThread88@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 3 more time(s).  Retrying in 5000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:03:33.60 WorkerThread78@CollectionTestEvaluationStep,W> CollectionTestEvaluationStep(Name='ShouldTryPerfmonPerfCollection').EvaluateCollectionTest(Device(GUID={17168fc7-9ff4-4e32-874f-0783b0968639},DnsHostName='dafehvmcmssql')) - Caught exception while evaluating CollectionTest. Using default value for the test.
       |Microsoft.AssessmentPlatform.MapException: Caught SqlException trying to open a connection to the database. ---> System.Data.SqlClient.SqlException: 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 Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.OpenConnectionIfNecessary()
       |   --- End of inner exception stack trace ---
       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.OpenConnectionIfNecessary()
       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore..ctor(SecureString connectionString)
       |   at Microsoft.AssessmentPlatform.InventoryEngine.InventoryDataAccess.GetInstance(SecureString connectionString, DeviceCollectionState deviceState)
       |   at Microsoft.AssessmentPlatform.InventoryEngine.InventoryService.Microsoft.AssessmentPlatform.InventoryEngine.WorkItems.IWorkItemSupport.GetIInventoryDataAccess2(DeviceCollectionState deviceState)
       |   at Microsoft.AssessmentPlatform.InventoryEngine.DeviceInventory.CollectionTestEvaluationStep.EvaluateCollectionTest(DeviceCollectionState deviceState)
    <2012-10-30 19:03:33.60 WorkerThread78@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 3 more time(s).  Retrying in 5000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:03:33.60 WorkerThread70@CollectionTestEvaluationStep,W> CollectionTestEvaluationStep(Name='ShouldTryPerfmonPerfCollection').EvaluateCollectionTest(Device(GUID={423cf340-3640-4ad0-99ba-0a3cf166db6c},DnsHostName='dafehvvtdds1')) - Caught exception while evaluating CollectionTest. Using default value for the test.
       |Microsoft.AssessmentPlatform.MapException: Caught SqlException trying to open a connection to the database. ---> System.Data.SqlClient.SqlException: 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 Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.OpenConnectionIfNecessary()
       |   --- End of inner exception stack trace ---
       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.OpenConnectionIfNecessary()
       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore..ctor(SecureString connectionString)
       |   at Microsoft.AssessmentPlatform.InventoryEngine.InventoryDataAccess.GetInstance(SecureString connectionString, DeviceCollectionState deviceState)
       |   at Microsoft.AssessmentPlatform.InventoryEngine.InventoryService.Microsoft.AssessmentPlatform.InventoryEngine.WorkItems.IWorkItemSupport.GetIInventoryDataAccess2(DeviceCollectionState deviceState)
       |   at Microsoft.AssessmentPlatform.InventoryEngine.DeviceInventory.CollectionTestEvaluationStep.EvaluateCollectionTest(DeviceCollectionState deviceState)
    <2012-10-30 19:03:33.60 WorkerThread70@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 3 more time(s).  Retrying in 5000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:03:33.60 WorkerThread76@CollectionTestEvaluationStep,W> CollectionTestEvaluationStep(Name='ShouldTryPerfmonPerfCollection').EvaluateCollectionTest(Device(GUID={e0c8c331-207f-414b-b158-0acd9b271432},DnsHostName='dafehvmsql4')) - Caught exception while evaluating CollectionTest. Using default value for the test.
       |Microsoft.AssessmentPlatform.MapException: Caught SqlException trying to open a connection to the database. ---> System.Data.SqlClient.SqlException: 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 Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.OpenConnectionIfNecessary()
       |   --- End of inner exception stack trace ---
       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore.OpenConnectionIfNecessary()
       |   at Microsoft.AssessmentPlatform.DataAccess.DataAccessCore..ctor(SecureString connectionString)
       |   at Microsoft.AssessmentPlatform.InventoryEngine.InventoryDataAccess.GetInstance(SecureString connectionString, DeviceCollectionState deviceState)
       |   at Microsoft.AssessmentPlatform.InventoryEngine.InventoryService.Microsoft.AssessmentPlatform.InventoryEngine.WorkItems.IWorkItemSupport.GetIInventoryDataAccess2(DeviceCollectionState deviceState)
       |   at Microsoft.AssessmentPlatform.InventoryEngine.DeviceInventory.CollectionTestEvaluationStep.EvaluateCollectionTest(DeviceCollectionState deviceState)
    <2012-10-30 19:03:33.60 WorkerThread76@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 3 more time(s).  Retrying in 5000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:03:37.61 WorkerThread88@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 2 more time(s).  Retrying in 10000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:03:37.61 WorkerThread69@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 2 more time(s).  Retrying in 10000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:03:37.61 WorkerThread102@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 2 more time(s).  Retrying in 10000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:03:37.61 WorkerThread119@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 2 more time(s).  Retrying in 10000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:03:37.61 WorkerThread134@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 2 more time(s).  Retrying in 10000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:03:38.61 WorkerThread76@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 2 more time(s).  Retrying in 10000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:03:38.61 WorkerThread70@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 2 more time(s).  Retrying in 10000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:03:38.61 WorkerThread78@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 2 more time(s).  Retrying in 10000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:03:40.73 WorkerThread115@DeviceInventoryWorkItem,I> InventoryWorkCallback() - Device(GUID={4d25a09c-ebe5-4534-b073-20cce9778f1d},DnsHostName='dafehvvolpm3') : Device inventory was aborted.
    <2012-10-30 19:03:40.73 WorkerThread102@DeviceInventoryWorkItem,I> InventoryWorkCallback() - Device(GUID={46e9bc5b-5901-44d9-9e92-268a0ed33309},DnsHostName='dafehvmsql2') : Device inventory was aborted.
    <2012-10-30 19:03:40.73 WorkerThread102@WatchdogThreadPool,I> Worker() - WorkerThread102 is being aborted.
    <2012-10-30 19:03:40.73 WorkerThread102@WatchdogThreadPool,I> Worker() - WorkerThread102 is exiting.
    <2012-10-30 19:03:40.73 WorkerThread115@WatchdogThreadPool,I> Worker() - WorkerThread115 is being aborted.
    <2012-10-30 19:03:40.73 WorkerThread115@WatchdogThreadPool,I> Worker() - WorkerThread115 is exiting.
    <2012-10-30 19:03:40.76 WorkerThread69@DeviceInventoryWorkItem,I> InventoryWorkCallback() - Device(GUID={829af78b-26b5-453b-8e51-0d74474812c5},DnsHostName='dafehvvmlpm4') : Device inventory was aborted.
    <2012-10-30 19:03:40.76 WorkerThread69@WatchdogThreadPool,I> Worker() - WorkerThread69 is being aborted.
    <2012-10-30 19:03:40.76 WorkerThread69@WatchdogThreadPool,I> Worker() - WorkerThread69 is exiting.
    <2012-10-30 19:03:40.78 WorkerThread88@DeviceInventoryWorkItem,I> InventoryWorkCallback() - Device(GUID={262927c7-7da0-441a-8711-0ed76fb278d5},DnsHostName='dafehvtexact1') : Device inventory was aborted.
    <2012-10-30 19:03:40.78 WorkerThread88@WatchdogThreadPool,I> Worker() - WorkerThread88 is being aborted.
    <2012-10-30 19:03:40.78 WorkerThread88@WatchdogThreadPool,I> Worker() - WorkerThread88 is exiting.
    <2012-10-30 19:03:40.79 WorkerThread101@DeviceInventoryWorkItem,I> InventoryWorkCallback() - Device(GUID={342f84dc-feee-4a2b-9b15-1ff2057214a5},DnsHostName='dafehvvmrepos') : Device inventory was aborted.
    <2012-10-30 19:03:40.79 WorkerThread101@WatchdogThreadPool,I> Worker() - WorkerThread101 is being aborted.
    <2012-10-30 19:03:40.79 WorkerThread101@WatchdogThreadPool,I> Worker() - WorkerThread101 is exiting.
    <2012-10-30 19:03:40.81 WorkerThread119@DeviceInventoryWorkItem,I> InventoryWorkCallback() - Device(GUID={9d7dffe9-4800-4f17-a5be-1f370ff79f42},DnsHostName='dafehvvmmessql2') : Device inventory was aborted.
    <2012-10-30 19:03:40.81 WorkerThread119@WatchdogThreadPool,I> Worker() - WorkerThread119 is being aborted.
    <2012-10-30 19:03:40.81 WorkerThread119@WatchdogThreadPool,I> Worker() - WorkerThread119 is exiting.
    <2012-10-30 19:03:40.82 WorkerThread78@DeviceInventoryWorkItem,I> InventoryWorkCallback() - Device(GUID={17168fc7-9ff4-4e32-874f-0783b0968639},DnsHostName='dafehvmcmssql') : Device inventory was aborted.
    <2012-10-30 19:03:40.84 WorkerThread70@DeviceInventoryWorkItem,I> InventoryWorkCallback() - Device(GUID={423cf340-3640-4ad0-99ba-0a3cf166db6c},DnsHostName='dafehvvtdds1') : Device inventory was aborted.
    <2012-10-30 19:03:40.86 WorkerThread76@DeviceInventoryWorkItem,I> InventoryWorkCallback() - Device(GUID={e0c8c331-207f-414b-b158-0acd9b271432},DnsHostName='dafehvmsql4') : Device inventory was aborted.
    <2012-10-30 19:03:40.86 WorkerThread76@WatchdogThreadPool,I> Worker() - WorkerThread76 is being aborted.
    <2012-10-30 19:03:40.86 WorkerThread76@WatchdogThreadPool,I> Worker() - WorkerThread76 is exiting.
    <2012-10-30 19:03:40.87 WorkerThread134@DeviceInventoryWorkItem,I> InventoryWorkCallback() - Device(GUID={aee43f57-42d1-4b23-a709-2497d6f5ebab},DnsHostName='dafehvvmsql5') : Device inventory was aborted.
    <2012-10-30 19:03:40.89 TID-382@WatchdogThreadPool,I> StopThreadPool() - The WatchdogThreadPool is stopped.
    <2012-10-30 19:03:40.89 TID-382@InventoryService,W> Stop() - Aborted in progress work item: DeviceInventoryWorkItem(GUID={4d25a09c-ebe5-4534-b073-20cce9778f1d},DnsHostName='dafehvvolpm3')
    <2012-10-30 19:03:40.89 TID-382@InventoryService,W> Stop() - Aborted in progress work item: DeviceInventoryWorkItem(GUID={46e9bc5b-5901-44d9-9e92-268a0ed33309},DnsHostName='dafehvmsql2')
    <2012-10-30 19:03:40.89 TID-382@InventoryService,W> Stop() - Aborted in progress work item: DeviceInventoryWorkItem(GUID={829af78b-26b5-453b-8e51-0d74474812c5},DnsHostName='dafehvvmlpm4')
    <2012-10-30 19:03:40.89 TID-382@InventoryService,W> Stop() - Aborted in progress work item: DeviceInventoryWorkItem(GUID={262927c7-7da0-441a-8711-0ed76fb278d5},DnsHostName='dafehvtexact1')
    <2012-10-30 19:03:40.89 TID-382@InventoryService,W> Stop() - Aborted in progress work item: DeviceInventoryWorkItem(GUID={342f84dc-feee-4a2b-9b15-1ff2057214a5},DnsHostName='dafehvvmrepos')
    <2012-10-30 19:03:40.89 TID-382@InventoryService,W> Stop() - Aborted in progress work item: DeviceInventoryWorkItem(GUID={9d7dffe9-4800-4f17-a5be-1f370ff79f42},DnsHostName='dafehvvmmessql2')
    <2012-10-30 19:03:40.89 TID-382@InventoryService,W> Stop() - Aborted in progress work item: DeviceInventoryWorkItem(GUID={17168fc7-9ff4-4e32-874f-0783b0968639},DnsHostName='dafehvmcmssql')
    <2012-10-30 19:03:40.89 TID-382@InventoryService,W> Stop() - Aborted in progress work item: DeviceInventoryWorkItem(GUID={423cf340-3640-4ad0-99ba-0a3cf166db6c},DnsHostName='dafehvvtdds1')
    <2012-10-30 19:03:40.89 TID-382@InventoryService,W> Stop() - Aborted in progress work item: DeviceInventoryWorkItem(GUID={e0c8c331-207f-414b-b158-0acd9b271432},DnsHostName='dafehvmsql4')
    <2012-10-30 19:03:40.89 TID-382@InventoryService,W> Stop() - Aborted in progress work item: DeviceInventoryWorkItem(GUID={aee43f57-42d1-4b23-a709-2497d6f5ebab},DnsHostName='dafehvvmsql5')
    <2012-10-30 19:03:40.92 Inv:CompletedWorkItems@InventoryService,I> CompletedWorkItemConsumerThreadProc() - The completed work item consumer thread is exiting.
    <2012-10-30 19:03:41.03 WorkerThread70@WatchdogThreadPool,I> Worker() - WorkerThread70 is being aborted.
    <2012-10-30 19:03:41.03 WorkerThread70@WatchdogThreadPool,I> Worker() - WorkerThread70 is exiting.
    <2012-10-30 19:03:41.07 WorkerThread78@WatchdogThreadPool,I> Worker() - WorkerThread78 is being aborted.
    <2012-10-30 19:03:41.07 WorkerThread78@WatchdogThreadPool,I> Worker() - WorkerThread78 is exiting.
    <2012-10-30 19:03:41.21 WorkerThread134@WatchdogThreadPool,I> Worker() - WorkerThread134 is being aborted.
    <2012-10-30 19:03:41.21 WorkerThread134@WatchdogThreadPool,I> Worker() - WorkerThread134 is exiting.
    <2012-10-30 19:03:44.25 TID-382@InventoryService,I> MakeProgressNotification() - Final inventory progress event:
       |InventoryProgressEvent
       |  Finished    = True
       |  FatalError  = 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.
       |  Elapsedtime = 28:19:02.750
       |
       |  ExistingDevicesCount            = 74
       |  TotalDiscoveredDevicesCount     = 74
       |  NewDiscoveredDevicesCount       = 0
       |  InventoryJobsToRetryCount       = 74
       |  InventoryJobsCompleteCount      = 25160
       |  AggregateInventoryJobThroughput = 14.8083115277938
       |
       |  ActiveDirectory(#Job, #Completed, #Discovered, #NewlyDiscovered) = (0, 0, 0, 0)
       |  NetBios(#Job, #Completed, #Discovered, #NewlyDiscovered) = (0, 0, 0, 0)
       |  ManuallyAdded(#Job, #Completed, #Discovered, #NewlyDiscovered) = (1, 1, 74, 0)
       |  IPRange(#Job, #Completed, #Discovered, #NewlyDiscovered) = (0, 0, 0, 0)
       |  InventoryData(#Job, #Completed, #Discovered, #NewlyDiscovered) = (0, 0, 0, 0)
       |  SystemCenter(#Job, #Completed, #Discovered, #NewlyDiscovered) = (0, 0, 0, 0)
       |
       |  Wmi(#Success, #Partial, #Failure, #N/A, #Instance) = (74, 0, 0, 0, 36874)
       |  Registry(#Success, #Partial, #Failure, #N/A, #Instance) = (74, 0, 0, 0, 26594)
       |  Perfmon(#Success, #Partial, #Failure, #N/A, #Instance) = (25001, 0, 85, 0, 143226)
       |  VMware(#Success, #Partial, #Failure, #N/A, #Instance) = (0, 0, 0, 0, 0)
       |  Ssh(#Success, #Partial, #Failure, #N/A, #Instance) = (0, 0, 0, 0, 0)
       |  Sql(#Success, #Partial, #Failure, #N/A, #Instance) = (0, 0, 0, 0, 0)
       |  AD(#Success, #Partial, #Failure, #N/A, #Instance) = (0, 0, 0, 0, 0)
       |  PowerShell(#Success, #Partial, #Failure, #N/A, #Instance) = (0, 0, 0, 0, 0)
       |
    <2012-10-30 19:03:44.25 TID-382@InventoryWorker,I> InventoryProgressChanged() - The inventory engine had a fatal error.
    <2012-10-30 19:03:44.25 Inventory@TaskProcessor,I> WorkerCompleted: Worker: 'Inventory'
    <2012-10-30 19:03:44.25 TID-448@TaskProcessor,I> Run: Completed. Status: Failed
    <2012-10-30 19:03:44.25 TID-448@DataAccessCore,W> OpenConnection() - Caught a SqlException trying to connect to the database.  Will retry connection 3 more time(s).  Retrying in 5000 milliseconds.
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:03:44.25 TID-382@InventoryService,I> Stop() - The inventory engine is stopped.
    <2012-10-30 19:04:13.92 TID-448@DataAccessCore,W> DoWorkInTransaction<T>() - Caught a SQL transaction timeout exception. Will retry 3 more time(s). Retrying in 5000 milliseconds.
       |onSqlExceptionMessage = GetEnoughDataStatus: A SQL exception occurred running: '[dbo].[sp_get_enough_data_status]'
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:04:40.61 TID-448@DataAccessCore,W> DoWorkInTransaction<T>() - Caught a SQL transaction timeout exception. Will retry 2 more time(s). Retrying in 10000 milliseconds.
       |onSqlExceptionMessage = GetEnoughDataStatus: A SQL exception occurred running: '[dbo].[sp_get_enough_data_status]'
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    <2012-10-30 19:04:56.56 TID-448@ProgressPage,I> ProgressPage.TaskCompletedCallback: sender: Microsoft.AssessmentPlatform.UI.Console.Tasks.TaskProcessor
    <2012-10-31 12:37:16.98 TID-1@WunderBarBasePage,I> DisplayViewPage(): View 'LogFilesView' failed a view predicate. Reason message: Inventory data needs to be assessed.
    <2012-10-31 12:37:16.98 TID-1@WunderBarBasePage,I> DisplayViewPage: Opening view type: PredicateFailedView

    I hope some one is able to help me out here.

    Thanks in advance,

    Teun

    Thursday, November 1, 2012 9:49 AM

All replies

  • The SQL errors that are showing up are from when MAP tries to talk to the SQL database it uses to store all of the data collected. Since you are running a performance scan, MAP is only collecting OS level data and isn't doing anything with the SQL Server instance on the machine. These errors can happen if the machine is starved for resources or if there is a problem with the install of SQL, but more likely a resource issue.


    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. Please VOTE as HELPFUL if the post helps you. This can be beneficial to other community members reading the thread.

    Monday, December 3, 2012 11:35 PM
    Moderator