Bug 1267465 - Dashbuilder fails to deploy on IBM DB2 10.5
Dashbuilder fails to deploy on IBM DB2 10.5
Status: VERIFIED
Product: JBoss BPMS Platform 6
Classification: JBoss
Component: BAM (Show other bugs)
6.2.0
Unspecified Unspecified
unspecified Severity urgent
: ER4
: 6.2.0
Assigned To: David Gutierrez
Jan Hrcek
: TestBlocker
Depends On:
Blocks:
  Show dependency treegraph
 
Reported: 2015-09-30 02:41 EDT by Jan Hrcek
Modified: 2015-10-15 04:37 EDT (History)
0 users

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed:
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)
Server.log (search for "Error executing CREATE TABLE dashb_allowed_panel") (247.61 KB, text/plain)
2015-09-30 02:41 EDT, Jan Hrcek
no flags Details

  None (edit)
Description Jan Hrcek 2015-09-30 02:41:21 EDT
Created attachment 1078539 [details]
Server.log (search for "Error executing CREATE TABLE dashb_allowed_panel")

Description of problem:
The following error appears in server.log when trying to deploy business-central + (old) dashbuilder with IBM DB2 10.5 as underlying database.

Previous versions of dashbuilder (in BPM Suite 6.1.x) was tested with IBM DB2 10.1 and the current version of dashbuilder STILL WORKS FINE WITH 10.1

But after I upgraded the tests to run against latest DB2 version 10.5 and the application fails to deploy on this version.
------------------------------------------------------------------
11:52:19,879 INFO  [org.jboss.dashboard.database.hibernate.HibernateInitializer] (ServerService Thread Pool -- 67) The underlying database is: db2
11:52:20,249 INFO  [org.hibernate.dialect.Dialect] (ServerService Thread Pool -- 67) HHH000400: Using dialect: org.hibernate.dialect.DB2Dialect
11:52:20,294 INFO  [org.hibernate.engine.transaction.internal.TransactionFactoryInitiator] (ServerService Thread Pool -- 67) HHH000399: Using default transaction strategy (direct JDBC transactions)
11:52:20,296 INFO  [org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory] (ServerService Thread Pool -- 67) HHH000397: Using ASTQueryTranslatorFactory
11:52:20,813 WARN  [org.jboss.dashboard.database.DatabaseAutoSynchronizer] (ServerService Thread Pool -- 67) Running file 1-create-db2.sql
11:52:23,539 INFO  [org.uberfire.ext.metadata.io.BatchIndex] (EJB default - 1) Completed indexing of default://master@datasets/
11:52:40,167 ERROR [org.jboss.dashboard.database.DatabaseAutoSynchronizer] (ServerService Thread Pool -- 67) Error executing CREATE TABLE dashb_allowed_panel (
   id_workspace VARCHAR(40) NOT NULL,
   id_panel_provider VARCHAR(3000) NOT NULL,
   CONSTRAINT dashb_workspace_provider_allowed_pkey PRIMARY KEY(id_workspace, id_panel_provider),
   CONSTRAINT fk_workspace_id FOREIGN KEY (id_workspace)
   REFERENCES dashb_workspace(id_workspace)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
): DB2 SQL Error: SQLCODE=-613, SQLSTATE=54008, SQLERRMC=DASHB_WORKSPACE_PROVIDER_ALLOWED_PKEY, DRIVER=4.17.29
------------------------------------------------------------------

Version-Release number of selected component (if applicable):
BPM Suite 6.2 ER3

How reproducible:
Always

Steps to Reproduce:
1. Configure business central to use DB2 v 10.5 as the underlying data source

Actual results:
Fail when running 1-create-db2.sql

Expected results:
No errors on deployment

Additional info:
I'm not sure if this should be a blocker, since it's working with older versions of DB2, but setting blocker? for consideration.
Comment 2 Jan Hrcek 2015-10-15 04:37:49 EDT
Ok, now all dashbuilder tests are passing smoothly with DB2 10.5
Verified with BPM Suite 6.2.0 ER4

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