IT-Analytics SEP configuration page settings fails on edit

Products

• IT Analytics

Issue/Introduction

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"

Resolution

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'