RSS

How to kill a blocking session

10 Apr

Problem:
A user can’t log into AX. After looking at online users (System Administrator > Users > Online Users), you will see a user with status “Ending – Blocked”. This is because AX locks the user session when there was a problem in processing the transaction

Steps :
1> On the User Online screen we can see which userID and which session has status is Ending –Block

SNAGHTML4a02d6

2> Go to the SQL server, look into SYSCLIENTSESSIONS table to see all user sessions.

image

SQL –
SELECT        TOP (200) SESSIONID, SERVERID, VERSION, LOGINDATETIME, LOGINDATETIMETZID, STATUS, USERID, SID, USERLANGUAGE, HELPLANGUAGE,
CLIENTTYPE, SESSIONTYPE, CLIENTCOMPUTER, DATAPARTITION, RECVERSION, RECID
FROM            SYSCLIENTSESSIONS
WHERE        (USERID = ‘Admin’)

3> Delete exactly the line with USERID and SESSIONID of that user

Advertisements
 
Leave a comment

Posted by on April 10, 2014 in Development

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: