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

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Purge Session Events r...
Microsoft Dynamics NAV (Archived)

Purge Session Events routine in NAV2013R2

(0) ShareShare
ReportReport
Posted on by BorisK 132

In NAV2013 there was this field in Dynamics NAV Server Administration console, called Session Event Table Purge Frequency. It specified what time on which weekday the Session Event Purge should run.

Starting from NAV2013R2 this field is missing. When does the purge run then?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    BorisK Profile Picture
    BorisK 132 on at

    Microsoft just replied to me that apparently yes, the Session Event records are deleted instantly, as soon as they become older than the specified number of months.

    Mystery solved.

    Thank you for taking time to gat back to me, Stefano!

  • BorisK Profile Picture
    BorisK 132 on at

    I understand that the routine deletes records older than the specified number of months (by default 3).

    My question is – how often, and when, does it run?

    Does it run once a day? Or once a month? At what time?

    Or is it permanently on, so any record is deleted the moment it becomes older than 3 months?

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,166 Most Valuable Professional on at

    Ok now it's clear what you mean :)

    In NAV the option "Session Event Table Retain Period" is still available, the other flag NO.  This is an integer value that specifies how many months events in the Session Events table are retained (Default: 3).

    My suggestion is to delete the Session Event table directly because in this way you've more control on that.

  • BorisK Profile Picture
    BorisK 132 on at

    Most certainly

    Purge.jpg

    The value

    0 6:00 

    means - the old Session Event records will be deleted on Sunday at 06:00 in the morning.

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,166 Most Valuable Professional on at

    Are you sure that it’s standard? I don’t remember this settings in NAV 2013. Can you show a screenshot?

  • BorisK Profile Picture
    BorisK 132 on at

    It's a maintenance routine that runs regularly and deletes old records in Session Event Table (otherwise it grows into millions of records). In NAV2013 you could tell the server exactly when you want to run it (e.g. on Sunday at 03:00 in the morning). From NAV2013R2 onwards you can't. So now I don't know how and when NAV runs it...

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,166 Most Valuable Professional on at

    Sorry then, but I think I’ve not understood what you mean by “purge” then.

  • BorisK Profile Picture
    BorisK 132 on at

    Thank you Stefano, but this is not the question I asked... :-)

  • Stefano Demiliani Profile Picture
    Stefano Demiliani 37,166 Most Valuable Professional on at

    Session timeout is now managed in the Service tier in this way:

    docs.microsoft.com/.../understanding-session-timeouts

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 Giving Solutions is Here!

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 December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans