E10 table to replace E9 LicUser

Yahoo Archive
1
I should have just looked. :D
I see that there is a field that sounds like it would contain the computer name but all the rows have the same value, which appears to be the Company Name.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, October 16, 2015 8:25 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: E10 table to replace E9 LicUser



One of the field I notice that was missing in the EAC for 10 that was in 9 is the computer name column.

Do you know if that field is still tracked?


[cid:9e10b0.png@a2fa77d2.429be955]


Joe Rojas
Director of Information Technology
(781) 408-9278 Mobile
(781) 573-0291 Local
(781) 232-5191 Fax


[http://matsinc.com/images/e-mail-signatures/tagline.jpg%5d
[http://matsinc.com/images/e-mail-signatures/graphics/logo_matsinc.png%5d<http://matsinc.com> [http://matsinc.com/images/e-mail-signatures/graphics/icon_twitter.png%5d <http://twitter.com/Mats_Inc> [http://matsinc.com/images/e-mail-signatures/graphics/icon_facebook.png%5d <http://www.facebook.com/commercial.flooring> [http://matsinc.com/images/e-mail-signatures/graphics/icon_youtube.png%5d <http://www.youtube.com/user/MatsIncTV> [http://matsinc.com/images/e-mail-signatures/graphics/icon_pinterest.png%5d <http://www.pinterest.com/contractfloors/> [http://matsinc.com/images/e-mail-signatures/graphics/icon_blog.png%5d <http://matsinc.com/blog>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, October 15, 2015 11:52 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: E10 table to replace E9 LicUser


Erik,

Also to note, you are looking at a 10.1 Schema not 10.0…

Ice.SessionState doesn’t exist until 10.1

One option is to create an Updateable BAQ that overrides the GetList Method and calls the AdminSession.GetList implementation. Or just look in the Admin Tools.

Regards,

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, October 15, 2015 4:47 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: E10 table to replace E9 LicUser



Just wanted to make a correction. There *is* some useful, human readable info in the Ice.SessionState table. My eyes missed it earlier. That said, calling AdminSession.GetList will return real-time information that might not have been flushed to SQL.


Stephen Edginton (Beng) | Solutions & Technical Director

Mobile:

+44 7734 858415

DDI:

+44 121 314 1179

Main:

+44 (0) 121 314 1170

Web:

www.dotnetit.co.uk<http://www.dotnetit.co.uk>



Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.

[Image removed by sender. DotNetIT]


[Image removed by sender. Epicor Platinum Partner]


[Image removed by sender. Epicor Alliance Partner]




[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
2

We have a dashboard in E9 that looks at the LicUser table to show license usage and who is logged in.  Is anyone aware of a similar table in E10?

3

The session information was moved to a table called Ice.SessionState.  Unfortunately, there nothing human readable in the data columns – it’s all blobs.  Also, this table is really a backing store for an in-memory session cache, so it may have stale data or new sessions might not yet be flushed to the table when you read it.  The best way to fetch active sessions is to call the AdminSession.GetList() operation. 

 

Just some background about the change: The LicUser table was a major bottleneck in Epicor 9 because *every* server call would read the session info during authorization and then write the row back out to the LicUser to update the last-used value.  It was the most frequently hit table in the system in scale tests.  And yes, there were a lot of ways we could have optimized it.  But for 10, we went with an in-memory cache to eliminate the SQL contention altogether.  It uses Ice.SessionState as a backing table in case the app pool recycles or sessions need to be shared across app servers in a server farm.  I have sent feedback to R&D that a human-readable value in that table would be useful. ;)



This message has been scanned for malware by Websense. www.websense.com

4
Just wanted to make a correction.  There *is* some useful, human readable info in the Ice.SessionState table. My eyes missed it earlier.  That said, calling AdminSession.GetList will return real-time information that might not have been flushed to SQL.
5
#ygrps-yiv-706863057 P.ygrps-yiv-706863057b1e7fd89-0279-4ffe-a16a-1f1bcba0d537 { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-706863057 LI.ygrps-yiv-706863057b1e7fd89-0279-4ffe-a16a-1f1bcba0d537 { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-706863057 DIV.ygrps-yiv-706863057b1e7fd89-0279-4ffe-a16a-1f1bcba0d537 { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-706863057 TABLE.ygrps-yiv-706863057b1e7fd89-0279-4ffe-a16a-1f1bcba0d537Table { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-706863057 DIV.ygrps-yiv-706863057Section1 { }

Erik,

 

Also to note, you are looking at a 10.1 Schema not 10.0…

 

Ice.SessionState doesn’t exist until 10.1

 

One option is to create an Updateable BAQ that overrides the GetList Method and calls the AdminSession.GetList implementation. Or just look in the Admin Tools.

 

Regards,

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, October 15, 2015 4:47 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: E10 table to replace E9 LicUser

 

 

Just wanted to make a correction.  There *is* some useful, human readable info in the Ice.SessionState table. My eyes missed it earlier.  That said, calling AdminSession.GetList will return real-time information that might not have been flushed to SQL.



Stephen Edginton (Beng) | Solutions & Technical Director

Mobile:  +44 7734 858415
DDI:  +44 121 314 1179
Main:  +44 (0) 121 314 1170
Web:  www.dotnetit.co.uk

Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.

DotNetIT

Epicor Platinum Partner

Epicor Alliance Partner
6
One of the field I notice that was missing in the EAC for 10 that was in 9 is the computer name column.

Do you know if that field is still tracked?


[cid:9e10b0.png@a2fa77d2.429be955]


Joe Rojas
Director of Information Technology
(781) 408-9278 Mobile
(781) 573-0291 Local
(781) 232-5191 Fax


[http://matsinc.com/images/e-mail-signatures/tagline.jpg%5d
[http://matsinc.com/images/e-mail-signatures/graphics/logo_matsinc.png%5d<http://matsinc.com> [http://matsinc.com/images/e-mail-signatures/graphics/icon_twitter.png%5d <http://twitter.com/Mats_Inc> [http://matsinc.com/images/e-mail-signatures/graphics/icon_facebook.png%5d <http://www.facebook.com/commercial.flooring> [http://matsinc.com/images/e-mail-signatures/graphics/icon_youtube.png%5d <http://www.youtube.com/user/MatsIncTV> [http://matsinc.com/images/e-mail-signatures/graphics/icon_pinterest.png%5d <http://www.pinterest.com/contractfloors/> [http://matsinc.com/images/e-mail-signatures/graphics/icon_blog.png%5d <http://matsinc.com/blog>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, October 15, 2015 11:52 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: E10 table to replace E9 LicUser


Erik,

Also to note, you are looking at a 10.1 Schema not 10.0…

Ice.SessionState doesn’t exist until 10.1

One option is to create an Updateable BAQ that overrides the GetList Method and calls the AdminSession.GetList implementation. Or just look in the Admin Tools.

Regards,

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, October 15, 2015 4:47 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: E10 table to replace E9 LicUser



Just wanted to make a correction. There *is* some useful, human readable info in the Ice.SessionState table. My eyes missed it earlier. That said, calling AdminSession.GetList will return real-time information that might not have been flushed to SQL.


Stephen Edginton (Beng) | Solutions & Technical Director

Mobile:

+44 7734 858415

DDI:

+44 121 314 1179

Main:

+44 (0) 121 314 1170

Web:

www.dotnetit.co.uk<http://www.dotnetit.co.uk>



Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.

[Image removed by sender. DotNetIT]


[Image removed by sender. Epicor Platinum Partner]


[Image removed by sender. Epicor Alliance Partner]





[Non-text portions of this message have been removed]