Scheduler Pending Session Starter VBO

[David-Dinh]

This is the beginning the support thread for this VBO.

------------------------------
David Dinh
Software Support Engineer
Blue Prism
America/Chicago
------------------------------

[HongJooChoi]

Hi, @David-Dinh

Thank you for the clarification.

Yes, I did confirm that the PSS works for the pending sessions created by drag-n-drop from the Control Room with the testing mode set to True. I believe it's going to be very useful if it works also for the scheduled sessions as users would have more options to operate the RPA such as to run it on a regular basis under the environment where the network is not stable.

Will get back to you if I've got more question.

Best regards

------------------------------
HongJoo Choi
------------------------------

[11235813sk]

Hi @David-Dinh, Is there any code stage by which I can get the resource list instead of using SQL. I want to make change to the code stage so it gets all the resources in BP Env and check if there is a pending session and then decide to start or delete it.

------------------------------
sanjeev rout
Advanced App Engineering Specialist
Accenture UK
Europe/London
------------------------------

[David-Dinh]

Hi @11235813sk, I'm sorry but we dont have a code stage.  If you can not use SQL, you can hard code the resources as an alternative.

Thanks,

David

------------------------------
David Dinh
Software Support Engineer
Blue Prism
America/Chicago
------------------------------

[SaryaSasidharan]

Hi David,

Using this VBO would it be possible to identify and start the pending sessions based on session start time or the time elapsed, so that it doesn't pick up all pending sessions but only the ones that are actually stuck.  

Thanks,

Sarya

------------------------------
Sarya Sasidharana Latha
------------------------------

[SaryaSasidharan]

Hi David,

Using this VBO would it be possible to identify and start the pending sessions based on session start time or the time elapsed, so that it doesn't pick up all pending sessions but only the ones that are actually stuck.  

Thanks,

Sarya

------------------------------
Sarya Sasidharana Latha
------------------------------

[David-Dinh]

Hi Sarya,

This query will be helpful.  You can join with BPAResource to get the name of the resource where pending session is stuck.

/*

Will get all sessions stuck ip pending after X seconds.  Change the value as needed.

Make sure to keep the minus sign.

DATEADD (SS , -X , GETDATE())

*/

Select count(0) 
from BPASession 
where 
    starteruserid = (select userid from BPAUser where systemusername = 'Scheduler')
and startdatetime < DATEADD (SS , -10 , GETDATE())
and statusid = 0

------------------------------
David Dinh
Software Support Engineer
Blue Prism
America/Chicago
------------------------------

[SaryaSasidharan]

Hi David,

Thanks for sharing the query. Is this functionality available in any of the Blue Prism Libraries , so that we can incorporate this into the current Scheduler Pending Session Starter VBO.

Regards,

Sarya

------------------------------
Sarya Sasidharana Latha
------------------------------

[BathriK]

Hi David

I utilized the provided Blue Prism release (Scheduler Pending Session Starter v2000) for one of my processes to initiate pending sessions in the Control Room. We are currently using v6.9 Blue Prism. The VBO triggers the process that are in pending state while code debugging. However, when attempting to run the same from the Scheduler, I encounter an internal error stating:

"Could not execute code stage because exception thrown by code stage: Failed to start sessions, for example: (XXX)."

Seeking your help on this please

------------------------------
BathriK
------------------------------

[David-Dinh]

Hi Bathri,

Are you using this VBO below?

"Scheduler Pending Session Starter for BP versions up to 7.1 Users Guide v2000.zip"

Can you test the connection between the app server(s) to the machine running PSS, and from that machine to the one that is trying to start.

How to test if the BP listener port is open : (blueprism.com)

If this does not work, please log a ticket to Blue Prism and note (please assign to David Dinh).  We can get on a call.

------------------------------
David Dinh
Software Support Engineer
Blue Prism
America/Chicago
------------------------------

[David-Dinh]

HI Sarya,

Sorry for delay.  The only way that I know of is to use a database query to get anything greater than X seconds.  The best way is to filter by user id = 'Scheduler'.  If you send a command to run it twice it wont hurt anything (just incase scheduler didnt have enough time to start it before PSS VBO did.)

------------------------------
David Dinh
Software Support Engineer
Blue Prism
America/Chicago
------------------------------