[jboss-user] [JBoss jBPM] - problem to start a taskinstance

galvino do-not-reply at jboss.com
Tue Jul 10 09:46:14 EDT 2007


i am try to get tasklist of a user but i have the same error:

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

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

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



More information about the jboss-user mailing list