Bug 1267465 - Dashbuilder fails to deploy on IBM DB2 10.5
Summary: Dashbuilder fails to deploy on IBM DB2 10.5
Keywords:
Status: CLOSED EOL
Alias: None
Product: JBoss BPMS Platform 6
Classification: Retired
Component: BAM
Version: 6.2.0
Hardware: Unspecified
OS: Unspecified
unspecified
urgent
Target Milestone: ER4
: 6.2.0
Assignee: David Gutierrez
QA Contact: Gui Jospin
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2015-09-30 06:41 UTC by Jan Hrcek
Modified: 2020-03-27 20:11 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2020-03-27 20:11:53 UTC
Type: Bug
Embargoed:


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

Description Jan Hrcek 2015-09-30 06:41:21 UTC
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 08:37:49 UTC
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.