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
