Follow

Too many LIMS sessions open. Please contact your LimsPlus System Administrator

Title:

 Too many LIMS sessions open. Please contact your LimsPlus System Administrator

 

Affected Users:

LimsPlus users

 

Fielded Statements:

 

User receives "Too Many LimsPlus Sessions Open" error on attempted Logon.

Customer has Max Sessions set to 1 per user, and had open sessions for the users that were attempting to log in due to bad exits.

When a failed login occurs, a NULL value will be listed in the logofftime field in the auditsessions table for the given user.  When this occurs, the system still believes a user has an active session open.

 

Resolution:

 
1.  Increase the maximum active sessions open simultaneously.  This option can be done by going to System Administration>>System Defaults>>Session Settings.

Allow a maximum of 10 active sessions open simultaneously.  If the maximum is increased, it would allow for additional sessions for users in an event there are failed logins accounting for active sessions.  This would be a quick workaround that would not involve executing an SQL statement.


2.  Decrease the Auto-Logoff Timeout. This setting can be located in the System Defaults within System Administration.

Suggested Auto-Logoff Timeout settings of 480 minutes (8hours).  Using this method would be the first choice to use.  If there were a limited amount of users in the system, it may be more advantageous to use a higher time.

Please note: The time allotted would impact all users instead of certain individuals that may be logged into the system more often.

3.  Run a targeted SQL statement on the auditsessions table in the current LimsPlus database.

This statement should only be used by those familiar with SQL and who have access to make such adjustments.

To view the records for a specific user in the auditsessions table, the following statement can be exectued:

SELECT limslogin, logintime, logofftime
FROM dbo.AuditSessions
WHERE limslogin = 'insert lims login here'

Database administrators can insert a timestamp in the logofftime field for records associated with a limslogin containing a NULL
   
The following statement can be run to insert the current database clock time into the logofftime field for a specific user in the auditsessions table
   
UPDATE dbo.AuditSessions
SET logofftime = GETDATE()
FROM dbo.AuditSessions
WHERE limslogin = 'insert lims login here'
AND logofftime IS NULL

  

JTKB276

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk