Concurrent execution of parallel activities

This is a multi-part message in MIME format...

------------=_1264203842-8018-6318
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

Hi all,

Our team has developed a workflow that executes parallel activities concurrently, using the SchedulerToolAgent. But, we have run into what seems to be a common problem with this approach: optimistic lock failures when executing said activities concurrently. Messages like "java.sql.SQLException: Update failed, but Table SHKProcesses id=1001044 does exist with version=4" terminate our workflow execution mid-stream. This came up in the list just a short time ago: http://mail-archive.ow2.org/shark/2009-12/msg00001.html. It seems to go back a few years: http://mail-archive.ow2.org/shark/2007-04/msg00015.html.

We've tried a number of possible workarounds but have come up short; my question is, how do we address these optimistic lock failures against the process record? We cannot retry our transaction because the optimistic lock exception is thrown in a Shark-internal thread with none of our own code in the stack trace.

If the ANDsplit+Manual+SchedulerToolAgent recipe is not the correct one to use to achieve concurrent execution of parallel activities, then what is? 

Cheers.

------------=_1264203842-8018-6318
Content-Type: text/plain; charset="UTF-8"; name="message-footer.txt"
Content-Disposition: inline; filename="message-footer.txt"
Content-Transfer-Encoding: quoted-printable


--
You receive this message as a subscriber of the [email protected] mailing lis=
t.
To unsubscribe: mailto:[email protected]
For general help: mailto:[email protected]?subject=3Dhelp
OW2 mailing lists service home page: http://www.ow2.org/wws

------------=_1264203842-8018-6318--