<!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;">
JBPM_PROCESSDEFINITION table 'losing' rows in Oracle
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/michaelholtzman">Michael Holtzman</a> in <i>jBPM</i> - <a href="http://community.jboss.org/message/563968#563968">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>Greetings. We are seeing some odd behavior with jBPM 3.1.2 and Oracle.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>For no particular reason (that we can see), the JBPM_PROCESSDEFINITION table is missing rows. A user will attempt to instantiate a process instance, and jBPM will claim that the definition does not exist. If the defintion is redeployed, everything is fine.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>We maintain our own table of deployment history. So according to our table, the current version of the named definition is 6, but deploying to jBPM returns the current version as 3, or 1, or whatever, when we are expecting the new version to be 7.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>More important than the cause of this problem would be how to recover. We have the history of deployments (including the xml representation of the definition). We could redeploy the missing versions, but the new ProcessDefinition objects would have the wrong ID_ property. Is it possible to specifiy a target ID_ or change the ID_ of a ProcessDefinition?</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Anyone have any insight into what might be causing the problem? We suspect that copying and/or upgrading the database is the culprit but we've done that dozens of times without a problem. Also, any ideas on recovery would be great.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Thanx.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Mike Holtzman</p></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/563968#563968">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>