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.
Fixed. (master) https://github.com/droolsjbpm/dashboard-builder/commit/66cceb36c070d3ca1fadbf612b5b609b813398f8 (6.3.x) https://github.com/droolsjbpm/dashboard-builder/commit/4f6dade3258d52572b09137b7e6408bc0d2a6282
Ok, now all dashbuilder tests are passing smoothly with DB2 10.5 Verified with BPM Suite 6.2.0 ER4