After upgrading to ITMS 8.5 RU1 many previously cloned reports cannot be edited or deleted. When attempting to view the cloned patch compliance reports in the Symantec Management Platform (SMP) a message "Unknown Error" is returned.
Note: Default compliance reports for Patch Management Solution for Windows are listed in the SMP Console under:
Reports > All Reports > Software > Patch Management > Compliance > Windows
The following message appears in the SMP logs when attempting to view the cloned reports:
"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"
ITMS 8.5 RU1
The cloned reports were created before an upgrade to ITMS 8.5 RU1 and they apparently become corrupted due to the report's GUIDs being changed. After the upgrade was completed the database did not recognize the original GUIDs and the reports could not be display, edit, or delete from the SMP Console.
Use the following SQL query to replace all cloned and corrupted report's GUIDs to the correct ones:
Note: It is always recommended to take a full backup of the database (Symantec_CMDB) prior to running any query on SQL database.