<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="http://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Re: A bug? Ksession.signalEvent and ProcessInstanceWaitingForEvent
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/byungwoojun">byungwoojun</a> in <i>jBPM</i> - <a href="http://community.jboss.org/message/609670#609670">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>To me, that the name query ProcessInstanceWaitingForEvent used by the ksession.signalEvent does NOT return with the correct process/subprocess instance which has the intermediate event type when there are some left-over data entries in the EventType database table due to:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>- multiple process instances for the same process defintion are running (i.e., there are more data entries in the EventType database table). Of course, the process instances have the same event type name. </p><p>- previous sessions failed and didn't clean up data entries from the EventType database table.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>There could be several ways to solve this. At this time, my team didn't want to add additional column to the database table, we solved the issues as follows: </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>1. When we start the process, we store a unique correlation id, a session id and a process instance id (it will be the top-level process instance id) in a database table (e.g., correlation id, session id, process instance id). </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>2. When an intermediate message arrives, we restore the session using the incomig correlation id from the database table. Using this table, we also find the top-level process instance id. </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>3. Using this process id, we query the EventType database table to find the process or sub-process which has the proper event type. The EventTypes database table has two columns: instance id and element. </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>e.g.,</p><p>InstanceID              Element</p><p>-----------------------------------------------------------------------------------</p><p>1356                       processInstanceCompleted:1357</p><p>1357                       eventType1</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>As you can see, the 1356 row points the 1357 row. In my opinion, the proper way to find a correct pid is drilling down the chain from the top-level pid which is getten from the startProcess. Instead of embedding the next pid part of the text data in the Element field, if we have the third column to point the next pid, we could use SQL chain query. Using the current schema, I need to get the 356 instance id, parse the element text (after the colon), then, get the row 1357 instanceid, so on....</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Since we don't want to add additional column at this time, we created a function with two parameters: eventType, topLevelProcessInstanceId:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>- the function queries the EventType database table using the topLevelProcessInstanceId.</p><p>- it parses the element column. </p><p>     - If the element contains the same eventType, it returns the processInstanceId.</p><p>     - Otherwise, it gets a sub-string after ":" (e.g., 1357). Use this sub-string (need to convert it to long) as a parameter along with the eventType (unchanged), and call the same function recursively until the element is equal to the event type.  </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>4. After the function, we call ksession.signalEvent(eventType, eventData, foundProcessInstanceId);</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>As you noticed, this method may end up querying multiple times depending on the depth of sub-processes. There could be some performance penalties. But, it works reliably regardless the EventTypes database table entries. </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>If jBPM engine itself supports the correlation out-of-the-box, it would be great. But for now, we need to code for the correlation support.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Any suggestions would be appreciated.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>bwj</p><div class="mcePaste" id="_mcePaste" style="position: absolute; top: 0px; left: 0px;"></div></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/609670#609670">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in jBPM at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>