KNOWN ISSUE: Getting a SQL error when rendering dashboard in Notification Server 6.0 and 6.5 console

Article:TECH34302  |  Created: 2007-09-05  |  Updated: 2007-09-12  |  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


I receive the following SQL error when trying to access the dashboard in Notification Server 6.5 and 6.0 console:

Description: Sql error in query. Error: System.Data.SqlClient.SqlError: The error description is 'The following tags were not closed: item, PatchManagementSolutionPolicy, CoreConfig, SWReleasesToExcludeFromSWUpdatesImport.'.System.Data.SqlClient.SqlError: Could not find prepared statement with handle 0.System.Data.SqlClient.SqlError: sp_xml_removedocument: The value supplied for parameter number 1 is invalid.Sql CommandText:

                           -- MAX ROWCOUNT

                           SET ROWCOUNT 50000

Why am I receiving this error?


The varchar limit within the stored procedure spPMCore_GetExcludedReleases is being reached. Run the attached SQL script to correct the problem.

Note: The script will only work with SQL 2005.

KB46144 "Combined fixes for known Patch Report Discrepencies, Dashboard issues etc" also includes this fix and several more.


spPMCore_GetExcludedReleases.sql (2 kBytes)

Supplemental Materials

ValueLB 31443
DescriptionLogged in Littlebuggy (Altiris - Lindon, Plymouth) database

ValueSYD 31443
DescriptionLogged in sydd2 (Altiris - Sydney) database

Legacy ID


Article URL

Terms of use for this information are found in Legal Notices