Deployment Health shows Check subscriptions with too old last delivery.

"There are subscriptions with an old last-delivery attempt. The oldest subscription was last delivered on 8/30/2023 3:33:54 PM. Check the Subscriptions table and make sure all subscriptions are valid. Check the EndpointAddress column and make sure there are no URLs for computers that are no longer valid."

How do I resolve this issue...

Parents
  • I was able to resolve this issue.

    In SQL Server Management Studio, I ran the following query:

    SELECT TOP (1000) [Id]
       ,[EndpointAddress]
       ,[Query]
       ,[LastSuccessfulDelivery]
       ,[FailedDeliveryAttempts]
       ,[Description]
       ,[AuthorizationToken]
       ,[DataFormat]
       ,[CredentialType]
       ,[Binding]
       ,[UserSubscriptionId]
       ,[SwisInstance]
       ,[Version]
       ,[TTL]
       ,[ReliableDelivery]
    FROM [SolarWindsOrion].[dbo].[Subscriptions]
    WHERE [LastSuccessfulDelivery] < '2024-08-01'
    ORDER BY [LastSuccessfulDelivery] DESC

    Then removed rows with old subscriptions:

    DELETE From [SolarWindsOrion].[dbo].[Subscriptions]
    WHERE [LastSuccessfulDelivery] < '2024-08-01'

    This cleared the warning in Deployment Health.

Reply
  • I was able to resolve this issue.

    In SQL Server Management Studio, I ran the following query:

    SELECT TOP (1000) [Id]
       ,[EndpointAddress]
       ,[Query]
       ,[LastSuccessfulDelivery]
       ,[FailedDeliveryAttempts]
       ,[Description]
       ,[AuthorizationToken]
       ,[DataFormat]
       ,[CredentialType]
       ,[Binding]
       ,[UserSubscriptionId]
       ,[SwisInstance]
       ,[Version]
       ,[TTL]
       ,[ReliableDelivery]
    FROM [SolarWindsOrion].[dbo].[Subscriptions]
    WHERE [LastSuccessfulDelivery] < '2024-08-01'
    ORDER BY [LastSuccessfulDelivery] DESC

    Then removed rows with old subscriptions:

    DELETE From [SolarWindsOrion].[dbo].[Subscriptions]
    WHERE [LastSuccessfulDelivery] < '2024-08-01'

    This cleared the warning in Deployment Health.

Children
No Data