web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Status Ending Blocked ...
Microsoft Dynamics AX (Archived)

Status Ending Blocked on the Online User Screen

(0) ShareShare
ReportReport
Posted on by Surakit Amnartchong... 680

Dear All,

We found the status 'ending bloacked' showed in the online user screen for serveral times. After reading from the help it said as below

' Ending - Blocked - The administrator has clicked End sessions to end the session and the AOS has processed the request, but there is a problem disconnecting the session. '

This cause my user can't logon !!!

In fact we never did as mention above. Anyone experience this before please kindly share

- what is the reason  

- how to end this session ( currently we have to stop and start service of AOS server and impact to the service time )

Thanks You in advance  

 

 

 

 

*This post is locked for comments

I have the same question (0)
  • Surakit Amnartchongcharoon Profile Picture
    Surakit Amnartchong... 680 on at

     

    Hi all,

     

    Can anybody help on this

    thk

     

     

  • Surakit Amnartchongcharoon Profile Picture
    Surakit Amnartchong... 680 on at

    Please help on this

  • Community Member Profile Picture
    Community Member on at

    Please any advise in this ??

  • Luegisdorf Profile Picture
    Luegisdorf 1,930 on at

    Sounds like a SQL session which cannot be cut by AOS. This can f.ex. be caused by deadlocks. Take a look into the windows event logs on the AOS server machine. The AOS will declare the specific SQL session no. which has to terminated manually.

    You can also note the SPID from the "ending" user and than goto SQL administration tool and kill the process with the corresponding number.

    This should solve the blockade.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    This case I think we can do as below:

    On the User Online screen we can see which userID and which session has status is Ending -Block

    Go to the SQL server, look into SQLCLIENTSESSIONS table to see all user sessions.

    Delete exactly the line with USERID and SESSIONID of that user.

    Regards,

    Anh Mai

  • Community Member Profile Picture
    Community Member on at

    Ah , I forgot

    The reason is the Admin was end session of this user on User Online Screen in AX

    Anh Mai

  • Hank Hotchkiss Profile Picture
    Hank Hotchkiss 345 on at

    Mai,

    I have two sessions of an 'ending-blocked' user (same user) in AX2009. I have been looking through many tables and db's in SQL 2008 R2 trying to find the SQLSESSIONS table you mentioned. Can you clarify what the path to this table is?

    Many thanks.

  • Community Member Profile Picture
    Community Member on at

    Dear Hank,

    I never tried deleting this entries through table what i do is killing the process from the SQL Activity monitor . i think this is more trusty than deleting record that may affect the DB consistency

    Regards,

  • Hank Hotchkiss Profile Picture
    Hank Hotchkiss 345 on at

    Thanks for the reply Emad.

    I was hoping to use that method but these two "Ending-Blocked" sessions are not showing up in the SQL Activity Monitor. I tried restarting the SQL and AOT services last night hoping that would help but it didn't change anything.

    One thing I did notice this morning is that, eventhough we have 17 active online AX users, there are only two users from AX showing up in the SQL Activity Monitor: RetailStoreConnect and the AOS service user. All of our AX Clients access the program through a terminal server. Is that why they don't show up in the SQL Activity Monitor processes? Maybe I don't have the Activity Monitor configured correctly...

  • Community Member Profile Picture
    Community Member on at

    urw

    this is a new case i always found the sessions in sql and force it to be closed .. try to restart the two sessions "restarting the clients" windows restarting

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans