Updating dependencies in IT Analytics times out

Article:TECH200422  |  Created: 2012-12-03  |  Updated: 2013-01-11  |  Article URL http://www.symantec.com/docs/TECH200422
NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made.
Article Type
Technical Solution


Issue



When attempting to update dependencies in IT Analytics, either by adding/removing linked servers or by clicking Update Dependencies (Settings > IT Analytics > Connections > Symantec CMDB), the Console displays a text box stating "Updating Dependencies" for three minutes and then displays another text box stating "Error Updating Dependencies:Unknown Server Error".

 


Error



In the NS logs the following error will be seen immediately after the "Unknown Server Error":

Unhandled exception.  Type=System.Web.HttpException Msg=Request timed out.

Extra Details:  Type=System.Threading.ThreadAbortException Src=Altiris.ITAnalyticsCSMP )","Altiris.ITAnalyticsCSMP.Web.Services.CMDBConnectionManager.RegenerateViews","w3wp","1084"
Exception in Regenerate Views inside CSMP ConnectionsThread was being aborted.


Environment



IT Analytics 7.1 SP2


Cause



The background process behind updating dependencies is executing the stored procedure spITAnalytics_CSMP_CreateViews. If the stored procedure takes over three minutes to execute, this will cause the console to timeout, causing the "Unknown Server Error". This can be tested by manually executing the stored procedure from SQL Management Studio.


Solution



Edit and add the following directly below <system.web> within the Web.config file located in C:\Program Files\Altiris\ITAnalyticsCSMP\Web:

<httpRuntime executionTimeout="90" maxRequestLength="4096" useFullyQualifiedRedirectUrl="false"
minFreeThreads="8" minLocalRequestFreeThreads="4" appRequestQueueLimit="100" />


Note: The provided addition to the web.config file can be found within the following Microsoft KB

http://support.microsoft.com/kb/825739




Article URL http://www.symantec.com/docs/TECH200422


Terms of use for this information are found in Legal Notices