05-01-2014 09:08 AM
Hello!
Is there any notification that can be configured to alert the onbase admin that they are nearing the max # of uncommitted batches?
Workflow is licensed.
Thanks!
05-01-2014 10:03 AM
I'm not aware of any settings that would notify you if you are reaching the global max number of uncommitted batches. I can think of several ways to do it however.
With WF, you could build a VBScript to query the database and set a property that can be evaluated to determine if you get a notification or not. The script could return either the actual number of uncommited batches or even a % based on the max allowed number of uncommited batches. Then you can have a rule to determine when you get notified.
Outside of OnBase you can do basically the same thing by querying the DB and sending a notification when the criteria is met.
You may even be able to work with your DBA to setup an alert through SQL Server or any monitoring tools you have.
This query would return a count of all uncommitted batches in the system:
select count(*) from hsi.archivedqueue where status <> 8
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.