WorkflowProcessor sends "Over End Wait" - emails when EndWaitTime not reached

Description

The workflow processor should send emails alerts when a workflow activity is over a calculated wait time.
Due to a bug in the SQL-Query these emails are send before the calculated wait time is over.

WorkflowProcessor Line 247: "EndWaitTime > SysDate" should be "EndWaitTime < SysDate"

Environment

None

Activity

Show:
Carlos Ruiz
June 17, 2020, 10:59 AM

Hi , thanks for the patch.

Can you please describe how to configure a test for this?

Regards,

Carlos Ruiz

Markus Bozem
June 18, 2020, 1:42 PM
Edited

Steps to reproduce the problem:

Setup E-Mail

As: GardenAdmin

GoTo: System Admin → Client Rules → Client

GoTo: System Admin → General Rules → Security → Garden Admin

Config EMail Address:

Config WorkflowProcessor

As: System

GoTo: System Admin → General Rules → Server → Schedule

create new entry with 1 Minute:

GoTo: System Admin → General Rules → Server → Workflow Processor

select new Schedule (1 Minute)

Config Workflow

As: System

GoTo: System Admin → General Rules → Workflow → Workflow

Search for Process_Order

Change Duration Unit to minute

As: GardenAdmin

GoTo: System Admin → General Rules → Workflow → Workflow

Search for Process_Order

Add a node TestNode with

Action: User Window

Window: Purchase Order

Duration Limit: 5

Worflow Responsible: Invoker

Add transition to node (Start) to TestNode

with Sequence: 1

Start Workflow

Restart Server

As: GardenAdmin

Enter a new Purchase Order an complete the order.

Without the Patch: After one minute a mail is send to the Invoker with the subject: Alert Workflow Activity: Max Wait Time Ended TestNode

With the Patch. After 5 minutes as mail is send to the Invoker with the subject: Alert Workflow Activity: Max Wait Time Ended TestNode

Carlos Ruiz
June 21, 2020, 12:50 PM

Thanks for the detailed instructions.

Fixed

Assignee

Markus Bozem

Reporter

Markus Bozem

Labels

None

Tested By

None

Components

Fix versions

Affects versions

Priority

Major
Configure