Do these type of errors in the Alerting.Service.V2.log count as There is a Long Running Query Warning issue for OrionMap. which the hotfix says it will fix??? What is OrionMap exactly??? I'm having problems with alerts not going out when they should and are delayed. Orion sees the events happen but my alerts aren't triggering the way they should right away and sometimes the action happens days later. Anyone else seen anything like this before?
Has anyone needed to install this hotfix?
2016-05-25 21:25:31,431 [31] WARN SolarWinds.Orion.Core.Alerting.Service.ConditionsStateEvaluator - Long Running Condition - Condition: {(AlertId: 256, AlertLastEdit: 4/13/2016 6:00:27 PM, ConditionIndex: 0, Type: Trigger:[NTA: CBQoS Class Map: Core.Dynamic: AlertConditionDynamic: scope=EMPTY: (
([Orion.Netflow.CBQoSStatisticsDescription|StatisticsName|StatisticsDescription] = 'Drops')
AND ([Orion.Netflow.CBQoSClassMap|Name|Policy.ClassMap] = 'class-default')
AND ([Orion.Netflow.CBQoSPolicyMap|Name|Policy.PolicyMap] CONTAINS '50Mbit')
AND ([Orion.Netflow.CBQoSStatistics|Bytes|Statistics ('Sum')] > '327680')
): conj=None: count>=: susTime=]@5/26/2016 4:26:31 AM)} was evaluated in 30125.7712 ms.
2016-05-25 21:25:33,432 [17] WARN SolarWinds.InformationService.Contract2.InfoServiceProxy - Support! -- LONG RUNNING QUERY: 30065.5641 ms: SELECT DISTINCT E0.[Uri], E0.[DisplayName]
FROM Orion.Netflow.CBQoSPolicyMetric AS E0
WHERE ( ( E0.[StatisticsDescription].[StatisticsName] = @p0 ) AND ( E0.[Policy].[ClassMap].[Name] = @p1 ) AND ( E0.[Policy].[PolicyMap].[Name] LIKE @p2 ) AND ( (SELECT SUM(AGG.[Statistics].[Bytes]) as agr FROM Orion.Netflow.CBQoSPolicyMetric AGG WHERE AGG.[Uri] = E0.[Uri] AND AGG.[Statistics].[ObservationTimeStamp] > AddSecond(-900, GetUtcDate())) > @p3 ) ) RETURN XML RAW
2016-05-25 21:25:33,447 [17] ERROR SolarWinds.Orion.Core.Alerting.Plugins.Conditions.Swql.ConditionEvaluatorSwql - Condition evaluation failed for query = (SELECT DISTINCT E0.[Uri], E0.[DisplayName]
FROM Orion.Netflow.CBQoSPolicyMetric AS E0
WHERE ( ( E0.[StatisticsDescription].[StatisticsName] = @p0 ) AND ( E0.[Policy].[ClassMap].[Name] = @p1 ) AND ( E0.[Policy].[PolicyMap].[Name] LIKE @p2 ) AND ( (SELECT SUM(AGG.[Statistics].[Bytes]) as agr FROM Orion.Netflow.CBQoSPolicyMetric AGG WHERE AGG.[Uri] = E0.[Uri] AND AGG.[Statistics].[ObservationTimeStamp] > AddSecond(-900, GetUtcDate())) > @p3 ) )), condition = (AlertConditionDynamic: scope=EMPTY: (
([Orion.Netflow.CBQoSStatisticsDescription|StatisticsName|StatisticsDescription] = 'Drops')
AND ([Orion.Netflow.CBQoSClassMap|Name|Policy.ClassMap] = 'class-default')
AND ([Orion.Netflow.CBQoSPolicyMap|Name|Policy.PolicyMap] CONTAINS '20Mbit')
AND ([Orion.Netflow.CBQoSStatistics|Bytes|Statistics ('Sum')] > '131072')
))
System.ServiceModel.FaultException`1[SolarWinds.InformationService.Contract2.InfoServiceFaultContract]: RunQuery failed, check fault information. (Fault Detail is equal to InfoServiceFaultContract [ System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
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 cm...).
