[jboss-user] [JBoss jBPM] - starters-kit: unable to deploy selfbuild jbpm.sar

gf_public do-not-reply at jboss.com
Wed Aug 16 10:47:02 EDT 2006


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
anonymous wrote : 
  | 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


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3965492#3965492

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3965492



More information about the jboss-user mailing list