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 http://www.symantec.com/docs/TECH34302|
|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.|
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.
|Description||Logged in Littlebuggy (Altiris - Lindon, Plymouth) database|
|Description||Logged in sydd2 (Altiris - Sydney) database|
Article URL http://www.symantec.com/docs/TECH34302