[jboss-user] [JBoss jBPM] - Re: Failed to delete ProcessInstance due to foreign key cons

[TejJBPM]

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 key constraint fails (`bapsr`.`jbpm_node`, CONSTRAINT `fk_procst_sbprcdef` FOREIGN KEY (`subprocessdefinition_`) REFERENCES `jbpm_processdefinition` (`id_`))
  | 
  | 	at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:665)
  | 
  | 	at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
  | 
  | 	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
  | 

View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4247190#4247190

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4247190