Bug 1035901 - invalid DDL scripts might cause various issues on data base
Summary: invalid DDL scripts might cause various issues on data base
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss BPMS Platform 6
Classification: Retired
Component: jBPM Core
Version: 6.0.0
Hardware: Unspecified
OS: Unspecified
high
unspecified
Target Milestone: ER6
: 6.0.0
Assignee: Maciej Swiderski
QA Contact: Jiri Svitak
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2013-11-28 19:05 UTC by Maciej Swiderski
Modified: 2015-06-02 01:35 UTC (History)
2 users (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2014-08-06 20:06:11 UTC
Type: Bug
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker JBPM-4177 0 Major Resolved ORA-01400: cannot insert NULL into ("JBPM"."TASK"."TASKID") 2014-02-06 15:49:13 UTC

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.
Note You need to log in before you can comment on or make changes to this bug.