Session Killer Problem

vikram7_dabas

Dear Concern
I m using Navision2009SP1 in Windows server2088 and SQL Server 2008.I have created 1 report of session killer whose Ideal time is more than 1 minute.Whenever any session is killed then it is showing me following error:

ODBC Error Occured
[Microsoft][ODBC SQL Server Driver].Optional feature not implemented State ID HSC001

Please provide me solution of not getting this error.

kriki

Can you give some more info?

E.g. how do you kill sessions?

vikram7_dabas

I have created 1 form and code written on its OnTimer Trigger and set time Interval property.Give 1 field in G/L Setup where we assign minutes that when ideal time is greater than given Time then session will be killed.When I open this form my code execute and showing above given error.

einsTeIn.NET

You didn't answer the question. That's the way your function is triggered. That's not the way the session is killed.

vikram7_dabas

Session is killed by writing code which is given below:

If Session."Ideal Time"> GLSetup."Ideal time(minutes)" then
Session.delete(true);

Where,
Session Data Dype: Record Table:Session

Malajlo

This should work, I'm using same method on native and SQL databases.

I'm guessing, but for your error, I think you could have problem with column (field) type. "Ideal time" or "Idle time"? "Idle" is standard field. "Ideal" your custom field?

vikram7_dabas

Dear concern
I have changed the name of my field to Idea Time then also it is showing me same error.I m using O.S Windows server 2008 and SQL server 2008.

Malajlo

Use existing fields. Custom field should be type of Duration.

T:91
Enabled	Field No.	Field Name	Data Type	Length	Description
Yes	13031258	Idle Timeout	Duration		AX001

AutoLogoff()
users.SETFILTER(users."Idle Timeout",'<>''''') ;
IF users.FINDFIRST THEN
  REPEAT
    Sessions.SETFILTER(Sessions."User ID",'*'+users."User ID") ;
    IF Sessions.FINDFIRST THEN
      IF Sessions."Idle Time" > users."Idle Timeout" THEN
        BEGIN 
          Sessions.DELETE ;
          MESSAGE('User %1 has been disconnected after %2.',users."User ID",users."Idle Timeout") ;
        END ;
  UNTIL users.NEXT = 0 ;

vikram7_dabas

I have tried this code also then also it is showing me same error.

einsTeIn.NET

What happens if you delete a record in the session table manualy (not by code)?

vikram7_dabas

When I m deleting maually it is successfully deleted no error found but when using code same error found.

vikram7_dabas

Any Solution :-k

kriki

Give it a try with DELETE(FALSE) instead of DELETE(TRUE):

recSession.DELETE(FALSE);

vikram7_dabas

Still same error,but error has been solved by putting Commit just after delete code.I dont know how it runs.It is not showing me any error.Can u tell me logic?

kriki

vikram7_dabas wrote:

Still same error,but error has been solved by putting Commit just after delete code.I dont know how it runs.It is not showing me any error.Can u tell me logic?

No. I haven't the slightest idea.