2 Replies Latest reply on Jan 6, 2007 5:35 AM by Koen Aers

    How to add new swimlanes

    anu123suya Newbie

      I could deploy my own process definition into hypersonic DB where there are some pre existing users and swimlanes. I have used them in my processdefinition.

      But, while trying to deploy the same processdefinition in mysql, it is not getting deployed. I have added user into JBPM_ID_USERS table. even then it is not getting deployed. just getting the warning message 'task reference unknown swimlane XX'

      Any idea why this message comes up and process is not deployed? and do i need to insert swimlanes manually into the DB as we used to it for users??


      Thanks in advance

        • 1. Re: How to add new swimlanes
          anu123suya Newbie

          sorry, forgot to add the exception message and the complete stack trace

          18:52:37,903 ERROR [JDBCExceptionReporter] Lock wait timeout exceeded; try resta
          rting transaction
          18:52:37,903 ERROR [[jsp]] Servlet.service() for servlet jsp threw exception
          org.hibernate.exception.GenericJDBCException: could not insert: [org.jbpm.graph.
          def.ProcessDefinition]
          at org.hibernate.exception.SQLStateConverter.handledNonSpecificException
          (SQLStateConverter.java:91)
          at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
          ava:79)
          at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
          er.java:43)
          at org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstrac
          tEntityPersister.java:1985)
          at org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstrac
          tEntityPersister.java:2404)
          at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentit
          yInsertAction.java:37)
          at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
          at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplic
          ate(AbstractSaveEventListener.java:269)
          at org.hibernate.event.def.AbstractSaveEventListener.performSave(Abstrac
          tSaveEventListener.java:167)
          at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId
          (AbstractSaveEventListener.java:101)
          at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGene
          ratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186)
          at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrR
          equestedId(DefaultSaveEventListener.java:33)
          at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTran
          sient(DefaultSaveOrUpdateEventListener.java:175)
          at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(
          DefaultSaveEventListener.java:27)
          at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpda
          te(DefaultSaveOrUpdateEventListener.java:70)
          at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:524)
          at org.hibernate.impl.SessionImpl.save(SessionImpl.java:514)
          at org.hibernate.impl.SessionImpl.save(SessionImpl.java:510)
          at org.jbpm.db.GraphSession.deployProcessDefinition(GraphSession.java:77
          )
          at org.jbpm.JbpmContext.deployProcessDefinition(JbpmContext.java:173)
          at org.apache.jsp.Testdeploy_jsp._jspService(Testdeploy_jsp.java:51)
          at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
          at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
          .java:332)
          at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
          14)
          at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
          icationFilterChain.java:252)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
          ilterChain.java:173)
          at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi
          lter.java:96)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
          icationFilterChain.java:202)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
          ilterChain.java:173)
          at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
          alve.java:213)
          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
          alve.java:178)
          at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit
          yAssociationValve.java:175)
          at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValv
          e.java:74)
          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
          ava:126)
          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
          ava:105)
          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
          ve.java:107)
          at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
          a:148)
          at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
          :869)
          at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p
          rocessConnection(Http11BaseProtocol.java:664)
          at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
          int.java:527)
          at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWor
          kerThread.java:112)
          at java.lang.Thread.run(Thread.java:534)
          Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting tra
          nsaction
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
          at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
          at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedSt
          atement.java:1129)
          at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPrepared
          Statement.java:681)
          at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
          :1368)
          at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
          :1283)
          at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
          :1268)
          at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdat
          e(WrappedPreparedStatement.java:251)
          at org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstrac
          tEntityPersister.java:1967)
          ... 41 more

          • 2. Re: How to add new swimlanes
            Koen Aers Master

            Probably the swimlane with the name you use in your process definition is not defined. Post your processdefinition so that we can have a look.

            Regards,
            Koen