KNOWN ISSUE: Dashboard Reports for ''Configuration'' section shows errors

Article:TECH35965  |  Created: 2007-10-11  |  Updated: 2008-02-11  |  Article URL http://www.symantec.com/docs/TECH35965
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



Dashboard Reports for "Configuration" section shows errors if many (about 200+) exclusions are configured in the 'Patch Management Core Solution':

Log File Name: C:\Program Files\Altiris\Notification Server\Logs\a30.log
Priority: 1
Date: 11.10.2007 17:26:34
Tick Count: 175924734
Host Name: ********
Process: w3wp.exe (6928)
Thread ID: 7464
Module: AltirisNativeHelper.dll
Source: Altiris.PatchManagement.Web.Dashboards.PatchManagementDashboard.RenderConfiguration
Description: An error occurred when Patch Management for Windows attempted to use stored procedure spPMWindows_Dashboard_ConfigurationSummary. Possible causes for this are that the Report Pack for Patch Windows is not installed or that the data returned from executing the procedure was not in the expected format. ( Unhandled exception.  Type=System.Data.SqlClient.SqlException Msg=The error description is 'The following tags were not closed: item, PatchManagementSolutionPolicy, CoreConfig, SWReleasesToExcludeFromSWUpdatesImport.'.
Could not find prepared statement with handle 0.
sp_xml_removedocument: The value supplied for parameter number 1 is invalid. Src=.Net SqlClient Data Provider
StackTrace=
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at Altiris.PatchManagement.Web.Dashboards.PatchManagementDashboard.RenderConfiguration(DatabaseContext dc) )


Environment



Notification Server 6.0 SP3 R4 or R6
SQL* 2000 or 2005
Windows* 2003 SP1
Patch Management Solution 6.2 SP1

Cause



The varchar limit within the stored procedure spPMCore_GetExcludedReleases is being reached and the data is cut off, which makes it invalid XML for SQL Server to process.

Solution



Option 1:Remove all Exclusions from the "Patch Management Core Solution" Settings. This is tentatively scheduled to be fixed in Patch Management Solution 7.0.

Option 2:  Run the attached SQL script to correct the problem.

Note: The script will only work with SQL 2005. If the environment has SQL 2000, then go to KB 52838.

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


Supplemental Materials

SourceDEFECT
ValueSYD 31443
DescriptionLogged in sydd2 (Altiris - Sydney) database


Legacy ID



38719


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


Terms of use for this information are found in Legal Notices