Using V7.1. I have some approval workflows that include some Wait Conditions that call a SQL Function to determine if the approval workflow should move to the next step. It's working fine, just that while I'm testing sometimes the step goes through almost instantly but sometimes I have to wait upwards of 15 minutes - in these circumstances I have gone into SQL Server Management Studio and run the function and I can see it returning a positive value - so if the WC had been evaluated, it would have passed that step straight away.
Is there anyway I can trigger the Wait Condition to evaluate? I looked in DialogSchedule and couldn't see anything that looks related.
When this happens I don't see the job in the JobQueue which leads me to believe its the DBQueue.
I can see quite a few processes in the DBQueue in JobQueueInfo but beyond that, I don't know which process it would be I'm waiting for or why it sometimes takes a long time, even when there's not a particularly large load going on. Do you have any tips on where/how I should investigate further?
It looks like the DBQueue process I'm waiting for is called 'IT Shop meet approval automatically'. It's a WC at the end of the approval workflow. There's about 15 items that are sitting there with a Processing value of '0'. I've seen a few other processes pup up, process, then disappear. I can't tell why these 15 processes seem to be making no progress.