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 workingF:\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.- To identify the node name, navigate to Utilities : Administration : Server : Database : View and Edit Data : View Any Table : LyrConfigNodeSettings.
- 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'