Nav 3.70 Session Killer

tthyagu

Hi,
One of our client is working in Nav 3.70 with SQL Server 2005
Since Session Killer functionality cannot be implemented in 3.70, through SQL Server the functionality is implemented by getting some code from the net. This is working if the idle time is set to 2 minutes. If the idle time is set to 10 minutes, this program is not working. What could be the solution?

Regards

ara3n

3.7 is not supported on sql 2005. Do an exe upgrade and write a new codeunit that loops through the session table and filters on idle time and database and deletes the records. You can schedule it on job scheduler.

tthyagu

Hi,

Thanks for the reply.

The database is in SQL Server 2000 not 2005.

There is an SQL procedure created for this purpose. This procedure works fine for 2 minutes. But for 10 minutes, the idle sessions are not closed.

The program uses the value from the filed 'last_batch' from the sysprocesses table for calculating idle time.

Regards

kine

It could be implemented even in 3.70 without problems. You need only to create own view with the Idle Time column (just use the same view definition like in NAV 4 and newer) and use LinkedObject property to connect it into NAV as new NAV table. There is only one cons - you cannot use NAV backup/restore because this link from NAV table object to SQL view and you need to use SQL backup/restore...