How to kill a remote session?

Deep

Hi all.

Is there any utility which can kill a remote session over NAV 4.0.
The DB used is native DB

rajpatelbca

if you are talking about session killing then see this link.

http://www.mibuso.com/forum/viewtopic.p ... ssion+kill

Deep

This seems for SQL database.
I need this for a native DB.

Savatage

for native there are 3rd party options too

you could use www.autocloseidle.com or www.expandit.com

kriki

This also works for native : http://www.mibuso.com/howtoinfo.asp?FileID=18

Deep

Thanks a lot friends.

Vineeth.R

hello raj,

if i am using a local database can i kill my session???
since i am trying this example in my laptop and not in a server where lots of people are using my databse i cant test it. can i test this in local databse?? i created the single instance codeunit but where from shoiuld i call this codeunit to run close sessions??
pls advise as i m new to navision i have little knowledge only
thanks in advance

rajpatelbca wrote:

if you are talking about session killing then see this link.

http://www.mibuso.com/forum/viewtopic.p ... ssion+kill

kriki

You can open the same local DB multiple times if you use the same fin.exe.

If you put code in the OnRun-trigger of the singleinstance codeunit to initiate the timer, you can just run the codeunit from the object designer.

vikram7_dabas

Dear Kriki
If I will create the Report (Processonly) by taking DataItem(Session) and give filter to Login type to(Windows) then will it work in SQL DB.

kriki

vikram7_dabas wrote:

Dear Kriki
If I will create the Report (Processonly) by taking DataItem(Session) and give filter to Login type to(Windows) then will it work in SQL DB.

I am not sure I understand what you want to do. :oops:

Vineeth.R

hi kriki,

i tried as u said using 2 fin.exe opened. but when i tried to run my codeunit one error message prompted saying "You cannot close a session when u r not connected to server" ??? what did it mean..how to solve this issue pls advise

thanks Vineeth

kriki wrote:

You can open the same local DB multiple times if you use the same fin.exe.

If you put code in the OnRun-trigger of the singleinstance codeunit to initiate the timer, you can just run the codeunit from the object designer.

kriki

I never saw that error. :shock:
Try to use the debugger to see if you find something more on the command that creates the error.

Vineeth.R wrote:

hi kriki,

i tried as u said using 2 fin.exe opened. but when i tried to run my codeunit one error message prompted saying "You cannot close a session when u r not connected to server" ??? what did it mean..how to solve this issue pls advise

thanks Vineeth

kriki wrote:

You can open the same local DB multiple times if you use the same fin.exe.

If you put code in the OnRun-trigger of the singleinstance codeunit to initiate the timer, you can just run the codeunit from the object designer.

Vineeth.R

Dear Kirki

this is my single instance codeunit coding to kill a session



OnRun()

IF ISCLEAR(Timer) THEN
CREATE(Timer);
Timer.StartTimer(6000);
Code;

Code()

Session.SETRANGE("My Session",FALSE);
Session.SETFILTER("Idle Time",'>100 min');
IF Session.FINDFIRST THEN REPEAT
Session.DELETE;//Debugger stops here saying "you cannot delete a session when u r not connected to server
COMMIT;
UNTIL Session.NEXT = 0;



how to solve it.. i tried it by opening two fin.exe and running this codeunit in one

kriki wrote:

I never saw that error. :shock:
Try to use the debugger to see if you find something more on the command that creates the error.

Vineeth.R wrote:

hi kriki,

i tried as u said using 2 fin.exe opened. but when i tried to run my codeunit one error message prompted saying "You cannot close a session when u r not connected to server" ??? what did it mean..how to solve this issue pls advise

thanks Vineeth

kriki wrote:

You can open the same local DB multiple times if you use the same fin.exe.

If you put code in the OnRun-trigger of the singleinstance codeunit to initiate the timer, you can just run the codeunit from the object designer.

kriki

Try something like this:

Session.RESET;
Session.SETRANGE("My Session",FALSE);
Session.SETFILTER("Idle Time",'>100 min');
IF Session.FINDSET THEN
  REPEAT
    Session2 := Session;
    Session2.FIND('=');
    Session2.DELETE(TRUE);
  UNTIL Session.NEXT = 0;

Savatage

The code master strikes again! \:D/

kriki

Savatage wrote:

The code master strikes again! \:D/

Wait for episode V : The empire ... eh ... codemaster strikes back!