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
------------------------------

[David-Dinh]

UPDATE: There is a newer VBO Document in the latest comments.  Unfortunately, there is no way to replace it here, so please scroll to the bottom for latest zip file.  Scheduler Pending Session Starter Users Guide 1.2.1.p.zip

Attached VBO and documentation:

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

[David-Dinh]

Version compatibility looks like this
- 6.3.2 - Confirmed

• 6.4 - Confirmed - Use the older version switch
• 6.5 - Probable (unconfirmed)
• 6.6 - Confirmed
• 6.7 - Probable (unconfirmed)
• 6.8 - Probable (unconfirmed)
• 6.9 - Confirmed

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

[David-Dinh · Accepted solution]

Here is a new version after a user reported that Scheduler user would not fire off the pending session.  Change the settings from "[Scheduler]" to "[All]".  Attached is the new version, however, only the instructions is updated to reflect the above.

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

[GustavoKlein]

Wow! It's great.

Worked here, thanks David

------------------------------
Gustavo Klein
System Analyst
UTC
------------------------------

[AkankshaSharma]

Hi, 

How will this VBO work if there is no SQL permission?

------------------------------
Akanksha Sharma
Business Analyst
Barclays PLC
Asia/Dili
------------------------------

[David-Dinh]

Hi Akanksha,
This works through code stage calling BluePrism Libraries directly, hence no SQL permissions required.  The app connection's permission is already configured and the execution of is controlled by VBO execution access.

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

[JeswinJomario]

We have this issue affected for multiple resources. so how can we implement this. Do we need to schedule this process in a VM so that it will sort out the pending process in certain DB and run it all a once.  looking forward for the update.

------------------------------
Jeswin Jomario
------------------------------

[Cech.Jan]

Hello,
We have big troubles with pennding sessions and the VBO above works not correctly. When I run the proces in debug mode from the process studio (under my Admin account) it will fire(run) the stuck pending session properly (no matter if I set user as [Scheduler] or [All]), but when I run the process from the control room under robotic account on resource, it will not do anythink. When I set User as [Scheduler] it will go to error (

ERROR: Internal : Could not execute code stage because exception thrown by code stage: Failed to start sessions: 7d0afd04-2a92-4233-9122-d287f7146f52

) and with User set as [All] it will looks like processed OK, but nothing really happens and session stay in pending.

We have version 6.4.0 and I use "Old version" of VBO script.

It looks like, there must be some SQL permissions requirement, which my account has and the robotics have not? Or there is another reason of this?

Thanks for reply,
Jan

------------------------------
Jan Čech
RPA Specialist
SkoFIN s.r.o.
Europe/London
------------------------------

[David-Dinh]

Hi Jan,
Please see updated document section 7.3 to see if it fixes your issue.  
If it does not, please submit a trouble ticket and request a meeting with David Dinh and we will try to see what we can do.

Thanks,

David

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