'GetClientTaskServers.aspx' or 'PersistentSettings.aspx' requests take much time to complete or time out.

book

Article ID: 170336

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server)

Issue/Introduction

You may experience the following symptoms:
- Symantec Management Agents (SMAs) are not able to update configuration;
- SMAs cannot register to Task Servers (TSs);
- Tasks and jobs fail.

Altiris Profiler analysis shows that 'GetClientTaskServers.aspx' or 'PersistentSettings.aspx' requests either take minutes to complete or time out. 

The corresponding errors can be seen from Altiris Log Viewer (see below). 

The handler 'GetClientTaskServers' is failed to process request. 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 XXXX. 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.

The handler 'PersistentSettings' is failed to process request. 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 XXXX. 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.

Cause

New defect. A design flow was detected in the way how the process works with the internal target cache


 

Environment

ITMS 7.6 HF7 with SMA_SMF_SMP_7.6_POST_HF7_P2P_v10 (or below). 

There are more chances to encounter this problem in an environment with a number of managed computers close to the upper recommended limit per Notification Server (20 000 computers in 7.6). 

Resolution

The symptoms are very generic and the best way to ensure that you need to install the fix is to use Altiris Profiler. 

Pay attention that the SQL queries took milliseconds to complete ((1) 3 queries, 11 milliseconds), though the longest delay was in 'the SiteServiceLoator / GetSiteServers' code block (2). 

There can be other reasons why all SQL connection have been consumed, but 'GetClientTaskServers.aspx' or 'PersistentSettings.aspx' requests should definitely stand out of other requests if 'Code Trace' is filtered by 'duration' in Altiris Profiler in this scenario. 

ITMS 7.6 HF7 users. Install SMA_SMF_SMP_7.6_POST_HF7_P2P_v11.zip  from KB INFO3459

ITMS 8.1 users, this issue has been addressed with ITMS 8.1 RU4 release. 

 

Attachments