Bug 1231014 - When migrate BPMS from 6.0.1 to 6.1.0, Deployment Process & Task Dashboard will failed
Summary: When migrate BPMS from 6.0.1 to 6.1.0, Deployment Process & Task Dashboard w...
Keywords:
Status: CLOSED EOL
Alias: None
Product: JBoss BPMS Platform 6
Classification: Retired
Component: BAM
Version: 6.1.0
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ER4
: 6.2.0
Assignee: David Gutierrez
QA Contact: Gui Jospin
URL:
Whiteboard:
: 1213902 (view as bug list)
Depends On:
Blocks: 1213906
TreeView+ depends on / blocked
 
Reported: 2015-06-12 02:34 UTC by cory
Modified: 2020-03-27 20:04 UTC (History)
5 users (show)

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

Attachments (Terms of Use)

Description cory 2015-06-12 02:34:59 UTC 
Description of problem:
When migrate BPMS from 6.0.1 to 6.1.0,  Deployment Process & Task Dashboard will failed 
Error log Like this:
ERROR [org.jboss.dashboard.dataset.sql.SQLDataSet] (ServerService Thread Pool -- 77) Error in load() SQLDataset. SQL = select processname, coalesce(instances,0) total, coalesce(instances_act,0) active, coalesce(instances_compl,0) completed, coalesce(instances_pend,0) pending, coalesce(instances_susp,0) suspended, coalesce(instances_abrt,0) aborted
        from
        (select processinstanceid, processname, count(*) as instances
        from processinstancelog
        where 1 = 1
        and 1 = 1
        and 1 = 1
        and 1 = 1
        and 1 = 1
        group by processinstanceid,processname) as total
        left outer join
        (select processinstanceid, count(*) as instances_act
        from processinstancelog
        where status=1
        and 1 = 1
        and 1 = 1
        and 1 = 1
        and 1 = 1
        and 1 = 1
        group by processinstanceid) as active
        on (total.processinstanceid=active.processinstanceid)
        left outer join
        (select processinstanceid, count(*) as instances_compl
        from processinstancelog
        where status=2
        and 1 = 1
        and 1 = 1
        and 1 = 1
        and 1 = 1
        and 1 = 1
        group by processinstanceid) as completed
        on (total.processinstanceid=completed.processinstanceid)
        left outer join
        (select processinstanceid, count(*) as instances_pend
        from processinstancelog
        where status=0
        and 1 = 1
        and 1 = 1
        and 1 = 1
        and 1 = 1
        and 1 = 1
        group by processinstanceid) as pending
        on (total.processinstanceid=pending.processinstanceid)
        left outer join
        (select processinstanceid, count(*) as instances_susp
        from processinstancelog
        where status=4
        and 1 = 1
        and 1 = 1
        and 1 = 1
        and 1 = 1
        and 1 = 1
        group by processinstanceid) as suspended
        on (total.processinstanceid=suspended.processinstanceid)
        left outer join
        (select processinstanceid, count(*) as instances_abrt
        from processinstancelog
        where status=3
        and 1 = 1
        and 1 = 1
        and 1 = 1
        and 1 = 1
        and 1 = 1
        group by processinstanceid) as aborted
        on (total.processinstanceid=aborted.processinstanceid)
        order by processname
      : com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jbpm.processinstancelog' doesn't exist
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [rt.jar:1.7.0_51]
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) [rt.jar:1.7.0_51]
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [rt.jar:1.7.0_51]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526) [rt.jar:1.7.0_51]
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2318)
	at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462) [ironjacamar-jdbc-1.0.31.Final-redhat-1.jar:1.0.31.Final-redhat-1]
	at org.jboss.dashboard.dataset.sql.SQLDataSet.load(SQLDataSet.java:116) [dashboard-provider-sql-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.provider.sql.SQLDataLoader.load(SQLDataLoader.java:105) [dashboard-provider-sql-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.dataset.DataSetManagerImpl.loadDataSet(DataSetManagerImpl.java:109) [dashboard-provider-core-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.dataset.DataSetManagerImpl.getDataSetHolder(DataSetManagerImpl.java:83) [dashboard-provider-core-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.dataset.DataSetManagerImpl.getDataSet(DataSetManagerImpl.java:47) [dashboard-provider-core-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.dataset.DataSetManagerGlobal$Proxy$_$$_WeldClientProxy.getDataSet(DataSetManagerGlobal$Proxy$_$$_WeldClientProxy.java) [dashboard-provider-core-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.provider.DataProviderImpl.getDataSet(DataProviderImpl.java:213) [dashboard-provider-core-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.provider.DataProviderImpl.serializeDataProperties(DataProviderImpl.java:245) [dashboard-provider-core-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.provider.DataProviderImpl.serializeDataLoader(DataProviderImpl.java:235) [dashboard-provider-core-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.provider.DataProviderImpl.setDataLoader(DataProviderImpl.java:172) [dashboard-provider-core-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.export.ImportManagerImpl.parseProviders(ImportManagerImpl.java:254) [dashboard-displayer-core-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.export.ImportManagerImpl.parse(ImportManagerImpl.java:154) [dashboard-displayer-core-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.export.ImportManagerImpl.parse(ImportManagerImpl.java:144) [dashboard-displayer-core-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.export.ImportManagerImpl.parse(ImportManagerImpl.java:120) [dashboard-displayer-core-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.export.ImportManagerImpl$Proxy$_$$_WeldClientProxy.parse(ImportManagerImpl$Proxy$_$$_WeldClientProxy.java) [dashboard-displayer-core-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.kpi.KPIInitialModule._install(KPIInitialModule.java:78) [dashboard-displayer-core-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.kpi.KPIInitialModule.install(KPIInitialModule.java:53) [dashboard-displayer-core-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.initialModule.InitialModule$1.txFragment(InitialModule.java:61) [dashboard-commons-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.database.hibernate.HibernateTransaction.executeFragment(HibernateTransaction.java:252) [dashboard-commons-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.database.hibernate.HibernateTxFragment.executeChild(HibernateTxFragment.java:194) [dashboard-commons-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.database.hibernate.HibernateTxFragment.execute(HibernateTxFragment.java:168) [dashboard-commons-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.initialModule.InitialModule.doTheInstall(InitialModule.java:59) [dashboard-commons-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.initialModule.InitialModulesManager$1.txFragment(InitialModulesManager.java:74) [dashboard-commons-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.database.hibernate.HibernateTransaction.executeFragment(HibernateTransaction.java:252) [dashboard-commons-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.database.hibernate.HibernateTxFragment.executeInitiator(HibernateTxFragment.java:179) [dashboard-commons-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.database.hibernate.HibernateTxFragment.execute(HibernateTxFragment.java:167) [dashboard-commons-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.initialModule.InitialModulesManager.start(InitialModulesManager.java:68) [dashboard-commons-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.initialModule.InitialModulesManager$Proxy$_$$_WeldClientProxy.start(InitialModulesManager$Proxy$_$$_WeldClientProxy.java) [dashboard-commons-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.annotation.StartableProcessor.wakeUpStartableBeans(StartableProcessor.java:52) [dashboard-commons-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.Application.start(Application.java:74) [dashboard-commons-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.Application$Proxy$_$$_WeldClientProxy.start(Application$Proxy$_$$_WeldClientProxy.java) [dashboard-commons-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.ui.controller.ControllerServlet.init(ControllerServlet.java:62) [dashboard-ui-core-6.2.0.Final-redhat-4.jar:]
	at javax.servlet.GenericServlet.init(GenericServlet.java:242) [jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-2.jar:1.0.2.Final-redhat-2]
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1194) [jbossweb-7.5.7.Final-redhat-1.jar:7.5.7.Final-redhat-1]
	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1100) [jbossweb-7.5.7.Final-redhat-1.jar:7.5.7.Final-redhat-1]
	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3593) [jbossweb-7.5.7.Final-redhat-1.jar:7.5.7.Final-redhat-1]
	at org.apache.catalina.core.StandardContext.start(StandardContext.java:3802) [jbossweb-7.5.7.Final-redhat-1.jar:7.5.7.Final-redhat-1]
	at org.jboss.as.web.deployment.WebDeploymentService.doStart(WebDeploymentService.java:163) [jboss-as-web-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
	at org.jboss.as.web.deployment.WebDeploymentService.access$000(WebDeploymentService.java:61) [jboss-as-web-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
	at org.jboss.as.web.deployment.WebDeploymentService$1.run(WebDeploymentService.java:96) [jboss-as-web-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) [rt.jar:1.7.0_51]
	at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_51]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_51]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_51]
	at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_51]
	at org.jboss.threads.JBossThread.run(JBossThread.java:122)

14:04:03,830 ERROR [org.jboss.dashboard.provider.DataProviderImpl] (ServerService Thread Pool -- 77) Error serializing data provider: null: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jbpm.processinstancelog' doesn't exist
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [rt.jar:1.7.0_51]
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) [rt.jar:1.7.0_51]
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [rt.jar:1.7.0_51]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526) [rt.jar:1.7.0_51]
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2318)
	at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462) [ironjacamar-jdbc-1.0.31.Final-redhat-1.jar:1.0.31.Final-redhat-1]
	at org.jboss.dashboard.dataset.sql.SQLDataSet.load(SQLDataSet.java:116) [dashboard-provider-sql-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.provider.sql.SQLDataLoader.load(SQLDataLoader.java:105) [dashboard-provider-sql-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.dataset.DataSetManagerImpl.loadDataSet(DataSetManagerImpl.java:109) [dashboard-provider-core-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.dataset.DataSetManagerImpl.getDataSetHolder(DataSetManagerImpl.java:83) [dashboard-provider-core-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.dataset.DataSetManagerImpl.getDataSet(DataSetManagerImpl.java:47) [dashboard-provider-core-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.dataset.DataSetManagerGlobal$Proxy$_$$_WeldClientProxy.getDataSet(DataSetManagerGlobal$Proxy$_$$_WeldClientProxy.java) [dashboard-provider-core-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.provider.DataProviderImpl.getDataSet(DataProviderImpl.java:213) [dashboard-provider-core-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.provider.DataProviderImpl.serializeDataProperties(DataProviderImpl.java:245) [dashboard-provider-core-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.provider.DataProviderImpl.serializeDataLoader(DataProviderImpl.java:235) [dashboard-provider-core-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.provider.DataProviderImpl.setDataLoader(DataProviderImpl.java:172) [dashboard-provider-core-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.export.ImportManagerImpl.parseProviders(ImportManagerImpl.java:254) [dashboard-displayer-core-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.export.ImportManagerImpl.parse(ImportManagerImpl.java:154) [dashboard-displayer-core-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.export.ImportManagerImpl.parse(ImportManagerImpl.java:144) [dashboard-displayer-core-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.export.ImportManagerImpl.parse(ImportManagerImpl.java:120) [dashboard-displayer-core-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.export.ImportManagerImpl$Proxy$_$$_WeldClientProxy.parse(ImportManagerImpl$Proxy$_$$_WeldClientProxy.java) [dashboard-displayer-core-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.kpi.KPIInitialModule._install(KPIInitialModule.java:78) [dashboard-displayer-core-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.kpi.KPIInitialModule.install(KPIInitialModule.java:53) [dashboard-displayer-core-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.initialModule.InitialModule$1.txFragment(InitialModule.java:61) [dashboard-commons-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.database.hibernate.HibernateTransaction.executeFragment(HibernateTransaction.java:252) [dashboard-commons-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.database.hibernate.HibernateTxFragment.executeChild(HibernateTxFragment.java:194) [dashboard-commons-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.database.hibernate.HibernateTxFragment.execute(HibernateTxFragment.java:168) [dashboard-commons-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.initialModule.InitialModule.doTheInstall(InitialModule.java:59) [dashboard-commons-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.initialModule.InitialModulesManager$1.txFragment(InitialModulesManager.java:74) [dashboard-commons-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.database.hibernate.HibernateTransaction.executeFragment(HibernateTransaction.java:252) [dashboard-commons-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.database.hibernate.HibernateTxFragment.executeInitiator(HibernateTxFragment.java:179) [dashboard-commons-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.database.hibernate.HibernateTxFragment.execute(HibernateTxFragment.java:167) [dashboard-commons-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.initialModule.InitialModulesManager.start(InitialModulesManager.java:68) [dashboard-commons-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.initialModule.InitialModulesManager$Proxy$_$$_WeldClientProxy.start(InitialModulesManager$Proxy$_$$_WeldClientProxy.java) [dashboard-commons-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.annotation.StartableProcessor.wakeUpStartableBeans(StartableProcessor.java:52) [dashboard-commons-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.Application.start(Application.java:74) [dashboard-commons-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.Application$Proxy$_$$_WeldClientProxy.start(Application$Proxy$_$$_WeldClientProxy.java) [dashboard-commons-6.2.0.Final-redhat-4.jar:6.2.0.Final-redhat-4]
	at org.jboss.dashboard.ui.controller.ControllerServlet.init(ControllerServlet.java:62) [dashboard-ui-core-6.2.0.Final-redhat-4.jar:]
	at javax.servlet.GenericServlet.init(GenericServlet.java:242) [jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-2.jar:1.0.2.Final-redhat-2]
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1194) [jbossweb-7.5.7.Final-redhat-1.jar:7.5.7.Final-redhat-1]
	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1100) [jbossweb-7.5.7.Final-redhat-1.jar:7.5.7.Final-redhat-1]
	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3593) [jbossweb-7.5.7.Final-redhat-1.jar:7.5.7.Final-redhat-1]
	at org.apache.catalina.core.StandardContext.start(StandardContext.java:3802) [jbossweb-7.5.7.Final-redhat-1.jar:7.5.7.Final-redhat-1]
	at org.jboss.as.web.deployment.WebDeploymentService.doStart(WebDeploymentService.java:163) [jboss-as-web-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
	at org.jboss.as.web.deployment.WebDeploymentService.access$000(WebDeploymentService.java:61) [jboss-as-web-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
	at org.jboss.as.web.deployment.WebDeploymentService$1.run(WebDeploymentService.java:96) [jboss-as-web-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) [rt.jar:1.7.0_51]
	at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_51]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_51]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_51]
	at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_51]
	at org.jboss.threads.JBossThread.run(JBossThread.java:122)

Version-Release number of selected component (if applicable):


How reproducible:


Steps to Reproduce:
1. use old server backup  data, include 
   database
   maven repo(kie.maven.settings.custom): .m2
   bpms repo (org.uberfire.metadata.index.dir) :repo
   git server data(org.uberfire.nio.git.dir).niogit
   and .index 
2. start server
3. run sql script 
  update Task t set name = (select shorttext from I18NText where task_names_id = t.id);
update Task t set subject = (select shorttext from I18NText where task_subjects_id = t.id);
update Task t set description = (select shorttext from I18NText where task_descriptions_id = t.id);
INSERT INTO AuditTaskImpl (activationTime, actualOwner, createdBy, createdOn, deploymentId, description, dueDate, name, parentId, priority, processId, processInstanceId, processSessionId, status, taskId)
SELECT activationTime, actualOwner_id, createdBy_id, createdOn, deploymentId, description, expirationTime, name, parentId, priority,processId, processInstanc

Actual results:
Process & Task Dashboard can not work.

Expected results:

Process & Task Dashboard be work.
Additional info:

This issue belong to Mysql case sensitive.
Because of, in jbpmKPI_v2.kpis, we use lowercase of tables name.
Like, we use processinstancelog instead of ProcessInstanceLog.
If i change it, it will be ok.
Comment 1 cory 2015-06-12 02:38:03 UTC 
jbpmKPI_v2.kpis location in here /dashbuilder/WEB_INFO/deployments/ jbpmKPI_v2.kpis
Comment 3 Kris Verlaenen 2015-06-12 07:52:27 UTC 
I'm not sure I understand why this is related to migration?  If MySQL has issues with lowercase as you suggest, shouldn't it be a problem for new installations as well?
Comment 4 cory 2015-06-12 08:33:57 UTC 
(In reply to Kris Verlaenen from comment #3)
> I'm not sure I understand why this is related to migration?  If MySQL has
> issues with lowercase as you suggest, shouldn't it be a problem for new
> installations as well?

 our old db is case sensitive , if use lowercase tables name, system will throw these exception.
If we use new BPMS 6.1 create new database, new database don't have case sensitive.  So this code will be work.
Comment 5 Kris Verlaenen 2015-06-30 18:00:19 UTC 
See https://github.com/droolsjbpm/jbpm-dashboard/pull/6
Comment 6 David Gutierrez 2015-09-23 14:54:38 UTC 
Fixed

(master) https://github.com/droolsjbpm/jbpm-dashboard/commit/f8f1823250f6db86242d2f7e8b7d847398ce7dfc

(6.3.x) https://github.com/droolsjbpm/jbpm-dashboard/commit/8098d2227e3cd44e9650e1c4609e6a7bf02682c9
Comment 7 David Gutierrez 2015-09-23 14:58:36 UTC 
*** Bug 1213902 has been marked as a duplicate of this bug. ***
Comment 8 Jan Hrcek 2015-10-26 13:04:17 UTC 
Tested this with MySQL database with case sensitive column names and it works fine now.
Note You need to log in before you can comment on or make changes to this bug.