How to solve ScriptCase login issue

ScriptCase login issue

If you get the following ScriptCase login error, no one is able to login to the ScriptCase system even Admin user is NOT able to login in the case.

In order to solve the issue, this article explains how to solve the issue.
The limit of simultaneous connections of this license has been reached.
The issue would be caused by accessing ScriptCase from multiple servers and multiple users.

For example, you have 2 ScriptCase user licenses and two users accessed ScriptCase, but if each user uses two computers, total 4 licenses would be required.

In this case, you may get the "The limit of simultaneous connections of this license has been reached." error. As a result of that, you are no longer able to access ScriptCase.

When I got the error, I restarted Apache (httpd), but the issue kept happening, so I restarted my ScriptCase server, but the issue was not solved.

Therefore, somehow we need to delete logged in user's session information.




Solution

Since I found a sqlite3 database in ScriptCase software directory, I looked into the database data and found some logged in session information.

So, we just need to do the following commands.
$ ssh scriptcase-server-name
$ sudo su -
# cd /opt/NetMake/v9/wwwroot/scriptcase/devel/conf/scriptcase/
# sqlite3 nm_scriptcase.db
sqlite> .tables
sqlite> select * from sc_tbati;
sqlite> delete from sc_tbati;
sqlite> .exit

After I deleted all the logged in user's session records from the sqlite3 database, I am able to login to ScriptCase application.

Once you deleted the database data, you don't need to restart Apache. Hope this helps.