ERROR: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool.
search cancel

ERROR: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool.

book

Article ID: 162176

calendar_today

Updated On:

Products

IT Management Suite

Issue/Introduction

Errors can occur during many different processes, basically any process that attempts to get a connection after the defined pool has been used.

This has been noted with some of the following.

  • Replication
  • NSE Processing
  • Console access
  • Agent Configuration Requests

Failed to get status of destination replication job. jobId:{f22f3dec-9c28-4ad4-baaa-ed31bd8f63c9}, operationId:{dbc77bf4-b557-4edc-82d4-cbb6e75e1263}, stage:Wait, type:Export, itemType:Item, status:InProgress
Server was unable to process request. ---> Failed to construct DatabaseContext object. Connection to database failed. ---> Failed to open database connection. Current user is Symantec\altrisadmin. Error: Exception has been thrown by the target of an invocation. ---> Exception has been thrown by the target of an invocation. ---> 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.
 

Cause

When a connection string is created to an SQL server, there is an option to define how many connections it can use.  By default the connection string for the Symantec Management Platform is set to 200 (prior to SMP 7.6 HF6).  This message happens when the defined amount of connections has been exceeded. When there are too many very slow/long connections from clients, these can use out whole DB pool quickly.

Resolution

Starting with SMP 7.6 HF6, the default value for DBMaxPoolSize was increased from 200 to 400.

Prior to SMP 7.6 HF6:

Steps to increase the pool size:

  1. Open C:\Program Files\Altiris\Notification Server\Bin\Tools\NSConfigurator.exe
  2. In NSConfigurator open coresettings>Database Settings>DBMaxPoolSize
  3. Changed the setting from the default of 200 to 500
  4. Stop and restart the Altiris Service

Post to SMP 7.6 HF6:

Steps to increase the pool size:

  1. Open C:\Program Files\Altiris\Notification Server\Bin\Tools\NSConfigurator.exe
  2. In NSConfigurator open coresettings>Database Settings>DBMaxPoolSize
  3. Changed the setting from the default of 400 to 500 (or 1000 if 500 didn't help but no more than 5000)
  4. Stop and restart the Altiris Service