Duplicate login

Sophie

When one of our clients posts a big journal, that user’s session appear multiple times in the session table. We even saw the same user “logged in” over 70 times. The SQL sessions reflect the session’s table in Navision.

These duplicate session entries have all the same information, the same connection ID, same login time etc.

Their current license only permits 20 users connected simultaneously so when a user is posting a big journal no one else can login.

We weren’t able to reproduce it on our local backup. This happens to more than one user and on different computers. We tried to restart the server but it hasn’t resolved the issue.


They have SQL server 2000 with NAV 3.6.


Does anyone have an idea how to resolve this?

Thanks in Advance.
Sophie

Savatage

Sophie wrote:

We even saw the same user “logged in” over 70 times.

Their current license only permits 20 users connected simultaneously

3.6 is an older version - are you saying this problem is only starting now?

Sophie

We’re not sure exactly when this problem started. But we only noticed it when we changed their license to only permit 20 users.

Savatage

When you re-instate the old license does the problem go away?

Sophie

We can’t give them the old license because the old one is expired.

Savatage

Customer licenses don't expire. :-k
Is this a developers license? Are we getting the full story here?
:?

Sophie

They were on our company license....
We changed them on their own. But we don't think its license issue.

DenSter

Only partner licenses expire. Customer licenses don't expire. If your license expired, you were using a partner license, whether you are aware of that or not.

Are you saying that you work at a partner, and one of your customers is running on your partner license?

Sophie

They were running our partners license. But now they have their own. That is why we can't put it back.

Savatage

Ok even so, The post above says you've seen someone logged in 70 times and they are only allowed 20.
Was the license uploaded properly? I can't see them logging in so many time on their own license unless they are somehow still accessing the old.

Sophie

I’m not sure how the users could be using the old license because it is expired and won’t work.

When I try to log in with multiple accounts to the same database with the same license I get a message saying there are too many users and can’t log in when I reach 20 users.

One thing I find strange is that the user that is showing multiple times has the same connection ID. So that tells me they didn’t log in again, that it was system created somewhere.

We are starting to think it maybe SQL / proc related. I read somewhere that SQL can create multiple connections when it’s using multiple cores of the proc. Their proc only has 8 cores so that doesn’t explain why there are over 70 identical connections. The number of connections is not always the same, sometimes it’s more sometimes it’s less.

Savatage

Perhaps a Sql discussion then
viewforum.php?f=33