22-04-24 08:14 AM
Check in DB, a decommissioned run-time resource have been occupying one session for long time. How can I release this session occupied? Many appreciate if you can provide me scripts if necessary. Thanks!
Answered! Go to Answer.
22-04-24 10:28 AM - edited 22-04-24 10:29 AM
Hi Eric - if the resource is still listed in System>Resources>Management>Retired Resources, un-retire it by dragging it back in to the Active Resources list. Then if the session is Pending, you should be able to delete it from Control Room. If the DB 'thinks' the session is still running, then you'll need to update the row in the BPASession table to make the session complete. If might be best to raise a ticket to ask the Support team for a script, but I think the fields to update are endatetime, lastupdated and statusid=4.
22-04-24 10:28 AM - edited 22-04-24 10:29 AM
Hi Eric - if the resource is still listed in System>Resources>Management>Retired Resources, un-retire it by dragging it back in to the Active Resources list. Then if the session is Pending, you should be able to delete it from Control Room. If the DB 'thinks' the session is still running, then you'll need to update the row in the BPASession table to make the session complete. If might be best to raise a ticket to ask the Support team for a script, but I think the fields to update are endatetime, lastupdated and statusid=4.