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

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

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

(0) ShareShare
ReportReport
Posted on by

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)
  • Suggested answer
    Community Member Profile Picture
    on at
    RE: Are "inactive" user sessions in ax2009 for web users something to worry about?

    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.

  • Community Member Profile Picture
    on at
    RE: Are "inactive" user sessions in ax2009 for web users something to worry about?

    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

  • Community Member Profile Picture
    on at
    RE: Are "inactive" user sessions in ax2009 for web users something to worry about?

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

  • Community Member Profile Picture
    on at
    RE: Are "inactive" user sessions in ax2009 for web users something to worry about?

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

  • Community Member Profile Picture
    on at
    RE: Are "inactive" user sessions in ax2009 for web users something to worry about?

    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.

  • Suggested answer
    Rachit Profile Picture
    4,015 User Group Leader on at
    RE: Are "inactive" user sessions in ax2009 for web users something to worry about?

    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
    on at
    RE: Are "inactive" user sessions in ax2009 for web users something to worry about?

    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? :)

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…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Syed Haris Shah Profile Picture

Syed Haris Shah 9

#2
Mea_ Profile Picture

Mea_ 4

#3
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans