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
@Collection='All Windows Computers with File Inventory Agent Installed',
@CompanyName='%', @ProductName='%', @ExeName=@param1, @CertName='%',
@TimeUnit=Day, @TimeValue=7, @culture = 'en-US'
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.
Application Control Solution 6.1