ListManager | ERROR: Could not clear Activation Code.

Question/Problem Description

We are doing a server refresh and moving lyris license from existing server to new server, license is not clearing from SQL Database, lm.exe clearactivation  not working

F:\LM\tclweb\scripts>f:\lm\lm.exe clearactivation
Attempting to connect to server: xxxxx..............
....................................
20191211 105834 Obtained 50 connections to the database.
20191211 105834 Using 'MSSQL' server on 'xxxxx' and
database 'ListManager'
20191211 105834 ERROR: Could not clear Activation Code.
Program exited suddenly

Environment

Lyris LM-ListManager--

Resolution

To Remedy this, you need to navigate to the web UI and clear the activation code manually.

1. To identify the node name, navigate to Utilities : Administration : Server : Database : View and Edit Data : View Any Table : LyrConfigNodeSettings.
2. Once the node name in question is identified, navigate to Utilities : Administration : Server : Database : View and Edit Data : Run Your Own SQL Query, then run this command UPDATE LyrConfigNodeSettings SET Activation='' WHERE NodeName='NODE_NAME'

P.S. Make sure to replace "NODE_NAME" with the node name you want to clear.