jBPM Installer issue on 6.1.0.CR1

[hyder.husain]

I'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]

[swiderski.maciej]

it's because of deployment order of the war file that might be different as dashbuilder requires jbpm db to be already created before it can boot so jbpm console should be deployed first. When running on Java 1.7 that usually works but you could try to redeploy the dashbuilder after server startup (just changed the marked frile for dashbuilder to .dodeploy) and that should solve the issue.

HTH

[badtea]

Are you working in Windows?  I have a coworker who tried to install on Windows and could not get any version to work.  He resolved the problem by changing the database to MySQL, as described in the documentation here: Chapter 3. jBPM Installer.  That might help in your situation, because your error message appears to be related to the database.

HTH

[hyder.husain]

Thanks Maciej - I'll try it out.