Using Active Sessions table in .al development

lvanvugt

The other day I ran into a strange issue. On my local system I had build a page extension on the Session List (PAG9506). This included an action that triggers code that references the "Session ID" field of the SourceTable (i.e. Active Session table (2000000110)). I could build en deploy the extension and found it working fine.
After this I had to deploy this extension to our centralized test database. I used VSCode to deploy it and got the error that "Session ID" was not know in this context and I could not deploy the extension.
So far I haven't found any indications why this happened. Do you? All ideas are welcome.

thomas_barbut

Hello,

Maybe they are different versions and the test database has a bug which has been solved in newer versions?
Apart from that I'm out of ideas.

lvanvugt

In the database only a system.app showed when using Get-NAVAppInfo -SymbolsOnly. So I added the application.app and performed a full symbol generation. After that the issue was solved.
Somewhat strange in my perception as, IMHO, Active Session table is part of the system.app.

Regarding the issue: case closed.

thomas_barbut

Hello Luc,

Have you tried downloading the symbols again after authentication?
CTRL + SHIFT+ P in VSCode and select Download Symbols.



I had something similar few weeks ago and that solved my issue.

best regards,
Thomas Barbut

lvanvugt

thomas_barbut wrote: »

Hello Luc,
Have you tried downloading the symbols again after authentication?

Thanx for your thought, Thomas. Feels like it did this a zillion time, but I will surely try again. ;-)

Note (didn't write that in my original post; shame on me ;-): this extensions also references a number of standard objects and these all are fine. Leaving out the Sessions List extension, I could get my extension build and deployed, and see it was working just fine.

thomas_barbut

Hello,

Maybe they are different versions and the test database has a bug which has been solved in newer versions?
Apart from that I'm out of ideas.

lvanvugt

thomas_barbut wrote: »

Hello,
Maybe they are different versions and the test database has a bug which has been solved in newer versions?
Apart from that I'm out of ideas.

Thanx for bearing with me, Thomas.
Today I am going to check it, but we think it's the system app in the database that's out of date. We upgraded to NAV 2018 RTM this year and imported the system and application apps into the upgraded database. After that we upgraded to CU3 and later CU6. Not sure, but it seems that we have forgotten to update the system app accordingly.

lvanvugt

In the database only a system.app showed when using Get-NAVAppInfo -SymbolsOnly. So I added the application.app and performed a full symbol generation. After that the issue was solved.
Somewhat strange in my perception as, IMHO, Active Session table is part of the system.app.

Regarding the issue: case closed.

thomas_barbut

Hello,

glad you were able to solved it.
In order to identify in which of the .app the table is you can just unzip both .app files and open up the SymbolReference.json files within those Archives.

Active Session Table is part of application.app.