the node after pause node went wrong

[xren]

I have a test process AccessApproval:

start node ->
-> interactive node associated with a form: with two doors for approval.

-> non interactive node with system activity: if door1 selected open a job for doorApproval process , if door2 selected, open another job for doorApproval process
save all these doorApproval process jobs to a table

-> pause node: script are run every 2 minutes: check if all doorApproval process jobs are complete, if done then set the $PALUSE_COMPLETE=Y

-> system node with activity: send notice email

However, the email is keep sending out non stop - don't know how to stop it???

[Jon]

Cancel the job using the workflow administrator

[xren]

I did cancel the job, but the system still keep sending email. The server log said that it cannot stop a completed job (seems from one of the steps in the process was trying to stop the job)

[Jon]

If this is a test system, you can remove all the records from database table workflow_workitem. This may break any workflow jobs that are currently active, but hopefully this doesn't matter in a test system.

It doesn't make sense that emails are still being sent from a completed job. You could check the jobs for a list of tasks (using workflow administrator) to try and find out what is happening.