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) / Are "inactive&quo...
Microsoft Dynamics AX (Archived)

Are "inactive" user sessions in ax2009 for web users something to worry about?

(0) ShareShare
ReportReport
Posted on by Community Member

Hey all,

Sorry for the title, but it's pretty close to being the best I could think of for this question...

Today one of the BA's for my office came to me asking "how are you supposed to kill all these inactive sessions for a user?" ... I was confused what she was talking about and went about looking and it appears that if you go into online users and then search based on a user name it shows inactive status users, all of which are web users from our BI/EP server. 

i tried selecting the inactive user sessions and ending them, but it gives the confirmation box and then just closes after say you really want to kill the session off, but it doesn't remove it at all. Even more interesting to me is that some of these date back to 2011 and i know for a fact all of the servers have been rebooted since that point in time.

Anyways, I tried to google/bing this and there is just about no real information on inactive status web users out there and how to deal with them. So I'm hoping that someone here can help me out with info or what to do.

Thanks!

Jeff

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Bumping this post back up, I'd love to know if anyone has a way to gracefully remove these... I've tried to load them via an xSession, or Session, and the ID, and then terminate them via a job, but that didn't work at all.

    So please, thoughts? :)

  • Suggested answer
    Rachit Profile Picture
    Rachit 4,015 User Group Leader on at

    Hi Jeff,

    Want to share similar experience on AX2012 and we deleted the records for the users we want to terminate the session from SysClientSessions table directly from SQL Server management studio and it worked for us.

    Hope this helps.

    Thanks,

    Rachit Garg

  • Community Member Profile Picture
    Community Member on at

    The inactive web sessions are not actually something to worry about if you restart AOS once in while say after 3 months or so, they dont count in to your no of active session.  Generally, the purpose of these inactive sessions is pick an inactive session for reuse if you login in EP.

    If you dont want them to clogging up, you can actually set those inactive session to recycle itself after a certain time interval from IIS setting.  Go the application pool used by EP site, under advanced settings, idle session timeout minutes, you can put something say 60 mins.

    Hope it helps.

  • Community Member Profile Picture
    Community Member on at

    I'll give that a try, currently we have 8900+ inactive sessions... :\

  • Community Member Profile Picture
    Community Member on at

    Doesn't appear to clean them up even with that. Any more suggestions? :\

  • Community Member Profile Picture
    Community Member on at

    Has anyone found a solution to this? I discovered this just today where I have Inactive sessions from 2 years ago. Some users are no longer in the company, rest of them are still here.

    I have tried deleting them via SysClientSessions but I get this error:

    "Cannot delete a record in Current client sessions (SysClientSessions).

    The corresponding AOS validation failed."

    Thanks

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    This works for me:

    1. Stop AOS service.

    2. Open SQL Server Management Studio and run the following query:

    delete from SysClientSessions where status in(0,2,3)

    3. Restart AOS.

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