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

Article:TECH26355  |  Created: 2007-02-13  |  Updated: 2010-08-20  |  Article URL http://www.symantec.com/docs/TECH26355
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



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:
    -- MAX ROWCOUNT
    SET ROWCOUNT 50000
    --


Environment



Application Metering Solution 6.1.x
Application Metering Report Pack 6.1.1080

 

MS SQL 2000 SP4


Cause



The SQL query does not work on SQL Server 2000


Solution



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%
    to:
    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
Description

Logged in Littlebuggy (Altiris - Lindon, Plymouth) database


Legacy ID



32774


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


Terms of use for this information are found in Legal Notices