Sessions Monitor

[JoshuaKingsley]

Hello everyone,

I would like to know if someone is using monitors for sessions that stuck in a warning state, or running for several hours, in pending state and not started. I'm thinking to run a query directly to the production database to get the required details, store or update external table which can be used as a live monitor dashboard and calling this action or process in the actual business process or the logins. I dont think session functions are not exposed directly to internal VBOs or CLI commands.

Sorry, I'm not up to date with the current capabilities. Please share your ideas / working solutions that you are using.

Thanks in advance.

Currently in version 7.3

[david.l.morris]

We have an automation that runs once an hour or so to check for various environment issues including checking for pending sessions and warning state sessions. We do query the database directly as you mentioned and that works well. The Warning state is not a database-level data point as far as I have found. I think it is just a UI thing or based on some query (such as the view used below) of the pending session's start time vs current time.

Here is one of the basic queries we use to detect stuck pending sessions:

SELECT COUNT(*) AS RESULT
FROM dbo.BPVSessionInfo INNER JOIN dbo.BPAStatus ON dbo.BPVSessionInfo.statusid = dbo.BPAStatus.statusid
WHERE
DATEDIFF(minute,dbo.BPVSessionInfo.startdatetime, SYSDATETIME()) > 10
AND dbo.BPAStatus.description = 'Pending'

You'd change that 10 to whatever you want for the number of minutes to consider it a stuck pending session.

And there are also some Digital Exchange assets that may help. I searched for "Pending Session" just now to get these as I knew there were some but didn't know exactly what:
Blue Prism Session Control

Pending Session Starter VBO for BP version 7.2(+) XBP

Here's a simple query we have for checking for warning state sessions:

SELECT COUNT(*) AS RESULT  
FROM dbo.BPVSessionInfo INNER JOIN dbo.BPAStatus ON dbo.BPVSessionInfo.statusid = dbo.BPAStatus.statusid 
WHERE dbo.BPVSessionInfo.enddatetime IS NULL
AND DATEDIFF(minute,dbo.BPVSessionInfo.lastupdated, SYSDATETIME()) > 15

You'd change the 15 to whatever minutes you'd consider it to be in a Warning state. By default, Blue Prism uses 5 minutes for the Warning state.

We also have more complicated queries as well but they may be rather specific to us, so I figured that basic queries may be what you'd want to start with. Note that they use a View in the database and not directly on a database table as the view has some logic on its own that makes our query simpler.