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.