Event Logging stopped after applying an upgrade.

Article:TECH200544  |  Created: 2012-12-05  |  Updated: 2012-12-05  |  Article URL http://www.symantec.com/docs/TECH200544
Article Type
Technical Solution


Issue



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 data classes represented were as follows:

493acd3e-e0bc-48be-9364-4e56fd021290    { NS Client Config Request }
457b321d-26eb-449d-996c-5aff16a391ec  { NS Item Management }
fcf38687-fad1-48af-97dc-914aa7c41237 { NS Filter Update Duration }
cff75f1d-016a-4ce7-a22c-5c28ed69de0c { NS Event History }
b1c93ea6-bdbf-4c73-aa18-b8556d92aee5 { NS Report Run }
db3ea90a-f2f7-4763-90fa-fe8705bf2f31 { NS Scheduled Event }
dbf20337-6b6c-4289-80c6-5c78e6d7fbbf { NS Resource Target Update }

 


Environment



SMP 7.0 SP4 R11 (but could happen to any platform version)


Cause



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.

 


Solution




1. Edit CoreSettings.config which should be found in one of the following locations:

SMP 7.0x  " .\Program Files\Altiris\Notification Server\Config "
SMP 7.1x  " C:\ProgramData\Symantec\SMP\Settings "

2. Insert the following element anywhere withing the <customSettings> section. 

<customSetting key="NSResourceGuid" type="local" value="{7A53E708-1AD2-4245-AF74-C59795573011}" />

Note:  Replace the GUID 7A53E708-1AD2-4245-AF74-C59795573011 with the GUID of the local NS.  It can be identified within the following registry value on the NS.

HKLM\Software\Altiris\Altiris Agent\  @MachineGuid

3. Restart the Altiris Service.
 




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


Terms of use for this information are found in Legal Notices