Overview
After upgrading the OS of nodes in a clustered ListManager setup, you may encounter this problem that mailing to send is getting stuck in the LM DB table lyrActiveRecips. There is nothing in the Transaction Log column and NextAttempt column is stuck at the time the original mailing was sent and does not update. SendTry column is also stuck at 0 and does not update
Prerequisites
- Server Administrator Access
Solution
The lyrActiveRecips table holds recipient rows for mail sending. Each recipient has a row in this
table while mail is being delivered to them. Once no more attempts will be made to deliver this
recipient the mail message, the row is moved from this table in lyrCompletedRecips.
The following Lyris help guide link has detailed information about the LM DB table lyrActiveRecips:
Follow the instructions below to diagnose and solve this issue:
-
-
Stop and start LM service.
-
Restart the nodes.
-
Confirm network configuration and connectivity. Check if the IP addresses are correct in mailstream and node settings.
-
Check debug log. Refer to the article; ListManager - Enable Additional Error Logging to enable additional error logging.
-
Check server log. Refer to the following help guide link to enable and log alerts in the server log: http://lunar.lyris.com/help/lm_help/12.0/Content/server_settings__alerts_settings.html
If the debug/error logs indicate licenses in 'disabled mode' for nodes, recycle activation on those nodes. To clear/get activation for each node:
-
Select the node first on the top right corner in the LM server UI.
-
Then go to the license page and clear/get activation there for each affected node.
-
-
Testing
Restart LM servers in the cluster and create mailing to be sent. The servers should start without the error "Running in 'disabled' mode because of license code problems" and the mailing should be sent.
Related Articles