problem to start a taskinstance
galvino Jul 10, 2007 9:46 AMi am try to get tasklist of a user but i have the same error:
15:39:53,808 WARN [JDBCExceptionReporter] SQL Error: 1054, SQLState: 42S22
15:39:53,808 ERROR [JDBCExceptionReporter] Unknown column 'taskinstan0_.ISSIGNA
LING_' in 'field list'
15:39:53,808 DEBUG [JbpmContext] closing JbpmContext
15:39:53,808 DEBUG [Services] closing service 'persistence': org.jbpm.persisten
e.db.DbPersistenceService@1590164
15:39:53,808 DEBUG [DbPersistenceService] committing hibernate transaction
15:39:53,855 DEBUG [DbPersistenceService] closing hibernate session
15:39:53,855 DEBUG [Services] closing service 'authentication': org.jbpm.securi
y.authentication.DefaultAuthenticationService@13c2ac3
15:39:53,855 WARN [RequestProcessor] Unhandled Exception thrown: class org.hib
rnate.exception.SQLGrammarException
15:39:53,855 ERROR [[action]] Servlet.service() for servlet action threw except
on
org.hibernate.exception.SQLGrammarException: could not initialize a collection:
[org.jbpm.taskmgmt.exe.TaskMgmtInstance.taskInstances#9]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.
ava:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHel
er.java:43)
at org.hibernate.loader.Loader.loadCollection(Loader.java:1926)
at org.hibernate.loader.collection.CollectionLoader.initialize(Collecti
nLoader.java:36)
at org.hibernate.persister.collection.AbstractCollectionPersister.initi
lize(AbstractCollectionPersister.java:541)
at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onI
itializeCollection(DefaultInitializeCollectionEventListener.java:60)
at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java
1705)
at org.hibernate.collection.AbstractPersistentCollection.initialize(Abs
ractPersistentCollection.java:344)
at org.hibernate.collection.AbstractPersistentCollection.read(AbstractP
rsistentCollection.java:86)
at org.hibernate.collection.AbstractPersistentCollection.readSize(Abstr
ctPersistentCollection.java:109)
at org.hibernate.collection.PersistentSet.isEmpty(PersistentSet.java:12
)
at com.actions.StartProcessInstance.performAction(StartProcessInstance.
ava:52)
at com.actions.BaseAction.execute(BaseAction.java:19)
at org.apache.struts.action.RequestProcessor.processActionPerform(Reque
tProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.j
va:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:11
6)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(App
icationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Application
ilterChain.java:173)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDis
atcher.java:672)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(Applic
tionDispatcher.java:463)
at org.apache.catalina.core.ApplicationDispatcher.doForward(Application
ispatcher.java:398)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDi
patcher.java:301)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor
java:1085)
at org.apache.struts.action.RequestProcessor.processForwardConfig(Reque
tProcessor.java:398)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.j
va:241)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:11
6)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(App
icationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Application
ilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderF
lter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(App
icationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Application
ilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapper
alve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContext
alve.java:178)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securi
yAssociationValve.java:175)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextVal
e.java:74)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.
ava:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.
ava:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVa
ve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.ja
a:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.jav
:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.
rocessConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndp
int.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWo
kerThread.java:112)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Unknown column 'taskinstan0_.ISSIGNALLING_' i
'field list'
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3026)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.j
va:1137)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java
1231)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuer
(WrappedPreparedStatement.java:236)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java
186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(L
ader.java:224)
at org.hibernate.loader.Loader.loadCollection(Loader.java:1919)
... 47 more
15:39:53,870 ERROR [[action]] Servlet.service() for servlet action threw except
on
org.hibernate.exception.SQLGrammarException: could not initialize a collection:
[org.jbpm.taskmgmt.exe.TaskMgmtInstance.taskInstances#9]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.
ava:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHel
er.java:43)
at org.hibernate.loader.Loader.loadCollection(Loader.java:1926)
at org.hibernate.loader.collection.CollectionLoader.initialize(Collecti
nLoader.java:36)
at org.hibernate.persister.collection.AbstractCollectionPersister.initi
lize(AbstractCollectionPersister.java:541)
at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onI
itializeCollection(DefaultInitializeCollectionEventListener.java:60)
at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java
1705)
at org.hibernate.collection.AbstractPersistentCollection.initialize(Abs
ractPersistentCollection.java:344)
at org.hibernate.collection.AbstractPersistentCollection.read(AbstractP
rsistentCollection.java:86)
at org.hibernate.collection.AbstractPersistentCollection.readSize(Abstr
ctPersistentCollection.java:109)
at org.hibernate.collection.PersistentSet.isEmpty(PersistentSet.java:12
)
at com.actions.StartProcessInstance.performAction(StartProcessInstance.
ava:52)
at com.actions.BaseAction.execute(BaseAction.java:19)
at org.apache.struts.action.RequestProcessor.processActionPerform(Reque
tProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.j
va:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:11
6)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(App
icationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Application
ilterChain.java:173)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDis
atcher.java:672)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(Applic
tionDispatcher.java:463)
at org.apache.catalina.core.ApplicationDispatcher.doForward(Application
ispatcher.java:398)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDi
patcher.java:301)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor
java:1085)
at org.apache.struts.action.RequestProcessor.processForwardConfig(Reque
tProcessor.java:398)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.j
va:241)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:11
6)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(App
icationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Application
ilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderF
lter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(App
icationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Application
ilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapper
alve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContext
alve.java:178)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securi
yAssociationValve.java:175)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextVal
e.java:74)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.
ava:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.
ava:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVa
ve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.ja
a:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.jav
:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.
rocessConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndp
int.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWo
kerThread.java:112)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Unknown column 'taskinstan0_.ISSIGNALLING_' i
'field list'
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3026)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.j
va:1137)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java
1231)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuer
(WrappedPreparedStatement.java:236)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java
186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(L
ader.java:224)
at org.hibernate.loader.Loader.loadCollection(Loader.java:1919)
... 47 more
i do the simple execution :
jbpmcontext.getTaskList("ernie");
i dont understand this error.
firstly i thought it ISSIGNALLING field on my database,
please help me