We are trying to monitor for work queue items that take longer than they should (e.g. when the application a process is interacting with is hanging). I see a "locktime" (and "lockid") column in the BPAWorkQueueItem table even, but it does not seem to be used. I suggest the time that an item is locked for working be recorded here or somewhere similar. This will facilitate monitoring how long an item has been worked on, even before it is finished, in case it doesn't finish in a timely manner. We looked into using loadtime but that seems to be when the current batch of items was loaded as opposed to when a specific item was picked up by a Get Next Item stage, and worktime seems to be only recorded at the end of an item's work time so it cannot help in the moment.
... View more