Showing posts with label Expired sessions are not being deleted from the ASP.NET Session State database. Show all posts
Showing posts with label Expired sessions are not being deleted from the ASP.NET Session State database. Show all posts

02 August, 2013

Expired sessions are not being deleted, Health Analyzer Error in SharePoint 2010

Today we are going to discuss one of the errors that we have noticed in SharePoint Health Analyzer. as per that exception, here is the reflected information.

Exact Exception: Expired sessions are not being deleted from the ASP.NET Session State database.

Mentioned explanation: If expired sessions are not deleted, the server that hosts the ASP.NET Session State database may run out of disk space and the SharePoint farm may cease to function.

Remedy reflected: Connect to the server that hosts the ASP.NET Session State database, start the SQL Server Agent service, and verify that a DeleteExpiredSessions job is registered for the database. If you are using SQL Server Express, the SQL Server Agent service is not available. For more information about this rule, http://technet.microsoft.com/library/ff805085.aspx

Troubleshooting done:

Checked the timer job status named ‘State Service Delete Expired Sessions’
How we have checked this:
-Open SharePoint 2010 central administration
-Monitoring
-Timer Jobs
-Review Job definitions
-Check the job ‘State Service Delete Expired Sessions’
-By default it runs on hourly basis, so we have executed ‘Run now’ but that didn’t result any output.

Checked the stored procedure named ‘DeleteExpiredSessions’ is exist or not.
How we have checked this:
-Login to the SQL SERVER BOX by using farm account
-expand the list of databases
-look out for Session State database
-Expand the same database
-expand programmability
-expand stored procedures and you will find that above mentioned stored procedure name in that list.
-if it’s not listed there then we need to create that stored procedure.

Once you find that stored procedure then simply right click on it and execute it.

After this, simply go to the central administration-health analyser- click on that warning and select ‘reanalyse now’ option. That’s it.

Issue Resolved.

If you have any inputs regarding the above mentioned information then please share so that it would be useful for the whole SharePoint community.

In case of any queries/questions then please let me know, I would be more than happy to help you as well as resolves your issues, Thank you.

Product applies to:
SharePoint Server 2010
SharePoint Foundation 2010