Bug 1009443 - Quartz DDL for Oracle DB execution ends with error message: ORA-00942 table or view does not exist
Summary: Quartz DDL for Oracle DB execution ends with error message: ORA-00942 table o...
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
high
Target Milestone: ER6
: 6.0.0
Assignee: Ryan Zhang
QA Contact: Radovan Synek
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2013-09-18 13:06 UTC by Radovan Synek
Modified: 2014-08-06 20:08 UTC (History)
3 users (show)

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


Attachments (Terms of Use)

Description Radovan Synek 2013-09-18 13:06:41 UTC
Description of problem:
Quartz DDL for Oracle (Supplementary tools) starts with delete and drop statements without checking existence of tables being deleted/dropped => this results in error message stated in the summary.

Version-Release number of selected component (if applicable):
BRMS/BPMS 6.0.0.ER3

Comment 1 Radovan Synek 2013-09-23 08:54:09 UTC
PostgreSQL shows very similar error message, the reason is probably the same - DDL script starts with DROP table commands without any checking.

On the other hand, script for DB2 does not drop any table. Would it be possible to unite this behaviour of DDL scripts for all supported DBs ?

Comment 3 Maciej Swiderski 2013-10-15 08:34:45 UTC
removed all drop/delete statements from DDL scripts as they are intended to be used to create new schemas and drop/delete might impose a risk of accidentally removing valid data.

jbpm
master:
https://github.com/droolsjbpm/jbpm/commit/8d42d2872e9984ff5ad7c922bd501341d9f28105

6.0.x
https://github.com/droolsjbpm/jbpm/commit/8ec9469691980e4efc4e02e4505f17a44fbb54ad

Comment 4 Radovan Synek 2013-11-27 16:03:41 UTC
I cannot see any change here: dev138.mw.lab.eng.bos.redhat.com/candidate/bpms-6.0.0-ER5/jboss-bpms-brms-6.0.0-redhat-5-supplementary-tools.zip

DDL scripts still contain delete/drop statements, I am afraid the commits Maciej stated in comment 3 didn't get into the supplementary tools.

Comment 5 Maciej Swiderski 2013-11-29 11:10:39 UTC
reassigning to Ryan as it's available in the source so it's just matter of moving that into right location on product side.

please also include following bz that fixes invalid column names in some of the tables:
https://bugzilla.redhat.com/show_bug.cgi?id=1035901

Comment 6 Ryan Zhang 2013-11-29 12:00:13 UTC
Yes, product doesn't use the installer in community. 

Ok,  I will fix this in ER6.

Comment 8 Radovan Synek 2014-01-07 16:26:28 UTC
Verified on BPMS-6.0.0.ER7


Note You need to log in before you can comment on or make changes to this bug.