Kill session in NAV 2013

_mon__mon_ Member Posts: 42
edited 2014-04-17 in NAV Three Tier
In previous versiones (<NAV 2013) in file, database, information, sessions, current sessiones, you could kill sessions.
In NAV 2013, in sessions you can see the NAV sessions.
But, how can you kill any session in NAV 2013?

Answers

  • ara3nara3n Member Posts: 9,256
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • _mon__mon_ Member Posts: 42
    Thank you!
    :D
  • ara3nara3n Member Posts: 9,256
    You are welcome.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Rob_HansenRob_Hansen Member Posts: 296
    Is there no idle time tracking for sessions in NAV 2013?
  • ara3nara3n Member Posts: 9,256
    I didn't see anything in virtual tables. But there are two settings in Customsettings.config


    <!--
    Sets the number of months sessions older will be purged from teh session event table.
    -->
    <add key="SessionEventTableRetainPeriod" value="3" />
    <!--
    Sets the weekly frequency the session event table will be purged. The default value being Sunday 6:00.
    This means that an attempt will be made to purge all not active sessions between 6:00 and the 6:00 + SessionEventTablePurgeLookupPeriod.
    -->
    <add key="SessionEventTablePurgeFrequency" value="0 6:00" />
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Ravi_ThakkarRavi_Thakkar Member Posts: 392
    Hello Everybody,

    How can we identify the session idle time for Navision 2013?

    Also, please suggest how to kill the idle session which is more idle than the user defined time?
    Ravi_Thakkar
    Ahmedabad, Gujarat, India
    E Mail : ravi.thakkar@hotmail.com
  • RachelSoonRachelSoon Member Posts: 202
    Dear All,
    Is there any particular reason that NAV2013 does not enable kill session at the first?

    base on the link given by ara3n, the code to add to NAV2013 to enable to kill session is straight forward.

    So, just wondering if there is any reasons that it's not enable. Could it be there is not indication of the idle time? or NAV2013 can handle by itself.

    Please advise.

    Thank you.

    regards,
  • Marije_BrummelMarije_Brummel Member, Moderators Design Patterns Posts: 4,262
    NAV2013 uses connection pooling on SQL Server. From SQL's perspective you don't have a clue who is on what connection. This makes doing anything from SQL Servers perspective very difficult, if not impossible.
  • RachelSoonRachelSoon Member Posts: 202
    hi Mark,
    Thanks for the useful input.
  • MBrodie1979MBrodie1979 Member Posts: 21
    This is so AWESOME! =D>
  • spukurspukur Member Posts: 1
    Very useful!

    Thanks
Sign In or Register to comment.