Bug 1035901

Summary: invalid DDL scripts might cause various issues on data base
Product: [Retired] JBoss BPMS Platform 6 Reporter: Maciej Swiderski <mswiders>
Component: jBPM CoreAssignee: Maciej Swiderski <mswiders>
Status: CLOSED CURRENTRELEASE QA Contact: Jiri Svitak <jsvitak>
Severity: unspecified Docs Contact:
Priority: high    
Version: 6.0.0CC: kverlaen, mbaluch
Target Milestone: ER6   
Target Release: 6.0.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-08-06 20:06:11 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:

Description Maciej Swiderski 2013-11-28 19:05:47 UTC 
Description of problem:
this is to back port jira issue https://issues.jboss.org/browse/JBPM-4177 which was causing ORA-01400 due to incorrect DDL scripts

Version-Release number of selected component (if applicable):


How reproducible:
when data base schema is created with current 6.0.0.Final or ER5 DDL scripts some primary key columns have wrong names and thus failing with various errors that id was not generated.

Steps to Reproduce:
1.
2.
3.

Actual results:


Expected results:


Additional info:
Comment 1 Maciej Swiderski 2013-11-28 19:06:47 UTC 
already fixed on master, awaiting acks

jbpm
master:
https://github.com/droolsjbpm/jbpm/commit/f86aee4e38c5e9fdcaa9a41b37fad2c8a13756b5
Comment 2 JBoss JIRA Server 2013-11-28 19:07:51 UTC 
Maciej Swiderski <swiderski.maciej> updated the status of jira JBPM-4177 to Resolved
Comment 3 JBoss JIRA Server 2013-11-28 19:07:51 UTC 
Maciej Swiderski <swiderski.maciej> made a comment on jira JBPM-4177

thanks for checking and reporting back it works.

DDL scripts have been fixed on master to reflect correct column names.
Comment 4 Maciej Swiderski 2013-11-28 20:02:48 UTC 
backported to 6.0.x:
https://github.com/droolsjbpm/jbpm/commit/38fcaedb6cb40f4014fa8d261368e3593e4269f8
Comment 5 Jiri Svitak 2014-01-06 15:59:37 UTC 
Verified on Oracle 11g R1 in BPMS 6 ER7.