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?
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
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.
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.
Answers
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
http://www.epimatic.com
<!--
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" />
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
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?
Ahmedabad, Gujarat, India
E Mail : ravi.thakkar@hotmail.com
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,
Thanks for the useful input.
Thanks