How to remove pending sessions

[RobDixon]

It appears I have two orphaned sessions which are showing as Pending in Control. My license only permits two sessions. How can I get rid of these sessions? I've tried restarting, even rebooting, but neither have worked.

[harish.mogulluri]

Hi rob dixon,

Check below KB articles
1) why session will stuck in the pending state - https://support.blueprism.com/en/support/solutions/articles/7000076644-how-can-a-session-created-by-scheduler-get-stuck-in-a-pending-state-

2)how to correct sessions that are stuck in pending state - https://support.blueprism.com/en/support/solutions/articles/7000076795
For your question - you can use pending starter vbo to handle this issue

[RobDixon]

Thanks Harish, that is very helpful. My problem is am just starting out on becomning a developer so I do not have any spare sessions in my licence if I have to create another session. Also I do not know how I can run the SQL query as do not know whereabouts the DB resides.

[chris.strong]

Hello @Rob Dixon 

You can remove the Pending Sessions by deleting them, within the Control Room > Environment panel, right-click on one of the Pending sessions and choose Delete.

As you are a learner and have a license for 2 sessions, I’m assuming you’re simply using the Blue Prism Learning Edition on your local computer.

Tip: We leverage Microsoft SQL Server Express LocalDB to host the database for Learning Edition, and we create a database called: BluePrismLocalDB

Kind regards

Chris Strong

Senior Product Manager

SS&C | Blue Prism