On Altiris console, Settings, Notification Server, IT Analytics Settings.
Connections > Symantec Endpoint Protection
Upon attempting to edit the configuration, the error below is thrown
"9/24/2015 5:19:46 PM","Error Synchronizing Security Roles.
Object reference not set to an instance of an object.
[System.NullReferenceException @ Altiris.ITAnalytics]
at Altiris.ITAnalytics.DisposableASDB.ExecXmla(String xmla)
at Altiris.ITAnalytics.ASDatabase.ExecXmla(String xmla)
at Altiris.ITAnalytics.ASDatabase.AddRoleMemberByName(String roleID, String roleName, String name, Guid parentPid)
at Altiris.ITAnalytics.ASDatabase.SynchronizeRole(Guid SyncRoleGuid, Guid parentPid)
at Altiris.ITAnalytics.Tasks.ITAnalyticsSyncSecurityRolesTask.ProcessTasks()
Exception logged from:
at Altiris.Diagnostics.Logging.EventLog.ReportException(Int32 severity, String strMessage, String category, Exception exception, String footer)
at Altiris.NS.Logging.EventLog.ReportException(String strMessage, Exception exception)
at Altiris.ITAnalytics.Tasks.ITAnalyticsSyncSecurityRolesTask.ProcessTasks()
at Altiris.ITAnalytics.Tasks.ITAnalyticsProcessingTask.ProcessTasks()
at Altiris.ITAnalytics.Tasks.ITAnalyticsProcessingTask.OnExecuteTask(Hashtable taskArgs)
at Altiris.NS.StandardItems.Tasks.BaseItemTask.ExecuteTask(Hashtable taskArgs, ItemTaskState state)
at Altiris.NS.ItemTaskManagement.ItemTaskThread.LaunchTask()
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
**CEDUrlStart** :http://entced.symantec.com/entt?product=SMP&version=7.6.1383.0&language=en&module=3kcFsqnWUyh3zfpnW3FH+UYteD3XRPw/c+xgfOpKrkuHMNz/X5UsHKZfOvdr4qkDz4dfjHYWBO4DVhdYl7B3YsK78Chvr63h/z7w1uRAQjE=&error=637893410&build=**CEDUrlEnd**
","Altiris.ITAnalytics.Tasks.ITAnalyticsSyncSecurityRolesTask.ProcessTasks","AeXSVC.exe","365","Errors"
It's recommended to contact Symantec technical support for further analysis of the issue prior to performing the steps below.
Remove the current ITA-SEP configuration manually by running the below SQL queries againest Symantec CMDB:
update item set state = '<item></item>' where GUID = 'daca941e-7e52-4bfc-b022-e92c1ea85d5a'
--Make note of connected server name
exec sp_helpserver
exec sp_linkedservers
-- Run the below queries using the name retrieved from the 2 queries above (replacing the below placeholders).
exec sp_droplinkedsrvlogin @rmtsrvname = 'ITANALYTICS_SEP_SYMANTEC_CMDB_1_SQLsrverName_SEM5',@locallogin = null
exec sp_dropserver @server = 'ITANALYTICS_SEP_SYMANTEC_CMDB_1_SQLsrverName_SEM5'