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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 21

#2
dserp Profile Picture

dserp 4

#2
dekion Profile Picture

dekion 4

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans