Tasks associated with Monitor Policies are triggering very late.

Article:TECH216550  |  Created: 2014-04-09  |  Updated: 2014-04-09  |  Article URL http://www.symantec.com/docs/TECH216550
Article Type
Technical Solution



Subject

Issue



After upgrading to 7.5 tasks associated with Monitor Policies are triggering anywhere from 30 minutes to hours after the alert has appeared in the event console.


Error



<event date="01/22/2014 12:40:38.4501661 -06:00" severity="1" hostName="ServerName" source="EventEngine.EngineService.LogException" module="EventEngine.exe" process="EventEngine" pid="5808" thread="41" tickCount="1711326272"><![CDATA[Unable to launch task 06c480df-95de-4a5a-be4d-cf05e7f9abb2 for task rule 434d555c-0941-4a94-9cb6-e7e275bd892e
System.Data.SqlClient.SqlException (.Net SqlClient Data Provider): The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ec_alert_variable". The conflict occurred in database "Symantec_CMDB", table "dbo.ec_alert", column 'guid'.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Altiris.EventConsole.DataAccessLayer.Alerts.InsertVariable(Guid alertGuid, AlertVariable variable)
at Altiris.EventConsole.BusinessLogic.Alerts.SaveAlertVariable(Guid alertGuid, AlertVariable variable)
at EventEngine.EngineService.LaunchTasks()

SQL Exception details: code=547, line=12, procedure=_sp_ec_insert_variable

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(Int32 severity, String strMessage, String category, Exception exception)
at EventEngine.EngineService.LogException(String message, Exception e)
at EventEngine.EngineService.LaunchTasks()
at EventEngine.EngineService.BulkInsertAlerts(Object state)
at System.Threading.ExecutionContext.runTryCode(Object userData)
at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading._TimerCallback.PerformTimerCallback(Object state)

**CEDUrlStart** :http://entced.symantec.com/entt?product=SMP&version=7.5.1670.0&language=en&module=xkfv5o6dWRayzmNziF/nGft5jopBDUwOr/JHiSOAJC47CgL9iUYnKjo02ML++Lhk&error=-681642707&build=**CEDUrlEnd**
]]></event>
 


Environment



Windows Server 2008 R2
Monitor Solution 7.5
ITMS 7.5


Cause



The cause of this issue is unknown at this time.


Solution



The event console should have all alerts removed. To clear the event console please follow the instructions located at the following link: http://www.symantec.com/business/support/index?page=content&id=HOWTO72099.  After clearing the event console the RMS agent's should be uninstalled and reinstalled on the Notification Server and any Site Servers.  To uninstall and reinstall the RMS please see the following documentation:  http://www.symantec.com/docs/HOWTO95492.




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


Terms of use for this information are found in Legal Notices