[jboss-user] [JBoss jBPM] - Re: Failed to delete ProcessInstance due to foreign key cons
by 'both ways', are you referring to this: anonymous wrote : Deploy PD2 and then PD1 - delete both works fine | Deploy PD2 and then PD1 - execute PD1 and PD2 from PD1 - getting this error.. where the difference in the second way is that there are actually (ended) process instances? Other than that, you are calling GraphSession.deleteProcessDefinition(..) - or use the link in the jbpm-console - just as in the first case? View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4247620#4247620 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4247620 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss jBPM] - Re: Failed to delete ProcessInstance due to foreign key cons
Hmm..that is goin to be the only option I have.. @Martin Did you try both the ways which I tried and you are still not getting any error or you tried to delete immediately after deploying? View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4247353#4247353 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4247353 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss jBPM] - Re: Failed to delete ProcessInstance due to foreign key cons
If you have customized it, you probably did this by checking out the source. I cannot imagine the differences to be so big that you cannot fairly easily update your version to the latest source. If so... I think you have to manually find differences in the source (with help from Jira maybe) that might explain why it does work with Martin and not with you. It is kind of difficult (besides not having the time) to help you find issues in "your version" View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4247318#4247318 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4247318 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss jBPM] - Re: Failed to delete ProcessInstance due to foreign key cons
I tried using the latest mysql connector but same error. Unfortunately , I cant upgrade to the 3.2.x version as I have customised the jbpm code and extended it some places to get things done.. I tried this PD1 - Parent PD2 - Child Deploy PD2 and then PD1 - delete both works fine Deploy PD2 and then PD1 - execute PD1 and PD2 from PD1 - getting this error.. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4247293#4247293 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4247293 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss jBPM] - Re: Failed to delete ProcessInstance due to foreign key cons
I'd give a newer jBPM 3.2.x version a try View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4247243#4247243 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4247243 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss jBPM] - Re: Failed to delete ProcessInstance due to foreign key cons
mysql calls there driver 'connector' View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4247234#4247234 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4247234 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss jBPM] - Re: Failed to delete ProcessInstance due to foreign key cons
driver View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4247233#4247233 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4247233 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss jBPM] - Re: Failed to delete ProcessInstance due to foreign key cons
Sorry for being so densehow do i use a connector? View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4247224#4247224 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4247224 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss jBPM] - Re: Failed to delete ProcessInstance due to foreign key cons
Try using a newer connector first View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4247220#4247220 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4247220 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss jBPM] - Re: Failed to delete ProcessInstance due to foreign key cons
If I change the end state in the process-state to end ..I am able to delete but then the transition from the parent process to sub process is not happening...So i think there is some problem(or difference? ) in using end-state and end in the process-state? Any thoughts? View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4247204#4247204 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4247204 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss jBPM] - Re: Failed to delete ProcessInstance due to foreign key cons
My MYSQL Version is 5.1 and MYSQL Connector version - 5.0.4 .. any suggestions? View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4247194#4247194 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4247194 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss jBPM] - Re: Failed to delete ProcessInstance due to foreign key cons
My JBPM Version is 3.2.1.. I tried to delete the child process and get this error: Delete failed: An exception of type "org.hibernate.exception.ConstraintViolationException" was thrown. The message is: Could not execute JDBC batch update | 2009-07-31 09:52:10,549 [http-80-Processor22] WARN (JDBCExceptionReporter.java:77) - SQL Error: 1451, SQLState: 23000 | | 2009-07-31 09:52:10,550 [http-80-Processor22] ERROR (JDBCExceptionReporter.java:78) - Cannot delete or update a parent row: a foreign key constraint fails (`bapsr`.`jbpm_node`, CONSTRAINT `fk_procst_sbprcdef` FOREIGN KEY (`subprocessdefinition_`) REFERENCES `jbpm_processdefinition` (`id_`)) | | 2009-07-31 09:52:10,550 [http-80-Processor22] ERROR (AbstractFlushingEventListener.java:301) - Could not synchronize database state with session | | org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update | | at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71) | | at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) | | at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253) | | at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235) | | at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:144) | | at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) | | at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) | | at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000) | | at org.jbpm.jsf.core.action.DeleteActionListener.handleAction(DeleteActionListener.java:50) | | at org.jbpm.jsf.core.impl.JbpmActionListenerWrapper.processAction(JbpmActionListenerWrapper.java:82) | | at javax.faces.event.ActionEvent.processListener(ActionEvent.java:77) | | at javax.faces.component.UIComponentBase.broadcast(UIComponentBase.java:758) | | at javax.faces.component.UICommand.broadcast(UICommand.java:368) | | at org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:186) | | at org.ajax4jsf.component.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:164) | | at org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:352) | | at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:97) | | at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:248) | | at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117) | | at javax.faces.webapp.FacesServlet.service(FacesServlet.java:244) | | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) | | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) | | at com.njw.session.BASessionExpiryFilter.doFilter(BASessionExpiryFilter.java:43) | | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) | | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) | | at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:141) | | at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:281) | | 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.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:869) | | at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) | | at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) | | at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) | | at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) | | at java.lang.Thread.run(Thread.java:595) | | Caused by: java.sql.BatchUpdateException: Cannot delete or update a parent row: a foreign
[jboss-user] [JBoss jBPM] - Re: Failed to delete ProcessInstance due to foreign key cons
TejJBPM, this is jBPM 3, right? If you've got a process-state node in the process definition that you are trying to delete, you might want to try to delete the child process before. Although I have to say I don't see this FK violation in my environment (jBPM 3.2.5.SP5, MySQL 5.1.35, mysql-connector-java-5.0.7) View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4247189#4247189 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4247189 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss jBPM] - Re: Failed to delete ProcessInstance due to foreign key cons
Ok this is happening when I have a "Process State" node in my process diagram.. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4247187#4247187 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4247187 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss jBPM] - Re: Failed to delete ProcessInstance due to foreign key cons
I can see that from the error..how do i fix that? It does not seem to be occuring from my code..but JBPM is failing to delete..so It is a bug.. any fix or is it resolved? View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4247181#4247181 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4247181 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss jBPM] - Re: Failed to delete ProcessInstance due to foreign key cons
because it cannot be removed due to e FK constraint. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4247137#4247137 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4247137 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss jBPM] - Re: Failed to delete ProcessInstance due to foreign key cons
it happens when i end an process.. if it is removed from the db..why is it showing an error? View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4247112#4247112 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4247112 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss jBPM] - Re: Failed to delete ProcessInstance due to foreign key cons
is it an delete you do yourself? Or does it also happen when you just end a process the normal way? It is removed from te db then. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4247102#4247102 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4247102 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user