Shortly after applying an upgrade to an SMP server it would no longer log events to the event tables such as Evt_NS_Client_Config_Request, Evt_NS_Event_History etc.
The server logs were streaming with errors similar to the following (excerpt):
******************** Description: Unspecified Dataloader Exception encountered for event data class cff75f1d-016a-4ce7-a22c-5c28ed69de0c! **CEDUrlStart** :http://entced.symantec.com/entt?product=SMPversion=7.0.8900.0language=enmodule=tuQXeaI16AIw6qceQwtdv6ZBcrgKgtNkSySJoBJmrTT53eebWYINkaf4OYCoMko9error=1364880097build=**CEDUrlEnd**
( Exception Details: System.Data.SqlClient.SqlException: Invalid column value 00000000-0000-0000-0000-000000000000, table 'Symantec_CMDB.dbo.ResourceUpdateSummary'; empty GUIDs are not allowed. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) ********************
Each error was specific to a certain data class and each of the following data classes were represented in one-to-many of the previous error.
The "NSResourceGuid" element is missing from CoreSettings.config
Explanation: Each of the previous data classes are tracked within the ResourceUpdateSummary table. But since they are "server specific" events there should only be one row in the table for each of these data classes; and the Guid that should be stamped into the "ResourceGuid" column of each row should be only that of the NS.
The table is updated by the stored procedure "spResourceUpdateSummary". The first section in the procedure's code are instructions to throw an error if the GUID 00000000-0000-0000-0000-000000000000 is passed in. And the reason a GUID with all zeros is being passed in is because the NSResourceGuid element is missing, which is what tell the NS what its GUID is. It has no other way of determining what its GUID is an therefore, if it is missing, it passes in all zeros.
1. Edit CoreSettings.config which should be found in one of the following locations: