[jboss-user] [jBPM] - JBPM_PROCESSDEFINITION table 'losing' rows in Oracle

Michael Holtzman do-not-reply at jboss.com
Wed Sep 29 07:15:33 EDT 2010

Michael Holtzman [http://community.jboss.org/people/michaelholtzman] created the discussion

"JBPM_PROCESSDEFINITION table 'losing' rows in Oracle"

To view the discussion, visit: http://community.jboss.org/message/563968#563968

Greetings. We are seeing some odd behavior with jBPM 3.1.2 and Oracle.

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.

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.

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?

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.


Mike Holtzman

Reply to this message by going to Community

Start a new discussion in jBPM at Community

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20100929/da892ea4/attachment.html 

More information about the jboss-user mailing list