Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Purge Session Events routine in NAV2013R2

Posted on by 130

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

  • Verified answer
    BorisK Profile Picture
    BorisK 130 on at
    RE: Purge Session Events routine in NAV2013R2

    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 130 on at
    RE: Purge Session Events routine in NAV2013R2

    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,162 Most Valuable Professional on at
    RE: Purge Session Events routine in NAV2013R2

    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 130 on at
    RE: Purge Session Events routine in NAV2013R2

    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,162 Most Valuable Professional on at
    RE: Purge Session Events routine in NAV2013R2

    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 130 on at
    RE: Purge Session Events routine in NAV2013R2

    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,162 Most Valuable Professional on at
    RE: Purge Session Events routine in NAV2013R2

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

  • BorisK Profile Picture
    BorisK 130 on at
    RE: Purge Session Events routine in NAV2013R2

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

  • Stefano Demiliani Profile Picture
    Stefano Demiliani 37,162 Most Valuable Professional on at
    RE: Purge Session Events routine in NAV2013R2

    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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans