Cloned Patch Compliance report(s) displays "Unknown Error"
Article ID: 173564
Updated On:
Products
Issue/Introduction
Getting "Unknown Error" when attempting to view cloned patch compliance reports on Symantec Management Platform (SMP) console. The issue started after an upgrade to 8.5 RU1. These report cannot be edited or deleted.
Note: Default compliance reports for Patch Management Solution for Windows are listed under Reports> All Reports, Software> Patch Management> Compliance> Windows.
Following message appears in SMP logs when attempting to view the cloned report:
"Failed to load parameter from xml (skipped):
<parameter><name>FilterCollection</name><description></description><required>false</required><nullable>true</nullable><parameterTypeGuid>40d6ba82-776b-4d89-b1a8-8322b6ca64f5</parameterTypeGuid><testValue></testValue><defaultValue>01024956-1000-4cdb-b452-7db0cff541b6</defaultValue><order>10</order><valueProvider classGuid="891d9058-6b53-4a59-8aff-cf9b4ba13976"><configuration readonly="False" hideOnError="False"><style labelVisible="True" linkInSummary="True" showNoControls="True" allowMultiSelect="False" /></configuration></valueProvider><requiredParameters /><configurationControlClassGuid>73bded50-f1aa-4ff4-a80e-a6c9e047d472</configurationControlClassGuid></parameter>
The specified GUID does not refer to a registered class: 891d9058-6b53-4a59-8aff-cf9b4ba13976"
Environment
SMP 8.5 RU1
Cause
These cloned reports created before a subsequent upgrade to 8.5 RU1, become corrupted due to the report GUIDs being changed. After an upgrade is complete, the database does not recognize these GUIDs and cannot display, edit, or delete these reports on the Console.
Resolution
Use the following SQL query to replace all cloned and corrupted report's GUIDs to the correct ones:
Declare @t as table (guid uniqueidentifier)Insert into @t select guidfrom vitem where classguid = 'a968a2a6-c9b9-483b-b9e0-7f0b199f9da3' and (ProductGuid ='B1338338-5575-4A27-9808-23BEC40D79FA' or ProductGuid = 'C6D19F78-1434-49AC-BEC8-D18255E99F58' or ProductGuid = 'C6D19F78-1434-49AC-BEC8-D18255E99F57' or ProductGuid = 'c6b52ec2-597c-4efe-8830-b92f11888a4a') and state like '%891D9058-6B53-4A59-8AFF-CF9B4BA13976%'update item set state = replace(cast(state as nvarchar(max)), 'valueProvider classGuid="891D9058-6B53-4A59-8AFF-CF9B4BA13976"', 'valueProvider classGuid="fd8b9293-29b1-42e2-bac5-7774df8143cc"')where guid in (select guid from @t)Then refresh the reports page on SMP console.
Note: Access to SQL server is required to run this query. It is always recommended to take a full backup of the database (Symantec_CMDB), before running any query directly on SQL server.
Feedback
