KNOWN ISSUE: SQL Error while executing Monitor Policy Activity Summary drill down

Article:TECH26355  |  Created: 2007-02-13  |  Updated: 2010-08-20  |  Article URL
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


The Monitor Policy Activity Summary report will return a SQL error message when you double click a row in the report.

Log File Name: C:\Program Files\Altiris\Notification Server\Logs\a.log
Source: SqlQueryBase/RunQuery
Description: Sql error in query. Error: System.Data.SqlClient.SqlError: Syntax error converting the varchar value 'True' to a column of data type bit.Sql CommandText:
    SET ROWCOUNT 50000


Application Metering Solution 6.1.x
Application Metering Report Pack 6.1.1080


MS SQL 2000 SP4


The SQL query does not work on SQL Server 2000


To work around this issue please follow the steps below:

  1. Browse to Reports > Software Management > Application Metering > Agent Status > Monitor Policy Activity Summary
  2. Right click this report and select 'Clone'
  3. You can type in a name for the cloned report if you choose to, otherwise click 'Ok'.
  4. Click 'Edit this report'
  5. Click the pencil icon next to the Level 1 query 
  6. Scroll to the bottom of the Query Builder window
  7. Change the following line:
    AND ia.Enabled = %_Enabled%
    AND ia.Enabled = CASE %_Enabled% WHEN 'True' THEN 1 ELSE 0 END
  8. Click 'Finish'
  9. You will return to the report page, next click 'Apply'

The Monitor Policy Activity Summary report will now return results when the report contains computers in the 'Count of Computers with Activity' column.


This issue is scheduled to be fixed in a future release of Application Metering.

Supplemental Materials

ValueLB 57494

Logged in Littlebuggy (Altiris - Lindon, Plymouth) database

Legacy ID


Article URL

Terms of use for this information are found in Legal Notices