jBPM Installer issue on 6.1.0.CR1
hyder.husain Aug 6, 2014 5:07 PMI'm trying to get the default demo running using "ant install.demo" and "ant start.demo", but I'm getting the following exception in server.log. Is there a configuration that I've missed somewhere? I've also tried with version 6.0.1 and am facing the same issue.
14:49:38,457 INFO [org.jboss.dashboard.kpi.KPIInitialModule] (MSC service thread 1-8) Parsing KPI's XML file: WEB-INF/etc/appdata/initialData/jbpmKPIs.xml
14:49:39,899 ERROR [org.jboss.dashboard.dataset.sql.SQLDataSet] (MSC service thread 1-8) Error in load() SQLDataset. SQL = select total.processname, ifnull(total.instances,0) total, ifnull(active.instances_act,0) active, ifnull(completed.instances_compl,0) completed, ifnull(pending.instances_pend,0) pending, ifnull(suspended.instances_susp,0) suspended, ifnull(aborted.instances_abrt,0) aborted
from
(select pi.processinstanceid as pId, pi.processname as processname, count(*) as instances
from processinstancelog pi group by pi.processinstanceid,processname) as total
left outer join
(select pi.processinstanceid as pId, count(*) as instances_act
from processinstancelog pi
where pi.status=1 group by pi.processinstanceid) as active
on (total.pId=active.pId)
left outer join
(select pi.processinstanceid as pId, count(*) as instances_compl
from processinstancelog pi
where pi.status=2 group by pi.processinstanceid) as completed
on (total.pId=completed.pId)
left outer join
(select pi.processinstanceid as pId, count(*) as instances_pend
from processinstancelog pi
where pi.status=0 group by pi.processinstanceid) as pending
on (total.pId=pending.pId)
left outer join
(select pi.processinstanceid as pId, count(*) as instances_susp
from processinstancelog pi
where pi.status=4 group by pi.processinstanceid) as suspended
on (total.pId=suspended.pId)
left outer join
(select pi.processinstanceid as pId, count(*) as instances_abrt
from processinstancelog pi
where pi.status=3 group by pi.processinstanceid) as aborted
on (total.pId=aborted.pId)
where 1 = 1
order by processname: org.h2.jdbc.JdbcSQLException: Table "PROCESSINSTANCELOG" not found; SQL statement:
select total.processname, ifnull(total.instances,0) total, ifnull(active.instances_act,0) active, ifnull(completed.instances_compl,0) completed, ifnull(pending.instances_pend,0) pending, ifnull(suspended.instances_susp,0) suspended, ifnull(aborted.instances_abrt,0) aborted
from
(select pi.processinstanceid as pId, pi.processname as processname, count(*) as instances
from processinstancelog pi group by pi.processinstanceid,processname) as total
left outer join
(select pi.processinstanceid as pId, count(*) as instances_act
from processinstancelog pi
where pi.status=1 group by pi.processinstanceid) as active
on (total.pId=active.pId)
left outer join
(select pi.processinstanceid as pId, count(*) as instances_compl
from processinstancelog pi
where pi.status=2 group by pi.processinstanceid) as completed
on (total.pId=completed.pId)
left outer join
(select pi.processinstanceid as pId, count(*) as instances_pend
from processinstancelog pi
where pi.status=0 group by pi.processinstanceid) as pending
on (total.pId=pending.pId)
left outer join
(select pi.processinstanceid as pId, count(*) as instances_susp
from processinstancelog pi
where pi.status=4 group by pi.processinstanceid) as suspended
on (total.pId=suspended.pId)
left outer join
(select pi.processinstanceid as pId, count(*) as instances_abrt
from processinstancelog pi
where pi.status=3 group by pi.processinstanceid) as aborted
on (total.pId=aborted.pId)
where 1 = 1
order by processname [42102-161]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:169)
at org.h2.message.DbException.get(DbException.java:146)
at org.h2.command.Parser.readTableOrView(Parser.java:4749)
at org.h2.command.Parser.readTableFilter(Parser.java:1075)
at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1681)
at org.h2.command.Parser.parseSelectSimple(Parser.java:1788)
at org.h2.command.Parser.parseSelectSub(Parser.java:1675)
at org.h2.command.Parser.parseSelectUnion(Parser.java:1518)
at org.h2.command.Parser.readTableFilter(Parser.java:1017)
at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1681)
at org.h2.command.Parser.parseSelectSimple(Parser.java:1788)
at org.h2.command.Parser.parseSelectSub(Parser.java:1675)
at org.h2.command.Parser.parseSelectUnion(Parser.java:1518)
at org.h2.command.Parser.parseSelect(Parser.java:1506)
at org.h2.command.Parser.parsePrepared(Parser.java:405)
at org.h2.command.Parser.parse(Parser.java:279)
at org.h2.command.Parser.parse(Parser.java:251)
at org.h2.command.Parser.prepareCommand(Parser.java:217)
at org.h2.engine.Session.prepareLocal(Session.java:415)
at org.h2.engine.Session.prepareCommand(Session.java:364)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1119)
at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:71)
at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:635)
at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:677) [ironjacamar-jdbc-1.0.9.Final.jar:1.0.9.Final]
at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:663) [ironjacamar-jdbc-1.0.9.Final.jar:1.0.9.Final]
at org.jboss.jca.adapters.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:404) [ironjacamar-jdbc-1.0.9.Final.jar:1.0.9.Final]
at org.jboss.dashboard.dataset.sql.SQLStatement.getPreparedStatement(SQLStatement.java:132) [dashboard-provider-sql-6.1.0.CR1.jar:6.1.0.CR1]
at org.jboss.dashboard.dataset.sql.SQLDataSet.load(SQLDataSet.java:106) [dashboard-provider-sql-6.1.0.CR1.jar:6.1.0.CR1]
at org.jboss.dashboard.provider.sql.SQLDataLoader.load(SQLDataLoader.java:105) [dashboard-provider-sql-6.1.0.CR1.jar:6.1.0.CR1]
at org.jboss.dashboard.dataset.DataSetManagerImpl.loadDataSet(DataSetManagerImpl.java:109) [dashboard-provider-core-6.1.0.CR1.jar:6.1.0.CR1]
at org.jboss.dashboard.dataset.DataSetManagerImpl.getDataSetHolder(DataSetManagerImpl.java:83) [dashboard-provider-core-6.1.0.CR1.jar:6.1.0.CR1]
at org.jboss.dashboard.dataset.DataSetManagerImpl.getDataSet(DataSetManagerImpl.java:47) [dashboard-provider-core-6.1.0.CR1.jar:6.1.0.CR1]
at org.jboss.dashboard.dataset.DataSetManagerGlobal$Proxy$_$$_WeldClientProxy.getDataSet(DataSetManagerGlobal$Proxy$_$$_WeldClientProxy.java) [dashboard-provider-core-6.1.0.CR1.jar:6.1.0.CR1]
at org.jboss.dashboard.provider.DataProviderImpl.getDataSet(DataProviderImpl.java:213) [dashboard-provider-core-6.1.0.CR1.jar:6.1.0.CR1]
at org.jboss.dashboard.provider.DataProviderImpl.serializeDataProperties(DataProviderImpl.java:245) [dashboard-provider-core-6.1.0.CR1.jar:6.1.0.CR1]
at org.jboss.dashboard.provider.DataProviderImpl.serializeDataLoader(DataProviderImpl.java:235) [dashboard-provider-core-6.1.0.CR1.jar:6.1.0.CR1]
at org.jboss.dashboard.provider.DataProviderImpl.setDataLoader(DataProviderImpl.java:172) [dashboard-provider-core-6.1.0.CR1.jar:6.1.0.CR1]
at org.jboss.dashboard.export.ImportManagerImpl.parseProviders(ImportManagerImpl.java:278) [dashboard-displayer-core-6.1.0.CR1.jar:6.1.0.CR1]
at org.jboss.dashboard.export.ImportManagerImpl.parse(ImportManagerImpl.java:179) [dashboard-displayer-core-6.1.0.CR1.jar:6.1.0.CR1]
at org.jboss.dashboard.export.ImportManagerImpl.parse(ImportManagerImpl.java:169) [dashboard-displayer-core-6.1.0.CR1.jar:6.1.0.CR1]
at org.jboss.dashboard.export.ImportManagerImpl.parse(ImportManagerImpl.java:145) [dashboard-displayer-core-6.1.0.CR1.jar:6.1.0.CR1]
at org.jboss.dashboard.export.ImportManagerImpl$Proxy$_$$_WeldClientProxy.parse(ImportManagerImpl$Proxy$_$$_WeldClientProxy.java) [dashboard-displayer-core-6.1.0.CR1.jar:6.1.0.CR1]
at org.jboss.dashboard.kpi.KPIInitialModule.installOrUpgrade(KPIInitialModule.java:78) [dashboard-displayer-core-6.1.0.CR1.jar:6.1.0.CR1]
at org.jboss.dashboard.kpi.KPIInitialModule.install(KPIInitialModule.java:53) [dashboard-displayer-core-6.1.0.CR1.jar:6.1.0.CR1]
at org.jboss.dashboard.initialModule.InitialModule$1.txFragment(InitialModule.java:61) [dashboard-commons-6.1.0.CR1.jar:6.1.0.CR1]
at org.jboss.dashboard.database.hibernate.HibernateTransaction.executeFragment(HibernateTransaction.java:252) [dashboard-commons-6.1.0.CR1.jar:6.1.0.CR1]
at org.jboss.dashboard.database.hibernate.HibernateTxFragment.executeChild(HibernateTxFragment.java:194) [dashboard-commons-6.1.0.CR1.jar:6.1.0.CR1]
at org.jboss.dashboard.database.hibernate.HibernateTxFragment.execute(HibernateTxFragment.java:168) [dashboard-commons-6.1.0.CR1.jar:6.1.0.CR1]
at org.jboss.dashboard.initialModule.InitialModule.doTheInstall(InitialModule.java:59) [dashboard-commons-6.1.0.CR1.jar:6.1.0.CR1]
at org.jboss.dashboard.initialModule.InitialModulesManager$1.txFragment(InitialModulesManager.java:74) [dashboard-commons-6.1.0.CR1.jar:6.1.0.CR1]
at org.jboss.dashboard.database.hibernate.HibernateTransaction.executeFragment(HibernateTransaction.java:252) [dashboard-commons-6.1.0.CR1.jar:6.1.0.CR1]
at org.jboss.dashboard.database.hibernate.HibernateTxFragment.executeInitiator(HibernateTxFragment.java:179) [dashboard-commons-6.1.0.CR1.jar:6.1.0.CR1]
at org.jboss.dashboard.database.hibernate.HibernateTxFragment.execute(HibernateTxFragment.java:167) [dashboard-commons-6.1.0.CR1.jar:6.1.0.CR1]
at org.jboss.dashboard.initialModule.InitialModulesManager.start(InitialModulesManager.java:68) [dashboard-commons-6.1.0.CR1.jar:6.1.0.CR1]
at org.jboss.dashboard.initialModule.InitialModulesManager$Proxy$_$$_WeldClientProxy.start(InitialModulesManager$Proxy$_$$_WeldClientProxy.java) [dashboard-commons-6.1.0.CR1.jar:6.1.0.CR1]
at org.jboss.dashboard.annotation.StartableProcessor.wakeUpStartableBeans(StartableProcessor.java:52) [dashboard-commons-6.1.0.CR1.jar:6.1.0.CR1]
at org.jboss.dashboard.Application.start(Application.java:74) [dashboard-commons-6.1.0.CR1.jar:6.1.0.CR1]
at org.jboss.dashboard.Application$Proxy$_$$_WeldClientProxy.start(Application$Proxy$_$$_WeldClientProxy.java) [dashboard-commons-6.1.0.CR1.jar:6.1.0.CR1]
at org.jboss.dashboard.ui.controller.ControllerServlet.init(ControllerServlet.java:62) [dashboard-ui-core-6.1.0.CR1.jar:]
at javax.servlet.GenericServlet.init(GenericServlet.java:242) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1202) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1102) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3655) [jbossweb-7.0.13.Final.jar:]
at org.apache.catalina.core.StandardContext.start(StandardContext.java:3873) [jbossweb-7.0.13.Final.jar:]
at org.jboss.as.web.deployment.WebDeploymentService.start(WebDeploymentService.java:90) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]
at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811)
at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_67]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_67]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_67]