<!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">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;">
jBPM 4.3 starting a sub-process after a state node will fail
</h3>
<span style="margin-bottom: 10px;">
reply from <a href="http://community.jboss.org/people/tunmang">Tun Mang</a> in <i>jBPM</i> - <a href="http://community.jboss.org/message/535419#535419">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>Hi Maciej :</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Because of your working attachment, so I think it is worth of debugging it in my environment this time.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><div>So now I run the following command:</div><div> </div><div>   %> WfeUtility -start SimSubProc</div><div> </div><div>In my database, now I have a new data row :</div><div> </div><div>  DBID_ ... ACTIVITYNAME_ ... ID_                        ... SUBPROCINST_   </div><div>  50001     check_id                  SimSubProc.50001</div><div> </div><div>Now I run the following command:</div><div> </div><div>    %> WfeUtility -signal SimSubProc.50001</div><div> </div><p>Now it dumps the following exceptions :</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>    10:24:27,736 SEV | [JDBCExceptionReporter] Cannot add or update a child row:</p><p>    a foreign key constraint fails (`jbpm_4_3/jbpm4_execution`, CONSTRAINT</p><p>    `FK_EXEC_SUBPI` FOREIGN KEY (`SUBPROCINST_`) REFERENCES `jbpm4_execution` (`DBID_`))</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>    10:24:27,736 SEV | [AbstractFlushingEventListener] Could not synchronize database state with session</p><p>     org.hibernate.exception.ConstraintViolationException: could not update:</p><p>    [org.jbpm.pvm.internal.model.ExecutionImpl#50001]</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>After debug and comment out only one line in "AcquireDbidBlockCmd.java" as shown below :</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>    "org.jbpm.pvm.internal.id.AcquireDbidBlockCmd" :</p><p>    ....</p><div id="_mcePaste">    session.update(property);</div><div id="_mcePaste">    //  session.flush(); // <-- only comment out here</div><div id="_mcePaste"> </div><div id="_mcePaste">    return nextId;</div><div>    ....</div><div> </div><div>Now re-run the command "WfeUtility -signal SimSubProc.50001", it works all fine and in my database is :</div><div> </div><div><div>  DBID_ ... ACTIVITYNAME_ ... ID_                        ... SUBPROCINST_   </div><div>  50001     check_id                  SimSubProc.50001     60001</div><div>  60001     get-approval              SubProcTasks.60001     </div></div><div> </div><div>So the results of the data rows indicates the exceptions (thrown by session.flush()) are somehow related to when the "SUBPROCINST_" field of data row "50001" wants to refer to ID "60001".</div><div> </div><div>So I wonder :</div><div> </div><div>(1) There are some patches of fixes for jBPM 4.3 required, but I don't have them in my jBPM ? (did you ever patch your jBPM 4.3 ?)</div><div>(2) My jbpm.default.cfg.xml has something wrong ? (then how come other 99% of user cases works, only this one does not.)</div><div> </div><div>Thanks a lot for your help. <span> :) </span></div><div> </div><div>Tun Mang</div><div> </div><div> </div><div> </div><div> </div><div> </div><div> </div><div> </div><div> </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/535419#535419">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>