Blue Prism Product

last person joined: yesterday 

Chat about Blue Prism products
Expand all | Collapse all

Process stuck in pending state

  • 1.  Process stuck in pending state

    Posted 06-29-2019 03:54
    HI, 

    I have a process scheduled to run every 5 mins, however, every once in a while it gets stuck in the pending state and we have to go in and manually restart it to get it to work again. 

    How can we keep a tab on the process so that it doesn't get stuck in the pending state ? Is it possible to trigger an alert if it's stuck in the pending state for more than a certain duration ?


    ------------------------------
    Karthik Pillai
    FourNxt
    Asia/Dubai
    ------------------------------


  • 2.  RE: Process stuck in pending state

    Posted 07-01-2019 11:48
    There's no native way to trigger an alert if a process gets stuck in a pending state. You may want to look into why that is happening because it should not occur. How often are you saying this happens?

    I hate to make a suggestion like this, but if scheduler is not performing correctly for you, have you considered changing the process so that it runs constantly all day long and it has logic built in to only do its job every 5 minutes? The way it sounds to me with it running every 5 minutes, you're already essentially eating up a full license all the time anyway.

    I think most people accomplish this kind of monitoring through external tools that query the BP database. (I have seen suggestions to always mirror the production DB and query the mirror. I haven't seen any real reason to do this but I figured I'd point it out)

    As for troubleshooting why the session gets stuck as pending... Have you looked around at various logs such as event logs and what not? I think it'd be useful to determine what situation causes the session to get stuck that way. It's also possible that you could solve the issue by upgrading Blue Prism since there were several versions with known scheduler issues. We encountered issues with 6.2, 6.3 and versions around there. However, we've been using 6.4.1 for a little while and have encountered no scheduler issues. And so far I haven't seen anyone report issues about 6.5 scheduler.

    Just some things to consider. I feel your pain. Scheduler and alerting features need to be improved.

    ------------------------------
    Dave Morris
    3Ci @ Southern Company
    Atlanta, GA
    ------------------------------



  • 3.  RE: Process stuck in pending state

    Posted 07-02-2019 04:14
    We were having the same issue with a job scheduled each hour. It ran fine for more than one day but then the job stayed in pending state.
    We could not figure out the reasons as we would expect the scheduler to at least start the job or receive an error when trying to send the job to the robot.
    So assigning the job to a robot works but it was never started.

    We dont use resource pools and have Blue Prism 6.4.0.

    We noticed, this only happened when there is basically only this job scheduled and there is not much other activity on this resource. (There was one other job running only once per day).
    We now changed the utilization of our resources and two jobs running every 20 minutes and two other jobs once per day. Since then we didnt experience any pending job issues anymore.



    ------------------------------
    Walter Koller
    Solution Manager
    Erste Group IT International GmbH
    Europe/Vienna
    ------------------------------



  • 4.  RE: Process stuck in pending state

    Posted 12-23-2020 08:06

    Hi Team,

    Please Check your Licence session because if incase  all your instance in Bp is used/Busy then sometimes Your Schedule process will be in pending state and not get triggered into Running.

    So just to make sure please check when your process went into pending was there any bandwidth available at that moment.

    Regards,

    Manoj



    ------------------------------
    Manoj Kumar
    Technical Lead
    HCL
    Asia/Kolkata
    ------------------------------



  • 5.  RE: Process stuck in pending state

    Posted 12-23-2020 09:47

    Hi,

    In my experience the license check occurs before the process is taken to the pending state. It should not be possible to have a pending session if all licenses are taken.

    peter



    ------------------------------
    PeterLacken
    Ren Røros Intelligent Automation
    Peter.Lacken@rria.no
    http://www.rria.no
    ------------------------------



  • 6.  RE: Process stuck in pending state

    Posted 09-23-2019 04:00
    Hi,  It is best to have such a trigger independent of Blue Prism.  Use an monitoring tool that can query to the Blue Prism database and query the following SQL examples on a schedule.  They will look for pending sessions that have been pending for 10 minutes or more (indicating they are stuck).  

    --per process
    select convert(varchar(255), s.sessionnumber) as sessionnumber,
     s.startdatetime as startdatetime,
     convert(varchar(255), s.statusid) as statusid
    from BPASession s, BPAProcess p
    where s.processid = p.processid
    and p.name = '<PROCESS NAME>'
    and s.statusid = 0 --pending
    and s.startdatetime < dateadd(minute, -10, getdate())

    --all processes
    select convert(varchar(255), s.sessionnumber) as sessionnumber,
     s.startdatetime as startdatetime,
     convert(varchar(255), s.statusid) as statusid
    from BPASession s
    where s.statusid = 0 --pending
    and s.startdatetime < dateadd(minute, -10, getdate())


    ------------------------------
    PeterLacken
    Webstep AS
    Peter.Lacken@rria.no
    ------------------------------



  • 7.  RE: Process stuck in pending state

    Posted 08-07-2020 10:25
    So far we have seen this issue happen with all versions of Blue Prism from 5.x to 6.7.2. We are not running 6.8 in the production yet so I can't say anything from that version.
    Most annoying thing with this issue is that there are nothing in the event logs on the application servers or on the robots so you can't even start to try to guess what might be the issue. Scheduler just seem to plain randomly leave scheduled processes to be stuck in pending state with no apparent reason. We  have seen this happen with single processes in a new environment and with multiple processes stuck in pending after another in an older and larger environment.
    For example this morning, suddenly 13 processes that were supposed to start on 13 different robots between 8am and 8:30am, all were stuck in pending state. When start was issued manually, all processes started as expected. These processes have been running without issues for the past week. Nothing in the event logs on the robots or on the application servers so it is very frustrating to have to build external monitoring that alerts people to do manual work considering how simple part of the software is not working reliably.

    ------------------------------
    Petri Kaukua
    Certified Blue Prism Architect
    Digital Workforce
    Europe/Helsinki
    ------------------------------



  • 8.  RE: Process stuck in pending state

    Posted 08-12-2020 10:39

    Hi,

    Totally agree it is less than ideal to have this type of external monitoring.

    I have now a Powershell script that runs on a Windows Task Manager that checks for Pending sessions and then restarts them. It will also notify to a Teams Chanel the status of the restart.


    i Can tell you it is no better in v6,8.

    Use of RPA Supervisor instead of the Scheduler helps too but has additional cost.

    I would be happy to help install our solution on your application server on a hourly rate. It should not take more than half a day if you have resources available with the correct admin permissions.

    Regards,
    Peter



    ------------------------------
    PeterLacken
    Ren Røros Intelligent Automation
    Peter.Lacken@rria.no
    http://www.rria.no
    ------------------------------



  • 9.  RE: Process stuck in pending state

    Posted 12-23-2020 04:40

    Hi Peter,

    do you mind sharing some info around how to setup the shell script? We are too facing similar issues with schedules going into a pending state

    thanks

    varun



    ------------------------------
    Varun Puthan Veetil
    Technical Lead
    nbn
    Australia/Sydney
    ------------------------------



  • 10.  RE: Process stuck in pending state

    Posted 12-23-2020 06:07
      |   view attached
    Hi,

    Here is the installation guide for the solution that we use for our customers. If this is something you are interested in we can discuss more in the new year.

    Note in the release notes for Blue Prism v6,10 this is potentially solved. The wording isn’t very clear but certainly something has been fixed in 6,10.

    Regards,
    Peter




  • 11.  RE: Process stuck in pending state

    Posted 19 days ago
    Great ! Thanks Peter :) Will give that a go

    ------------------------------
    Varun Puthan Veetil
    Technical Lead
    nbn
    Australia/Sydney
    ------------------------------



  • 12.  RE: Process stuck in pending state

    Posted 08-12-2020 10:39
    This seems to be a bug in Blue Prism server, as far as I can tell. We used to have this problem intermittently; it was quite annoying to log in on Monday morning to find none of our processes ran over the weekend. We switched to an external scheduler (and turned off BP server altogether), using the Blue Prism command line to launch processes at the appropriate time. Two years and 455,000 process launches later, we've not had a single one get stuck in pending.

    ------------------------------
    Nicholas Zejdlik
    RPA Developer
    ------------------------------



  • 13.  RE: Process stuck in pending state

    Posted 12-23-2020 04:47

    Hi Nicholas,

    when you say external scheduler, do you mean windows scheduler? How are you triggering the next process on completion?

    thank you

    varun



    ------------------------------
    Varun Puthan Veetil
    Technical Lead
    nbn
    Australia/Sydney
    ------------------------------



  • 14.  RE: Process stuck in pending state

    Posted 12-23-2020 09:52

    I built a small custom scheduler that runs as a windows service. When the scheduled time is hit, it logs a request in SQL table which is picked up by a custom controller service, which then kicks it out to an available robot via the automatec.exe command line.

    As far as triggering the next process in the chain, the controller service monitors work queues and has triggers set up to launch processes when either a work queue has finished all its items, or has finished items with specific key values.

    Both services are custom solutions but it has worked out very well for us. To my original point, the only time I've seen the automatec.exe command line fail to launch a process is in the presence of heavy network loss. It does make me curious how automatec.exe is launching processes without issues, whereas Blue Prism scheduler was getting stuff stuck in pending quite frequently.



    ------------------------------
    Nicholas Zejdlik
    RPA Developer
    ------------------------------



  • 15.  RE: Process stuck in pending state

    Posted 19 days ago
    Nice!

    Thanks mate :)

    ------------------------------
    Varun Puthan Veetil
    Technical Lead
    nbn
    Australia/Sydney
    ------------------------------



  • 16.  RE: Process stuck in pending state

    Posted 12-02-2020 08:30
    Look at this thread: Scheduler Pending Session Starter VBO | Digital Exchange (blueprism.com).
    The process attached there solved this issue in my case (on BP 6.4, I don't know how it works on older/newer versions).

    ------------------------------
    Jan Skarbek
    ------------------------------



  • 17.  RE: Process stuck in pending state

    Posted 12-15-2020 12:11
    Hi Jan Skarbek,

    I get a message - "You are not eligible to view this message" when i click on the link you posted. What kind of access do i need to see it?

    Regards
    Prashant 


    ------------------------------
    Prashant
    Software Engineer
    IMF
    ------------------------------



  • 18.  RE: Process stuck in pending state

    Posted 12-15-2020 12:49
    Hi @Prashant​,

    Now I see the same, I don't have access to this page anymore.

    Check this thread, there is sth attached there : How Start or Remove a Pending Process using Command Line | Blue Prism Product

    Cheers

    ------------------------------
    Jan Skarbek
    ------------------------------



Share