Error: Invalid column name 'xxx' in the QLM Management Console

When performing any operation in the QLM Management Console that communicates with the QLM License Server, such as activating a license or deactivating a license, an error saying "Invalid column name" typically means that there is a discrepency between the version of the QLM Management Console and the version of the QLM License Server.

To resolve this issue, follow the recommendations below.

Version mismatch

To identify whether there is a version mismatch, you need to first determine the version of the QLM Management Console and the version of the QLM License Server.

To determine the version of the QLM Management Console:

• Launch the QLM Management Console
• Go to the Get Started tab
• Locate the "QLM Version Information" tile and note your version

To determine the version of the QLM License Server:

• Launch the QLM Management Console
• Go to the Manage Keys tab
• Click Sites and then select your License Server
• Click the Test button of the Primary Site
• The first result returned by the test includes the version of the QLM License Server
• Locate the "QLM Version Information" tile and note your version

If the 2 versions are identical, proceed to the next step. If they are not, upgrade your system so that both versions are identical.

Out of date DB Schema 

Once you have ensured that the QLM Management Console and the QLM License Server are running the same version, you must verify that the QLM License Server Database Schema is up-to-date. A database schema update is typically required whenever you ugprade your QLM License Server to a newer version.

To upgrade the DB schema of the License Server:

• Launch the QLM Management Console
• Go to the Manage Keys tab
• Click Sites and then select your License Server
• Click the "Upgrade DB Schema " button
• Verify that all the results returned when upgrading the schema are successful.