[Vtigercrm-developers] flaw in the processing of workflow tasks

[Hamono, Chris (DPC)]

Unfortunately because the task queue is emptied I don’t know which task failed, I have written a trap for it hopefully something springs the trap.

Also I am still trying to work out the interaction of various tables

The important ones appear to be …

com_vtiger_workflows <= information needed to build a task
com_vtiger_workflowtasks <= information about how to run the task
com_vtiger_workflowtask_queue <= data to be used when running the task

Is that correct?

When the cron is run all the jobs in the queue are deleted whether they successfully ran or not.  I have altered the code so individual tasks are removed from the queue only if they complete without crashing the script.

Chris



From: vtigercrm-developers-bounces at lists.vtigercrm.com [mailto:vtigercrm-developers-bounces at lists.vtigercrm.com] On Behalf Of Uma S
Sent: Monday, 22 September 2014 4:08 PM
To: vtigercrm-developers at lists.vtigercrm.com
Subject: Re: [Vtigercrm-developers] flaw in the processing of workflow tasks

Hi,

Could you please report us with the task that created the problem. What's was job done by the task which lead to remove all tasks for workflow queue.

On Mon, Sep 22, 2014 at 8:43 AM, Hamono, Chris (DPC) <Chris.Hamono at sa.gov.au<mailto:Chris.Hamono at sa.gov.au>> wrote:
Version 6.0

If a task fails to run due to a configuration or other error. All tasks are emptied from the workflow task queue. Therefore no task are run at all.

Each task should only be removed just before it is run. That way one failing task won’t cause the others to fail. Finding a bad task is then just a matter of looking in the tasks to see what’s left and un-runnable.

More protection is also needed around a task to prevent that task from causing the script to fail.


Chris


_______________________________________________
http://www.vtiger.com/



--
With
Best Regards
Uma.S
Vtiger Team
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140923/20ba4f46/attachment.html>