ApplicationXtender - Web Access - Acquire License Failed

Owned by Chad Nissen
Dec 30, 2020
1 min read

ApplicationXtender - Error: 210 : Acquire License Failed. Details: System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'ae_lic_PK'. Cannot insert duplicate key in object 'dbo.ae_lic'.


Applies to

  • ApplicationXtender Desktop 16.3, 8.2

  • ApplicationXtender License Server 16.3

  • ApplicationXtender Web Access.NET 16.3, 8.1

 

Summary

In ApplicationXtender, when users try to access ApplicationXtender WebAccess they get a popup saying unable to acquire the license. Try again." This may occur even if licenses are available.

Additional Error:
Failed to acquire license:

Violation of PRIMARY KEY constraint 'ae_lic_PK'. Cannot insert duplicate key in object 'dbo.ae_lic'.

 

Resolution

Delete the table index "ae_lic_PK" in the ae_lic table.*

 

Cause

The column 'licgrp' should be in the PK indexes. But the column is allowed to be null and can't be added to the PK indexes.

 

Additional Information

*Warning: Only experienced Database Administrators should make modifications to the database. The result of an inexperienced user modifying the database could be disastrous. OpenText Software recommends backing up the production database before making modifications.

CASO Knowledge Base