2 Replies Latest reply on Jun 4, 2007 9:02 AM by Ronald van Kuijk

    Problems ,when inserting data from the database.

    mr Sathya Newbie

      Hi Friends and Kukultjee sir,

      I am new to jbpm.Hope u will help me in solving this Problem..

      I am using Jbpm-3.1.4 and Jboss 4.0.2 as apllication server and database MsSQL ....
      I developed processdefinition.xml file and deployed in jbpm-3.1.4 .it is running successfully with hardcoding values...

      Now,what i am doing is i am inserting the values from the database using

      stored procedure directly to the first node ie.startstate which contains

      two textboxes i.e projectname,plan status .after

      executing the storedprocedure the corresponding values are populated in

      these textboxes..Up to Now..it's Ok..But after clicking the 'Save and Close' button

      it is generating the following errors..

      exception stacktrace:

      14:41:25,436 DEBUG [JbpmContext] closing JbpmContext
      14:41:25,436 DEBUG [Services] closing service 'persistence': org.jbpm.persistence.db.DbPersistenceService@19707
      14:41:25,436 DEBUG [DbPersistenceService] committing hibernate transaction
      14:41:25,452 INFO [STDOUT] couldn't commit hibernate session
      14:41:25,452 DEBUG [DbPersistenceService] closing hibernate session
      14:41:25,452 DEBUG [Services] closing service 'logging': org.jbpm.logging.db.DbLoggingService@6258e1
      14:41:25,452 DEBUG [Services] closing service 'authentication': org.jbpm.security.authentication.DefaultAuthenticationSe
      rvice@b9242e
      14:41:25,452 ERROR [[FacesServlet]] Servlet.service() for servlet FacesServlet threw exception
      javax.faces.FacesException: Error calling action method of component with id taskform:transitionButton
      at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:74)
      at javax.faces.component.UICommand.broadcast(UICommand.java:106)
      at javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:90)
      at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:164)
      at org.apache.myfaces.lifecycle.LifecycleImpl.invokeApplication(LifecycleImpl.java:271)
      at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:86)
      at javax.faces.webapp.FacesServlet.service(FacesServlet.java:94)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.jbpm.webapp.filter.AuthenticationFilter.doFilter(AuthenticationFilter.java:56)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.jbpm.web.JbpmContextFilter.doFilter(JbpmContextFilter.java:83)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.jbpm.webapp.filter.LogFilter.doFilter(LogFilter.java:62)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
      at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
      at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153)
      at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
      at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
      at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
      at java.lang.Thread.run(Thread.java:595)
      Caused by: javax.faces.el.EvaluationException: Exception while invoking expression #{taskBean.saveAndClose}
      at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:153)
      at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:63)
      ... 34 more
      Caused by: org.jbpm.graph.def.DelegationException
      at org.jbpm.taskmgmt.exe.TaskMgmtInstance.performAssignment(TaskMgmtInstance.java:247)
      at org.jbpm.taskmgmt.exe.TaskMgmtInstance.getInitializedSwimlaneInstance(TaskMgmtInstance.java:202)
      at org.jbpm.taskmgmt.exe.TaskInstance.assign(TaskInstance.java:202)
      at org.jbpm.taskmgmt.exe.TaskMgmtInstance.createTaskInstance(TaskMgmtInstance.java:157)
      at org.jbpm.graph.node.TaskNode.execute(TaskNode.java:177)
      at org.jbpm.graph.def.Node.enter(Node.java:321)
      at org.jbpm.graph.def.Node$$FastClassByCGLIB$$d187eeda.invoke()
      at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
      at org.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:161)
      at org.jbpm.graph.def.Node$$EnhancerByCGLIB$$1b65fd46.enter()
      at org.jbpm.graph.def.Transition.take(Transition.java:129)
      at org.jbpm.graph.def.Node.leave(Node.java:399)
      at org.jbpm.graph.node.TaskNode.leave(TaskNode.java:213)
      at org.jbpm.graph.def.Node$$FastClassByCGLIB$$d187eeda.invoke()
      at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
      at org.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:161)
      at org.jbpm.graph.def.Node$$EnhancerByCGLIB$$1b65fd46.leave()
      at org.jbpm.graph.exe.Token.signal(Token.java:181)
      at org.jbpm.graph.exe.Token.signal(Token.java:149)
      at org.jbpm.graph.exe.Token$$FastClassByCGLIB$$74df1c6e.invoke()
      at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
      at org.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:161)
      at org.jbpm.graph.exe.Token$$EnhancerByCGLIB$$82f38682.signal()
      at org.jbpm.taskmgmt.exe.TaskInstance.end(TaskInstance.java:469)
      at org.jbpm.taskmgmt.exe.TaskInstance.end(TaskInstance.java:408)
      at org.jbpm.taskmgmt.exe.TaskInstance$$FastClassByCGLIB$$cb2c21af.invoke()
      at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
      at org.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:161)
      at org.jbpm.taskmgmt.exe.TaskInstance$$EnhancerByCGLIB$$7b99ebe5.end()
      at org.jbpm.webapp.bean.TaskBean.saveAndClose(TaskBean.java:189)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:129)
      ... 35 more
      Caused by: org.jbpm.identity.assignment.ExpressionAssignmentException: couldn't resolve assignment expression 'user(Aari
      f)'
      at org.jbpm.identity.assignment.ExpressionAssignmentHandler.assign(ExpressionAssignmentHandler.java:104)
      at org.jbpm.taskmgmt.exe.TaskMgmtInstance.performAssignmentDelegation(TaskMgmtInstance.java:259)
      at org.jbpm.taskmgmt.exe.TaskMgmtInstance.performAssignment(TaskMgmtInstance.java:228)
      ... 69 more
      Caused by: java.lang.NullPointerException
      at org.jbpm.identity.hibernate.IdentitySession.getUserByName(IdentitySession.java:168)
      at org.jbpm.identity.assignment.ExpressionAssignmentHandler.getUserByName(ExpressionAssignmentHandler.java:226)
      at org.jbpm.identity.assignment.ExpressionAssignmentHandler.resolveFirstTerm(ExpressionAssignmentHandler.java:15
      6)
      at org.jbpm.identity.assignment.ExpressionAssignmentHandler.assign(ExpressionAssignmentHandler.java:80)
      ... 71 more

      I tried and didnt find the solution Hope u will help me in this

      Thanx in Advance...
      -sathya

        • 1. Re: Problems ,when inserting data from the database.
          mr Sathya Newbie

          Plz anybody help me in this?

          I need ur help in this..it is urgent...!

          Thanx in advance...



          -sathya
          Bangalore,
          India

          • 2. Re: Problems ,when inserting data from the database.
            Ronald van Kuijk Master

            read the error:


            Caused by: org.jbpm.identity.assignment.ExpressionAssignmentException: couldn't resolve assignment expression 'user(Aari
            f)'
            at org.jbpm.identity.assignment.ExpressionAssignmentHandler.assign(ExpressionAssignmentHandler.java:104)
            at org.jbpm.taskmgmt.exe.TaskMgmtInstance.performAssignmentDelegation(TaskMgmtInstance.java:259)
            at org.jbpm.taskmgmt.exe.TaskMgmtInstance.performAssignment(TaskMgmtInstance.java:228)
            ... 69 more
            Caused by: java.lang.NullPointerException
            at org.jbpm.identity.hibernate.IdentitySession.getUserByName(IdentitySession.java:168)
            at org.jbpm.identity.assignment.ExpressionAssignmentHandler.getUserByName(ExpressionAssignmentHandler.java:226)
            at org.jbpm.identity.assignment.ExpressionAssignmentHandler.resolveFirstTerm(ExpressionAssignmentHandler.java:15
            6)
            at org.jbpm.identity.assignment.ExpressionAssignmentHandler.assign(ExpressionAssignmentHandler.java:80)


            The assignment does not return a known user, most likely your user Aarif is not in the userdatabase