KNOWN ISSUE: Unable to load Manage Applications page - SQL Timeout

Article:TECH40946  |  Created: 2008-12-01  |  Updated: 2009-02-09  |  Article URL http://www.symantec.com/docs/TECH40946
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



Unable to load Manage Applications page of the Application Control Solution

a.log report the following error with the following description:
Unexpected exception encountered while running a query.Report
"Summary of Win32 Executables" Summary of Win32 Executables. ( Unhandled
exception.  Type=Altiris.NS.StandardItems.Query.AeXSqlException Msg=Sql
error in query. Error: System.Data.SqlClient.SqlError: Timeout expired.  The
timeout period elapsed prior to completion of the operation or the server is
not responding.Sql CommandText:
               -- MAX ROWCOUNT
               SET ROWCOUNT 50000
               --
               EXEC dbo.[spFIReport_SummaryWin32Executables]
@Collection='All Windows Computers with File Inventory Agent Installed',
@CompanyName='%', @ProductName='%', @ExeName=@param1, @CertName='%',
@TimeUnit=Day, @TimeValue=7, @culture = 'en-US'

Environment



Application Control Solution 6.1

Cause



The SQL server created an execution plan for the stored procedures used for this page that is much more costly than needed.  To some degree this issue is environmental as SQL's optimizer creates execution plans based on statistics, available indexes, and available resources on the SQL instance.  In some environments the same data executes in much shorting time frame, but in others takes a long time dumping lots of data into the tempdb.

Solution



This issue is resolved in Altiris Application Control 6.1 sp1 (see KB 45582)

For customer that cannot upgrade to sp1 here is other workaround.

The attached SQL command updates the stored procedures associated with this main stored procedures that is more optimized allowing SQL's optimizer to make a much better execution plan to get the same data.

To install these updated stored procedures, download the attached SQL file "spFIReport_SummaryWin32ExecutableAB-v2.sql", open it using SQL Server Management Studio (or SQL Query Analyzer for SQL 2000) connected to the Altiris database and Execute it.  


Supplemental Materials

SourceDEFECT
ValueOEM 44577
DescriptionLogged in OEM (Altiris - Partner Product) database


Legacy ID



44577


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


Terms of use for this information are found in Legal Notices