3 Replies Latest reply on Dec 4, 2006 5:05 AM by misel

    starters-kit: unable to deploy selfbuild jbpm.sar

    Gregor Fellenz Newbie

      Hello

      I am using everything from the starters-kit. I want to play arround in the jbpm code.

      I can change the .jsp files and then

      ant -f build.deploy.xml undeploy.webapp deploy.webapp

      to move my changes to the server.

      But when I try to do the same with the sar, it crashes. Let me say, that at the moment I didn't change any line in the jbpm code except a trivial change in the home.jsp. Its as "vanilla" as it comes with the starters-kit.

      First I undeploy the war.

      Then I try
      ant -f build.deploy.xml undeploy.service.archive

      which says BUILD SUCCESSFULL, but the jbpm.sar directory still exists in the deploy dir.

      If I then try to
      ant -f build.deploy.xml deploy.service.archive

      JBoss is refusing and the BUILD FAILS

      Trying to install an already registered mbean: jboss.jbpm:name=DefaultJbpm,service=JbpmService


      I am pretty stuck here.

      When i deleted the jbpm.sar directory in deploy it by hand (as i would do with a war file) the server is not saying, that it was undeployed.

      So when i copied the newly build jbpm.sar.dir to the deploy:
      cp build/jbpm.sar.dir ../jbpm-server/server/jbpm/deploy/jbpm.sar -R

      JBoss ist saying:
      16:37:31,100 INFO [JbpmConfiguration] using jbpm configuration resource 'jbpm.cfg.xml'

      Aftewards, i try to deploy the war again:
      ant -f build.deploy.xml deploy.webapp

      And big stupid errors start apearing.... (I show then at the end)

      PLEASE, tell someone tell me how to build and deploy jbpm from the starters-kit correctly.

      i'm pretty sure that i set the environment variables and paths in build.properties correctly.

      Thanks in advance, Gregor Fellenz

      16:38:49,872 INFO [TomcatDeployer] deploy, ctxPath=/jbpm, warUrl=.../tmp/deploy/tmp26916jbpm.war/
      16:38:50,862 DEBUG [ApplicationFactory] New ApplicationFactory instance created
      16:38:50,866 ERROR [LocaleUtils] Locale name null or empty, ignoring
      16:38:59,758 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Node]; using defaults.
      16:39:00,021 WARN [EhCacheProvider] Could not find configuration [org.jbpm.instantiation.Delegation]; using defaults.
      16:39:01,149 WARN [EhCacheProvider] Could not find configuration [org.jbpm.taskmgmt.def.Task]; using defaults.
      16:39:01,616 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.ProcessDefinition]; using defaults.
      16:39:02,206 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.ExceptionHandler]; using defaults.
      16:39:02,225 WARN [EhCacheProvider] Could not find configuration [org.jbpm.module.def.ModuleDefinition]; using defaults.
      16:39:04,310 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Action]; using defaults.
      16:39:05,343 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Event]; using defaults.
      16:39:06,513 WARN [EhCacheProvider] Could not find configuration [org.jbpm.context.def.VariableAccess]; using defaults.
      16:39:09,817 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Transition]; using defaults.
      16:39:10,829 WARN [EhCacheProvider] Could not find configuration [org.jbpm.taskmgmt.def.TaskController]; using defaults.
      16:39:10,902 WARN [EhCacheProvider] Could not find configuration [org.jbpm.taskmgmt.def.TaskMgmtDefinition.tasks]; using defaults.
      16:39:10,905 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.node.ProcessState.variableAccesses]; using defaults.
      16:39:10,906 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.ProcessDefinition.events]; using defaults.
      16:39:10,906 WARN [EhCacheProvider] Could not find configuration [org.jbpm.taskmgmt.def.Swimlane.tasks]; using defaults.
      16:39:10,907 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Node.leavingTransitions]; using defaults.
      16:39:10,907 WARN [EhCacheProvider] Could not find configuration [org.jbpm.taskmgmt.def.TaskController.variableAccesses]; using defaults.
      16:39:10,908 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.ProcessDefinition.exceptionHandlers]; using defaults.
      16:39:10,909 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.node.Decision.decisionConditions]; using defaults.
      16:39:10,915 WARN [EhCacheProvider] Could not find configuration [org.jbpm.file.def.FileDefinition.processFiles]; using defaults.
      16:39:10,918 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.ProcessDefinition.actions]; using defaults.
      16:39:10,918 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Transition.exceptionHandlers]; using defaults.
      16:39:10,919 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.ProcessDefinition.nodes]; using defaults.
      16:39:10,919 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Node.arrivingTransitions]; using defaults.
      16:39:10,919 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.node.TaskNode.tasks]; using defaults.
      16:39:10,920 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.ProcessDefinition.definitions]; using defaults.
      16:39:10,923 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Event.actions]; using defaults.
      16:39:10,924 WARN [EhCacheProvider] Could not find configuration [org.jbpm.taskmgmt.def.Task.events]; using defaults.
      16:39:10,940 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Node.events]; using defaults.
      16:39:10,940 WARN [EhCacheProvider] Could not find configuration [org.jbpm.taskmgmt.def.TaskMgmtDefinition.swimlanes]; using defaults.
      16:39:10,941 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.SuperState.nodes]; using defaults.
      16:39:10,941 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.action.Script.variableAccesses]; using defaults.
      16:39:10,941 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.ExceptionHandler.actions]; using defaults.
      16:39:10,942 WARN [EhCacheProvider] Could not find configuration [org.jbpm.taskmgmt.def.Task.exceptionHandlers]; using defaults.
      16:39:10,942 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Node.exceptionHandlers]; using defaults.
      16:39:10,947 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Transition.events]; using defaults.
      16:39:14,132 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
      16:39:14,132 ERROR [JDBCExceptionReporter] Table not found in statement [select timer0_.ID_ as col_0_0_ from JBPM_TIMER timer0_ where (timer0_.EXCEPTION_ is null) and timer0_.ISSUSPENDED_<>1 order by timer0_.DUEDATE_ asc]
      16:39:14,133 ERROR [SchedulerSession] org.hibernate.exception.SQLGrammarException: could not execute query using iterate
      16:39:14,134 INFO [SchedulerThread] runtime exception while executing timers
      org.jbpm.JbpmException: couldn't find timers from the database
       at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.java:88)
       at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread.java:106)
       at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:70)
      Caused by: org.hibernate.exception.SQLGrammarException: could not execute query using iterate
       at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65)
       at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
       at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:406)
       at org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl.java:308)
       at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1111)
       at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:41)
       at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.java:82)
       ... 2 more
      Caused by: java.sql.SQLException: Table not found in statement [select timer0_.ID_ as col_0_0_ from JBPM_TIMER timer0_ where (timer0_.EXCEPTION_ is null) and timer0_.ISSUSPENDED_<>1 order by timer0_.DUEDATE_ asc]
       at org.hsqldb.jdbc.Util.throwError(Unknown Source)
       at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
       at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
       at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:439)
       at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:366)
       at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:105)
       at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
       at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:384)
       ... 6 more
      16:39:14,146 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
      16:39:14,147 ERROR [JDBCExceptionReporter] Table not found in statement [select message0_.ID_ as col_0_0_ from JBPM_MESSAGE message0_ where message0_.DESTINATION_=? and message0_.ISSUSPENDED_<>1 and (message0_.EXCEPTION_ is null)]
      16:39:14,147 ERROR [CommandExecutorThread] org.hibernate.exception.SQLGrammarException: could not execute query using iterate16:39:19,137 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
      16:39:19,138 ERROR [JDBCExceptionReporter] Table not found in statement [select timer0_.ID_ as col_0_0_ from JBPM_TIMER timer0_ where (timer0_.EXCEPTION_ is null) and timer0_.ISSUSPENDED_<>1 order by timer0_.DUEDATE_ asc]
      16:39:19,138 ERROR [SchedulerSession] org.hibernate.exception.SQLGrammarException: could not execute query using iterate
      16:39:19,138 INFO [SchedulerThread] runtime exception while executing timers
      org.jbpm.JbpmException: couldn't find timers from the database
       at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.java:88)
       at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread.java:106)
       at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:70)
      Caused by: org.hibernate.exception.SQLGrammarException: could not execute query using iterate
       at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65)
       at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
       at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:406)
       at org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl.java:308)
       at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1111)
       at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:41)
       at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.java:82)
       ... 2 more
      Caused by: java.sql.SQLException: Table not found in statement [select timer0_.ID_ as col_0_0_ from JBPM_TIMER timer0_ where (timer0_.EXCEPTION_ is null) and timer0_.ISSUSPENDED_<>1 order by timer0_.DUEDATE_ asc]
       at org.hsqldb.jdbc.Util.throwError(Unknown Source)
       at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
       at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
       at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:439)
       at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:366)
       at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:105)
       at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
       at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:384)
       ... 6 more
      16:39:19,149 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
      16:39:19,152 ERROR [JDBCExceptionReporter] Table not found in statement [select message0_.ID_ as col_0_0_ from JBPM_MESSAGE message0_ where message0_.DESTINATION_=? and message0_.ISSUSPENDED_<>1 and (message0_.EXCEPTION_ is null)]
      16:39:19,152 ERROR [CommandExecutorThread] org.hibernate.exception.SQLGrammarException: could not execute query using iterate16:39:24,142 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
      16:39:24,142 ERROR [JDBCExceptionReporter] Table not found in statement [select timer0_.ID_ as col_0_0_ from JBPM_TIMER timer0_ where (timer0_.EXCEPTION_ is null) and timer0_.ISSUSPENDED_<>1 order by timer0_.DUEDATE_ asc]
      16:39:24,143 ERROR [SchedulerSession] org.hibernate.exception.SQLGrammarException: could not execute query using iterate
      16:39:24,143 INFO [SchedulerThread] runtime exception while executing timers
      org.jbpm.JbpmException: couldn't find timers from the database
       at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.java:88)
       at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread.java:106)
       at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:70)
      Caused by: org.hibernate.exception.SQLGrammarException: could not execute query using iterate
       at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65)
       at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
       at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:406)
       at org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl.java:308)
       at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1111)
       at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:41)
       at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.java:82)
       ... 2 more
      Caused by: java.sql.SQLException: Table not found in statement [select timer0_.ID_ as col_0_0_ from JBPM_TIMER timer0_ where (timer0_.EXCEPTION_ is null) and timer0_.ISSUSPENDED_<>1 order by timer0_.DUEDATE_ asc]
       at org.hsqldb.jdbc.Util.throwError(Unknown Source)
       at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
       at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
       at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:439)
       at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:366)
       at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:105)
       at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
       at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:384)
       ... 6 more
      16:39:24,158 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
      16:39:24,158 ERROR [JDBCExceptionReporter] Table not found in statement [select message0_.ID_ as col_0_0_ from JBPM_MESSAGE message0_ where message0_.DESTINATION_=? and message0_.ISSUSPENDED_<>1 and (message0_.EXCEPTION_ is null)]
      16:39:24,158 ERROR [CommandExecutorThread] org.hibernate.exception.SQLGrammarException: could not execute query using iterate16:39:29,150 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
      16:39:29,150 ERROR [JDBCExceptionReporter] Table not found in statement [select timer0_.ID_ as col_0_0_ from JBPM_TIMER timer0_ where (timer0_.EXCEPTION_ is null) and timer0_.ISSUSPENDED_<>1 order by timer0_.DUEDATE_ asc]
      16:39:29,150 ERROR [SchedulerSession] org.hibernate.exception.SQLGrammarException: could not execute query using iterate
      16:39:29,151 INFO [SchedulerThread] runtime exception while executing timers
      org.jbpm.JbpmException: couldn't find timers from the database
       at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.java:88)
       at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread.java:106)
       at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:70)
      Caused by: org.hibernate.exception.SQLGrammarException: could not execute query using iterate
       at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65)
       at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
       at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:406)
       at org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl.java:308)
       at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1111)
       at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:41)
       at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.java:82)
       ... 2 more
      Caused by: java.sql.SQLException: Table not found in statement [select timer0_.ID_ as col_0_0_ from JBPM_TIMER timer0_ where (timer0_.EXCEPTION_ is null) and timer0_.ISSUSPENDED_<>1 order by timer0_.DUEDATE_ asc]
       at org.hsqldb.jdbc.Util.throwError(Unknown Source)
       at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
       at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
       at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:439)
       at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:366)
       at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:105)
       at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
       at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:384)
       ... 6 more
      16:39:29,166 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
      16:39:29,166 ERROR [JDBCExceptionReporter] Table not found in statement [select message0_.ID_ as col_0_0_ from JBPM_MESSAGE message0_ where message0_.DESTINATION_=? and message0_.ISSUSPENDED_<>1 and (message0_.EXCEPTION_ is null)]
      16:39:29,167 ERROR [CommandExecutorThread] org.hibernate.exception.SQLGrammarException: could not execute query using iterate16:39:34,170 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
      16:39:34,170 ERROR [JDBCExceptionReporter] Table not found in statement [select timer0_.ID_ as col_0_0_ from JBPM_TIMER timer0_ where (timer0_.EXCEPTION_ is null) and timer0_.ISSUSPENDED_<>1 order by timer0_.DUEDATE_ asc]
      16:39:34,170 ERROR [SchedulerSession] org.hibernate.exception.SQLGrammarException: could not execute query using iterate
      16:39:34,171 INFO [SchedulerThread] runtime exception while executing timers
      org.jbpm.JbpmException: couldn't find timers from the database
       at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.java:88)
       at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread.java:106)
       at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:70)
      Caused by: org.hibernate.exception.SQLGrammarException: could not execute query using iterate
       at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65)
       at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
       at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:406)
       at org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl.java:308)
       at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1111)
       at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:41)
       at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.java:82)
       ... 2 more
      Caused by: java.sql.SQLException: Table not found in statement [select timer0_.ID_ as col_0_0_ from JBPM_TIMER timer0_ where (timer0_.EXCEPTION_ is null) and timer0_.ISSUSPENDED_<>1 order by timer0_.DUEDATE_ asc]
       at org.hsqldb.jdbc.Util.throwError(Unknown Source)
       at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
       at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
       at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:439)
       at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:366)
       at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:105)
       at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
       at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:384)
       ... 6 more
      16:39:34,174 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
      16:39:34,174 ERROR [JDBCExceptionReporter] Table not found in statement [select message0_.ID_ as col_0_0_ from JBPM_MESSAGE message0_ where message0_.DESTINATION_=? and message0_.ISSUSPENDED_<>1 and (message0_.EXCEPTION_ is null)]
      16:39:34,174 ERROR [CommandExecutorThread] org.hibernate.exception.SQLGrammarException: could not execute query using iterate16:39:39,174 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
      16:39:39,175 ERROR [JDBCExceptionReporter] Table not found in statement [select timer0_.ID_ as col_0_0_ from JBPM_TIMER timer0_ where (timer0_.EXCEPTION_ is null) and timer0_.ISSUSPENDED_<>1 order by timer0_.DUEDATE_ asc]
      16:39:39,175 ERROR [SchedulerSession] org.hibernate.exception.SQLGrammarException: could not execute query using iterate
      16:39:39,176 INFO [SchedulerThread] runtime exception while executing timers
      org.jbpm.JbpmException: couldn't find timers from the database
       at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.java:88)
       at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread.java:106)
       at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:70)
      Caused by: org.hibernate.exception.SQLGrammarException: could not execute query using iterate
       at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65)
       at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
       at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:406)
       at org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl.java:308)
       at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1111)
       at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:41)
       at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.java:82)
       ... 2 more
      Caused by: java.sql.SQLException: Table not found in statement [select timer0_.ID_ as col_0_0_ from JBPM_TIMER timer0_ where (timer0_.EXCEPTION_ is null) and timer0_.ISSUSPENDED_<>1 order by timer0_.DUEDATE_ asc]
       at org.hsqldb.jdbc.Util.throwError(Unknown Source)
       at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
       at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
       at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:439)
       at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:366)
       at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:105)
       at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
       at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:384)
       ... 6 more
      16:39:39,178 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
      16:39:39,178 ERROR [JDBCExceptionReporter] Table not found in statement [select message0_.ID_ as col_0_0_ from JBPM_MESSAGE message0_ where message0_.DESTINATION_=? and message0_.ISSUSPENDED_<>1 and (message0_.EXCEPTION_ is null)]
      16:39:39,179 ERROR [CommandExecutorThread] org.hibernate.exception.SQLGrammarException: could not execute query using iterate16:39:44,179 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
      16:39:44,179 ERROR [JDBCExceptionReporter] Table not found in statement [select timer0_.ID_ as col_0_0_ from JBPM_TIMER timer0_ where (timer0_.EXCEPTION_ is null) and timer0_.ISSUSPENDED_<>1 order by timer0_.DUEDATE_ asc]
      16:39:44,179 ERROR [SchedulerSession] org.hibernate.exception.SQLGrammarException: could not execute query using iterate
      16:39:44,180 INFO [SchedulerThread] runtime exception while executing timers
      org.jbpm.JbpmException: couldn't find timers from the database
       at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.java:88)
       at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread.java:106)
       at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:70)
      Caused by: org.hibernate.exception.SQLGrammarException: could not execute query using iterate
       at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65)
       at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
       at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:406)
       at org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl.java:308)
       at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1111)
       at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:41)
       at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.java:82)
       ... 2 more
      Caused by: java.sql.SQLException: Table not found in statement [select timer0_.ID_ as col_0_0_ from JBPM_TIMER timer0_ where (timer0_.EXCEPTION_ is null) and timer0_.ISSUSPENDED_<>1 order by timer0_.DUEDATE_ asc]
       at org.hsqldb.jdbc.Util.throwError(Unknown Source)
       at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
       at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
       at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:439)
       at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:366)
       at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:105)
       at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
       at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:384)
       ... 6 more
      16:39:44,182 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
      16:39:44,183 ERROR [JDBCExceptionReporter] Table not found in statement [select message0_.ID_ as col_0_0_ from JBPM_MESSAGE message0_ where message0_.DESTINATION_=? and message0_.ISSUSPENDED_<>1 and (message0_.EXCEPTION_ is null)]
      16:39:44,183 ERROR [CommandExecutorThread] org.hibernate.exception.SQLGrammarException: could not execu