[jBPM] - Error while starting process from jbpm-console
by Prasanth Manchambhatla
Prasanth Manchambhatla [https://community.jboss.org/people/pmancham] created the discussion
"Error while starting process from jbpm-console"
To view the discussion, visit: https://community.jboss.org/message/648301#648301
--------------------------------------------------------------
I am getting the following error while trying to start a process from jbpm-console "Processes" tab.
17:46:53,061 WARN [org.jboss.resteasy.core.SynchronousDispatcher] (http--0.0.0.0-8080-5) failed to execute: javax.ws.rs.WebApplicationException: org.hibernate.exception.ConstraintViolationException: could not insert: [org.jbpm.process.audit.ProcessInstanceLog]
at org.jboss.bpm.console.server.ProcessMgmtFacade.newInstance(ProcessMgmtFacade.java:211) [classes:]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [:1.6.0_21]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [:1.6.0_21]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [:1.6.0_21]
at java.lang.reflect.Method.invoke(Method.java:597) [:1.6.0_21]
at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140) [resteasy-jaxrs-2.2.1.GA.jar:]
at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:255) [resteasy-jaxrs-2.2.1.GA.jar:]
at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:220) [resteasy-jaxrs-2.2.1.GA.jar:]
at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:209) [resteasy-jaxrs-2.2.1.GA.jar:]
at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:519) [resteasy-jaxrs-2.2.1.GA.jar:]
at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:496) [resteasy-jaxrs-2.2.1.GA.jar:]
at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119) [resteasy-jaxrs-2.2.1.GA.jar:]
at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208) [resteasy-jaxrs-2.2.1.GA.jar:]
at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55) [resteasy-jaxrs-2.2.1.GA.jar:]
at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50) [resteasy-jaxrs-2.2.1.GA.jar:]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
at org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59) [classes:]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:139) [jboss-as-web-7.0.2.Final.jar:7.0.2.Final]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:480) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
at org.jboss.as.web.NamingValve.invoke(NamingValve.java:57) [jboss-as-web-7.0.2.Final.jar:7.0.2.Final]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:154) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:362) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:667) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:952) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
at java.lang.Thread.run(Thread.java:619) [:1.6.0_21]
Caused by: org.hibernate.exception.ConstraintViolationException: could not insert: [org.jbpm.process.audit.ProcessInstanceLog]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:64) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2176) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2656) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:71) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:321) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:204) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:130) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:56) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:50) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:563) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:551) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:547) [hibernate-core-3.3.2.GA.jar:]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [:1.6.0_21]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [:1.6.0_21]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [:1.6.0_21]
at java.lang.reflect.Method.invoke(Method.java:597) [:1.6.0_21]
at org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:342) [hibernate-core-3.3.2.GA.jar:]
at $Proxy105.save(Unknown Source) at org.jbpm.process.audit.WorkingMemoryDbLogger.addProcessLog(WorkingMemoryDbLogger.java:67) [jbpm-bam-5.2.0.Final.jar:]
at org.jbpm.process.audit.WorkingMemoryDbLogger.logEventCreated(WorkingMemoryDbLogger.java:44) [jbpm-bam-5.2.0.Final.jar:]
at org.drools.audit.WorkingMemoryLogger.filterLogEvent(WorkingMemoryLogger.java:196) [drools-core-5.3.1.Final.jar:]
at org.drools.audit.WorkingMemoryLogger.beforeProcessStarted(WorkingMemoryLogger.java:421) [drools-core-5.3.1.Final.jar:]
at org.drools.event.ProcessEventSupport.fireBeforeProcessStarted(ProcessEventSupport.java:40) [drools-core-5.3.1.Final.jar:]
at org.jbpm.process.instance.ProcessRuntimeImpl.startProcessInstance(ProcessRuntimeImpl.java:167) [jbpm-flow-5.2.0.Final.jar:]
at org.jbpm.process.instance.ProcessRuntimeImpl.startProcess(ProcessRuntimeImpl.java:138) [jbpm-flow-5.2.0.Final.jar:]
at org.drools.common.AbstractWorkingMemory.startProcess(AbstractWorkingMemory.java:1079) [drools-core-5.3.1.Final.jar:]
at org.drools.impl.StatefulKnowledgeSessionImpl.startProcess(StatefulKnowledgeSessionImpl.java:306) [drools-core-5.3.1.Final.jar:]
at org.drools.command.runtime.process.StartProcessCommand.execute(StartProcessCommand.java:119) [drools-core-5.3.1.Final.jar:]
at org.drools.command.runtime.process.StartProcessCommand.execute(StartProcessCommand.java:38) [drools-core-5.3.1.Final.jar:]
at org.drools.command.impl.DefaultCommandService.execute(DefaultCommandService.java:36) [drools-core-5.3.1.Final.jar:]
at org.drools.persistence.SingleSessionCommandService.execute(SingleSessionCommandService.java:345) [drools-persistence-jpa-5.3.1.Final.jar:]
at org.drools.command.impl.CommandBasedStatefulKnowledgeSession.startProcess(CommandBasedStatefulKnowledgeSession.java:223) [drools-core-5.3.1.Final.jar:]
at org.jbpm.integration.console.CommandDelegate.startProcess(CommandDelegate.java:304) [jbpm-gwt-core-5.2.0.Final.jar:]
at org.jbpm.integration.console.ProcessManagement.newInstance(ProcessManagement.java:75) [jbpm-gwt-core-5.2.0.Final.jar:]
at org.jboss.bpm.console.server.ProcessMgmtFacade.newInstance(ProcessMgmtFacade.java:206) [classes:]
... 33 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("JBPM"."PROCESSINSTANCELOG"."ID")
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:85) [ojdbc6-11.1.0.7.0.jar:]
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) [ojdbc6-11.1.0.7.0.jar:]
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) [ojdbc6-11.1.0.7.0.jar:]
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) [ojdbc6-11.1.0.7.0.jar:]
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) [ojdbc6-11.1.0.7.0.jar:]
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) [ojdbc6-11.1.0.7.0.jar:]
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194) [ojdbc6-11.1.0.7.0.jar:]
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:953) [ojdbc6-11.1.0.7.0.jar:]
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222) [ojdbc6-11.1.0.7.0.jar:]
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387) [ojdbc6-11.1.0.7.0.jar:]
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3468) [ojdbc6-11.1.0.7.0.jar:]
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350) [ojdbc6-11.1.0.7.0.jar:]
at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:94) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:57) [hibernate-core-3.3.2.GA.jar:]
... 71 more
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/648301#648301]
Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&con...]
14 years, 2 months
[jBPM] - jbpm 5.2 on JBoss 6 - User Registration "Quest"
by Markus Bauer
Markus Bauer [https://community.jboss.org/people/mark77] created the discussion
"jbpm 5.2 on JBoss 6 - User Registration "Quest""
To view the discussion, visit: https://community.jboss.org/message/648359#648359
--------------------------------------------------------------
Hi all,
I am very new to jBPM and am kind of stuck in multiple places. I could really need some hints or links to relevant tutorials or so. So here's what I have and need:
The environment is jbpm 5.2 on JBoss 6, the processes should be delivered in BPMN2. My first target is a user registration form. The idea is to have a user fill a JSF2 form containing his chosen username, password and email address (and captcha, but that already works). I now need to store these values to an external database and send (via the jBPM process) a confirmation email to the user. The user clicks a link inside the email and can continue his registration process by giving his address etc.
Now these entered data is again stored in the external database and from now on, the user should be able to log in with his credentials. Further, now an administrator (whose credentials are also stored in the external database) has to log in and approve the account of the newly registered user, then the user is "fully qualified" and can e.g. regiister new services.
The whole application is a maven2 project and jBPM should not be installed at the server but be bundled with the application (thus using LocalTasks - I think I got this running).
For assigning the tasks to the user and administrator I think I found the solution to use an own usergroups.callback. But when I want to create the process and start the task, I get an SQL error because the foreign key to the organizationentity table is broken. (Of course it is, because users and all this stuff is managed externally and is not forwarded to the jBPM database).
Next question is, how can I generate this email and send it to the user ? Do I have to write a task handler for sending this email and inserting the link and user's email address ?
How can I get back from the confirmation-endpoint (where the emailed link points to) back to the task to complete it ?
And finally - how can I include a ... whatever.... that automatically removes the pending confirmation tasks and assiciated data, if the user does not click the confirmation link within 3 days ?
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/648359#648359]
Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&con...]
14 years, 2 months
