5 Replies Latest reply on Jul 12, 2007 8:25 AM by Ronald van Kuijk

    problem to start a taskinstance

    clause Mbacky Newbie

      i 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

        • 1. Re: problem to start a taskinstance
          Koen Aers Master

          Please list your version array and provide some more info on what you are trying to achieve. It looks like your client program runs against a jbpm database from another version.

          Regards,
          Koen

          • 2. Re: problem to start a taskinstance
            clause Mbacky Newbie

            hi, thanks to response to my first post.

            iam using


            jbpm-3.1.4
            jboss-4.0.4.GA (download with jems-installer-1.2.0.GA.jar)
            mysql server 5.0


            i want to do an struts application by using jbpm API.
            so i set some configurations and i want to get a task list for one user i have this error.

            this my workflow :


            <process-definition
            xmlns="" name="holiday-request">
            <swimlane name="participant"></swimlane>
            <swimlane name="hr"></swimlane>
            <start-state name="enter request">
            <task name="request entry" swimlane="participant">
            <controller>
            <variable name="start date " access="read,write,required"></variable>
            <variable name="duration" access="read,write,required"></variable>
            </controller>
            </task>
            <transition name="" to="evaluate request"></transition>
            </start-state>
            <task-node name="evaluate request">
            <task name="request evaluation" swimlane="hr">
            <controller>
            <variable name="start date " access="read"></variable>
            <variable name="duration" access="read"></variable>
            <variable name="info" access="read"></variable>
            <variable name="decision"></variable>
            </controller>
            </task>
            <transition name="more info need" to="give additional info"></transition>
            <transition name="approve/disapprove" to="end"></transition>
            </task-node>
            <task-node name="give additional info">
            <task name="additional info entry" swimlane="participant">
            <controller>
            <variable name="start date" access="read"></variable>
            <variable name="duration" access="read"></variable>
            <variable name="info"></variable>
            </controller>
            </task>
            <transition name="" to="evaluate request"></transition>
            </task-node>
            <end-state name="end"></end-state>
            </process-definition>


            this is that i do:


            protected ActionForward performAction(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception {

            System.out.println("\n................StartProcessInstance.............................\n");
            JbpmContext jbpmContext=null;
            GraphSession graphSession=null;
            TaskMgmtSession taskMgmtSession=null;
            ArrayList<String> tasks;

            jbpmContext=this.getJbpmContext(request).getJbpmConfiguration().getCurrentJbpmContext();
            graphSession=jbpmContext.getGraphSession();
            taskMgmtSession=jbpmContext.getTaskMgmtSession();

            try{

            ProcessDefinition processDefinition = graphSession.loadProcessDefinition(2);

            // create a new process instance to run
            ProcessInstance processInstance = new ProcessInstance(processDefinition);

            // create a new taskinstance for the start task
            TaskInstance taskInstance = processInstance.getTaskMgmtInstance().createStartTaskInstance();
            taskInstance.setActorId(jbpmContext.getActorId());

            // Save the process instance along with the task instance
            jbpmContext.save(processInstance);


            this.setJbpmContext(request, jbpmContext);

            }catch(JbpmException e){
            e.printStackTrace();
            }finally{
            if(this.getJbpmContext(request) != null) {
            try {
            this.getJbpmContext(request).close();
            } catch (JbpmException e) {
            e.printStackTrace();
            }
            }
            }
            return mapping.findForward("success");
            }



            • 4. Re: problem to start a taskinstance
              clause Mbacky Newbie

              i gave you error in the first post

              • 5. Re: problem to start a taskinstance
                Ronald van Kuijk Master

                hmmm sorry... i missed that :-( and btw, please repost the workflow and put it in code tags