mibuso.com

How to control/kill sessions?

http://www.mibuso.com/howtoinfo.asp?FileID=18

Discuss this How To here.

I have some trouble using this.

I've installed de NAS and the code, forms and tables. But it remains unusable:

The definition of the field User ID was changed after the object was saved

Old type: Text
New type: Code

Any idea?


Best regards(I've searched over and no answer at all)

Did you try to recompile the objects?

I've tried to recompile.

But no luck...Usding Native NAV(NOT SQL) i think the method FINDFIRST is not possible.



I'm using nav 4.0 sp1.

Any idea ?

I imported the objects on a 4.0SP1 native.
First I had the same error as you. Then I recompiled and I got no more errors.

2 things come in mind to test:
1) maybe the codeunit was in memory and after compiling it remained there. If you re-open the client it should take the new version of the codeunit and the problem should be solved.
2) If you have a problem with FINDFIRST, it means you have a client before 4.0SP1. FINDFIRST was introduced with 4.00SP1.

You're right.

We are planning to change the NAV partner, ours is %&%&**

I'm learning to control, program and debug my system.

I have a SUPER rol but i can't run some codeunits design some forms...
Any idea? its the license? I cant design even having all access to tables, forms codeunits and so on?

Ok right i think our license doesnt have design granule
So i can work on a local copy of the db.

I hace setup up all the fobs on the dev nav and exported and imported on the porduction db.

Tha NAS starts but the user need some perms that i cannot find.

I have created arole sessionkiller with acces to te session table and all the objects in the fobs(tables, forms, and codeunit)

But i still missing something

If you run the codeunit from your client, does it work then?
If it works, than probably you still need to put the call to this codeunit in codeunit 1.

Does this solution works for Native Navision DB also? I tried to do this ...everything works ..but session is not killed.

If this does not apply to native databases..do we have any other solution.


Thanks in advance

Vijay

yes you can kill the session also in the native database (>= 4.00)
For test: Open Database -> File -> Database -> Information -> Sessions -> active Sessions -> DrillDown -> SessionList -> F4 to kill a session

Thanks for the reply...but my query is regarding the auto session killing through code which we are talking in the posts above.

Will this code work with Native DB as well?


Thanks
Vijay

Yes.

This is a common error. It's caused because the type of the "User ID" on the virtual table is different between Native and SQL. You have to SAVE the object (normally a form) again, not just recompile from the object designer.

Second minor point, for the F4 kill to work on SQL the user must be a member of the SQL system administrator role with delete permission on the Navision session table. Just being a member of the Navision SUPER group is not enough.

Great job ! Unfortunatelly I'm unable to launch CU because of a error "you can use FINDSET only if keys are acending ordered" (table session).

IF PtmpSession.SETCURRENTKEY("Idle Time") THEN BEGIN
// I am on SQL. SQL has a key on "Idle Time".
PtmpSession.ASCENDING(FALSE);
IF PtmpSession.FINDSET THEN <---- ERROR here

I'm using Nav 4.03 with SQL Server 2005. I'm able to sort on idle time in session form so i think the key is present. So ?

Tco

The findset command was a part of SP1. And is not designed for desc. Order (PtmpSession.ASCENDING(FALSE);)
So, change from findset to find('-').

regards