Warning Status in Blue Prism Database

[MichaelNiemeyer]

I'm playing around with the concept of building a process that will monitor the control room for items in 'Warning' status and take steps to resolve the issue. However, I'm struggling with understanding a key part of the database. I found a table of status types, with 0 being pending, 1 being running, etc., but do not see anything for warning status. Is anyone able to explain to me how the control room is updated to label a status from 'Running' to 'Warning' when the warning threshold is exceeded? Is there a query in the database that would find such items in warning status?

[david.l.morris]

I haven't gone in to look at the tables yet so I could be completely wrong with what I'm about to say. I just keep forgetting to check the DB when I'm at my personal computer since I don't have direct access to the DB at the moment. I'm guessing that it's not using the word 'Warning' at the database level. I guess there could be a status field that is updated with that word or with a number that relates to that status, but more likely the UI is displaying 'Warning' when the 'Latest Stage' field has been the same for at least 5 minutes (by default) by comparing the session 'Start Time' and the 'Stage Started' time.

[david.l.morris]

Sorry, I said that wrong. It would be comparing the 'Stage Started' time and the current time.

[TomCirone]

Can confirm you're correct David! You basically have to replicate the same warning logic in your own monitoring solution.

[david.flores]

Here is a KB article that helps explain the warning status within Blue Prism: http://portal.blueprism.com/customer-support/support-center#/path/1171547642

The 'Warning' state in Control Room is calculated in the application by comparing the 'lastupdated' and 'warningthreshold' fields on BPASession with the current time. Therefore, if the 'lastupdated' time is longer ago than the 'warningthreshold', then you will get the Warning status. The 'Warning' state itself is not stored in a field in the database.



------------------------------
Regards,

David Flores
Sr. Product Consultant
blue prism
------------------------------

[rajeshkumarmuthineni]

Hi David I recently started working on BOT Wrangler, I was stuck at Warning Query. This helps Thanks for the Info

------------------------------
Rajesh kumar Muthineni
RPA Developer
Highmark Health
America/Chicago
------------------------------

[rajeshkumarmuthineni]

​

Tried running the attached process with 400 sec sleep, after 300 secs which is more than Thresholdwarning (300) Status changed to Warning.

datediff(ss, max(Session.lastupdated), CURRENT_TIMESTAMP) > Max Sleep or Wait in any Process should give the Accurate warning Processes

Note for Viewers - Test and Implement  

Thank you,
Rajesh kumar Muthineni
RPA Developer
Highmark Health
America/Chicago
------------------------------