• State Not Answered
  • Locked Locked
  • Replies 5 replies
  • Subscribers 93 subscribers
  • Views 3917 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Trigger WC in Approval Workflow

dan
over 6 years ago

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.

  • 0 over 6 years ago
    As the approval workflow steps are calculated by the DB Queue Processor you should ensure that the DB Queue is working normally.

    When the condition is fulfilled a subsequent JobQueue task has to be processed. Again, ensure that Job Queue is working normally.
  • 0 over 6 years ago

    Thanks Markus,

    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. 

  • 0 over 6 years ago
    Did you take a look at the Database Journal (for example with Job Queue Info)? Anything suspicious?
  • 0 over 6 years ago
    Mostly not. There are some errors that have been occurring a few times a day in the procedure, QBM_PDialogUserInGroupCorrect. It seems it's attempting to add a DialogUser to a DialogGroup but the key already exists in the m:n table for it. Other than that, I can't see any problems in the journal.
  • 0 over 6 years ago
    I am out of ideas. Feel free to contact support.