8 Replies Latest reply on Jun 2, 2016 8:07 AM by ecklerwr1

    Is the SolarWinds Orion Platform 2015.1.3 Hotfix 1 for errors like this...

    ecklerwr1

      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...).