9:47 a.m.
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#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...