NAV 2013 Active Session

nboettcher · 2013-12-23

I am trying to use the Active Session table from C/AL Code in NAV 2013.
I am doing the following:

ActiveSession.SETRANGE("Session ID", SESSIONID);
ActiveSession.FINDFIRST;
ServerName :=ActiveSession."Client Computer Name";

However, when that code is executed I get the following error:
"There is no Active Session within the filter. Filters: Session ID: 1"

If I look in SQL at the Active Session table, there aren't any entries. I have restarted the NAV Service multiple times.
Any ideas?

gideon · 2013-12-25

Hi,

The problem here is that you are forcing your session id filter to 1. Even if there are more that 1 session actually connected they might not be on session id 1. Where do you get this value from ?

Sog · 2014-05-21

I have some problems understanding why there is not always an active connection on the connection one is on. But the answer of gideon looks a bit odd, since the SESSIONID is a rather undocumented DATABASE variable. (I've looked in the help for SESSIONID, it's not there, even though it is a valid DATABASE variable)

So this question remains, because I get this error when calling similar functionality in a SOAP session.

SiSt · 2014-05-21

What do you want to achieve? The client has no database connection, only the service-tier has one.
As far as I know, the SESSIONID is deprecated and also the virtual table session is gone.

If you want to get the host name of the client you might need to use an automation/.net that runs on the client, like described here: http://www.dynamics.is/?p=282.

Sog · 2014-05-21

SiSt wrote:

What do you want to achieve? The client has no database connection, only the service-tier has one.
As far as I know, the SESSIONID is deprecated and also the virtual table session is gone.

If you want to get the host name of the client you might need to use an automation/.net that runs on the client, like described here: http://www.dynamics.is/?p=282.

I'm working with soap calls. and I require the database name. But regardless that it's always the same name for one instance, I must have it for the current session.
If SessionID is depreciated, I would greatly appreciate if you could point me to documentation about that.

SiSt · 2014-05-21

The session table is documented for NAV2009 (http://msdn.microsoft.com/en-us/library/dd338636.aspx) but it isn't for 2013, which let me believe that they do not support it any longer.

But I guess I was wrong, as they are some people using it with 2013.

But I guess there is a simpler way, at least in 2013R2 exists a virtual table Database (ID 2000000048), you can try to filter it for "My Database" = true. And read out the name of the Database.

Anatoliy_E · 2014-08-18

hey,
Looks like I have similar problem. Guys, can I search for any ActiveSession usage with C/SIDE?
I am absolutely unfamiliar with NAV, help please.
If I understood correctly all NAV code is in codeUnits, but I can't understand what invokes them.

Anatoliy_E · 2014-08-20

solved

OnAfterGetRecord trigger of Company Information page runs following code when System Indicator is "Company + Database" :

ActiveSession.SETRANGE("Session ID",SESSIONID);
ActiveSession.FINDFIRST;

The code causes the error.

At Company Information page edit form I've changed System Indicator field value from "Company + Database" to "Company".

Nightrider · 2016-07-29

@Anatoliy_E
Agreed, that's a good solution. I have done this too. In the past if I ever needed the DB name in C/AL, I'd just add it as a new text field to Company Info. Don't know if there's a better solution.

archer89 · 2016-07-30

it can be that the records in table active session where removed.
so, close the windows client, restart it.
then try again.

NAV 2013 Active Session

Comments

Categories