Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1076696

Summary: Schema problems with DDL scripts
Product: [Retired] JBoss BPMS Platform 6 Reporter: jbride <jbride>
Component: BAMAssignee: Maciej Swiderski <mswiders>
Status: CLOSED CURRENTRELEASE QA Contact: Jan Hrcek <jhrcek>
Severity: high Docs Contact:
Priority: high    
Version: 6.0.0CC: kverlaen
Target Milestone: ER1   
Target Release: 6.0.2   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-08-06 19:51:18 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description jbride@redhat.com 2014-03-14 20:45:30 UTC 
OPTLOCK fields are missing for the BAMTaskSummary and TaskEvent tables in the mysql and postgresql DDL scripts included in the BPMS6.0.0GA installer.  The following commands correct the problems (mysql specific):

alter table BAMTaskSummary add column OPTLOCK integer;
alter table TaskEvent add column OPTLOCK integer;

jeff
Comment 4 Maciej Swiderski 2014-03-20 12:12:56 UTC 
DDL scripts regenerated

jbpm
master:
https://github.com/droolsjbpm/jbpm/commit/43b691033403bf91e57e09fffc06b2e88df35445

6.0.x:
https://github.com/droolsjbpm/jbpm/commit/2fa9f8a2bf13eee6d56f1c3cc17d283ea3179e90
Comment 5 Jan Hrcek 2014-05-05 09:01:31 UTC 
Ok, verified with BPMS 6.0.2 ER2 that updated scripts with missing fields added are present in jboss-bpms-brms-6.0.2.GA-redhat-2-supplementary-tools