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.|
Log File Name: C:\Program Files\Altiris\Notification Server\Logs\a30.log
Date: 11.10.2007 17:26:34
Tick Count: 175924734
Host Name: ********
Process: w3wp.exe (6928)
Thread ID: 7464
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
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) )
Notification Server 6.0 SP3 R4 or R6
SQL* 2000 or 2005
Windows* 2003 SP1
Patch Management Solution 6.2 SP1
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.
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.
|Description||Logged in sydd2 (Altiris - Sydney) database|
Article URL http://www.symantec.com/docs/TECH35965