Error: "The number of users that simultaneously access SDK cannot exceed the xx user(s) for this license"

Overview

While attempting to work in Transaction Manager (integrated with Everest) or external order processing systems (e.g. EDI Order Processing, TrueCommerce, or eCommerce websites) customers have reported that certain core functions are failing and throwing the following error:

"The number of users that simultaneously access SDK cannot exceed the xx user(s) for this license xxx"

The xx will generally be the number of users the customer has as part of their license.

When this happens Everest will stop sending orders to the external system for processing.

Solution

When the SDK is used by an external application, it logs in as if it were an Everest user and leaves the session in the system/database. If the external application is not logged out, then these sessions can add up and eventually exceed the number of licensed users, causing the error. 

To resolve this, open SQL Server Management Studio on the Everest database server and execute the following steps:

Note: Before making any database changes, it is advisable to take a backup. 

1. Open SQL Server Management Studio on the server system. 

2. In the left Object Explorer window, use the navigation tree to find the EVEREST_SYSTEM database
Everest_SPM.png

3. Right-click on the database name and select New Query.

4. Execute the following query:

SELECT * FROM EVEREST_SPM WHERE UID IN (SELECT UID FROM EVEREST_SPM WHERE ATTRIBUTE = 23 AND VALUE = 7)

5. Once the results are shown, execute the following query:

DELETE FROM EVEREST_SPM WHERE UID IN (SELECT UID FROM EVEREST_SPM WHERE ATTRIBUTE = 23 AND VALUE = 7)

Testing 

Validate the fix by attempting to work within Transaction Manager. The processes throwing the error before should work as intended now.

Back to top

Comments

0 comments

Please sign in to leave a comment.