Notifications
Clear all
Topic starter
I realize this is a license issue, and that GE should be contacted about this, but is there any way to knock out "ghost" sessions to be able to get the necessary users online quickly? We cannot see patients while this error is showing up.
Posted : June 16, 2015 4:50 am
Hi Hunter,
I created this utility,
https://aphoenixtech.com/estore/centricity-apps/cps/p-81-logged-in-user-utility
This should solve your problem.
Posted : June 16, 2015 4:59 am
If you know which users are no longer in the system, you can take them out easily. First confirm that they are actually in the license list, then blow them away:
SELECT * FROM iLicUserInfo WHERE [LoginName] = 'the_users_login'
DELETE iLicUserInfo WHERE [LoginName] = 'the_users_login'
Posted : June 16, 2015 5:08 am
Here we have a couple of things set up. One, we have the Idle User Timeout set to 30 mins so if the user hasn't done anything in CPS in 30 mins then it logs them out. Since we also use Citrix, we also have it set in Citrix to close the Citrix connection at 32 mins so if the user is signed in through Citrix, then CPS times them out in 30 mins but Citrix doesn't let go of the session for another couple of mins.
Posted : June 16, 2015 6:08 am
We've used this in the past, but it's been awhile. I'd test first.
select * from ilicuserinfo order by loginname;
Select * from AppSession order by AppSessionID;
select * from ilicuserinfo,AppSession where ilicuserinfo.SessionID = AppSession.AppSessionID order by ilicuserinfo.LoginName;
--Setting Active to 0 in AppSession makes license issues go away
--Update AppSession set active = 0
Posted : June 16, 2015 6:26 am
Topic starter
You guys are great. Thank you.
Posted : June 16, 2015 6:47 am
