After upgrade to version 12.1, the following warning alarms appear:
"The replication subscription [DBPROD2\DBREP].[Msiclaim] will expire in 6 hours"
What do these alarms indicate?
WORKAROUND:
Default Alarm thresholds are set to 24 hours or less. Adjust alarm thresholds:
1. Select Configure | Alarms option
2. Select the connection name from the Connection drop down list
3. Scroll down to "Replication - Subscription Expiration" alarm
4. Uncheck Factory Setting checkbox
5. Increase the Infomational and Low severity thresholds and hit OK
Spotlight uses sp_replmonitorhelpsubscription store procedure to obtain the expiring subscriptions.
See below MS articles on how to rectify this issue in your replication instance:
https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-replmonitorhelppublication-transact-sql
https://docs.microsoft.com/en-us/sql/relational-databases/replication/subscription-expiration-and-deactivation
https://docs.microsoft.com/en-us/sql/relational-databases/replication/publish/set-the-expiration-period-for-subscriptions
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center