<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="http://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Help me! processinstance why not delete?
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/clsun88">chen lei</a> in <i>jBPM Development</i> - <a href="http://community.jboss.org/message/558440#558440">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p><strong>my project use JBPM 3.2.1. Now ,customer business Data is very so many. I use JBPM API (deleteProcessInstance) delete data.but console out Error.Error is deplay:</strong></p><p>org.jbpm.JbpmException: problem closing services {persistence=org.jbpm.persistence.JbpmPersistenceException: hibernate flush failed}<br/> at org.jbpm.svc.Services.close(Services.java:234)<br/> at org.jbpm.JbpmContext.close(JbpmContext.java:139)<br/> at com.wedge.edp.framework.jbpm.dao.support.JbpmTemplate.closeJbpmContext(JbpmTemplate.java:109)<br/> at com.wedge.edp.framework.jbpm.dao.support.JbpmTemplate.execute(JbpmTemplate.java:84)<br/> at com.wedge.edp.framework.jbpm.service.support.OpenWorkflowContextAdvice.invoke(OpenWorkflowContextAdvice.java:22)<br/> at sun.reflect.GeneratedMethodAccessor16.invoke(Unknown Source)<br/> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br/> at java.lang.reflect.Method.invoke(Method.java:597)<br/> at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:576)<br/> at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:562)<br/> at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:60)<br/> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)<br/> at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)<br/> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)<br/> at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)<br/> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)<br/> at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:630)<br/> at com.wedge.edp.framework.jbpm.application.JbpmProcessApplication$$EnhancerByCGLIB$$22de81b1.deleteProcess(<generated>)<br/> at com.wedge.rms.commons.process.service.impl.ProcessServiceImpl.proceeDelete(ProcessServiceImpl.java:345)<br/> at com.wedge.rms.commons.process.service.impl.ProcessServiceImpl$$FastClassByCGLIB$$e6553eb9.invoke(<generated>)<br/> at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)<br/> at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:695)<br/> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)<br/> at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)<br/> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)<br/> at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:630)<br/> at com.wedge.rms.commons.process.service.impl.ProcessServiceImpl$$EnhancerByCGLIB$$95e4e6ee.proceeDelete(<generated>)<br/> at test.wfTest.delete(wfTest.java:51)<br/> at test.wfTest.main(wfTest.java:46)<br/>Caused by: org.jbpm.persistence.JbpmPersistenceException: hibernate flush failed<br/> at org.jbpm.persistence.db.DbPersistenceService.close(DbPersistenceService.java:236)<br/> at org.jbpm.svc.Services.close(Services.java:222)<br/> ... 28 more<br/>Caused by: org.hibernate.exception.ConstraintViolationException: could not delete: [org.jbpm.graph.exe.ProcessInstance#6094]<br/> at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)<br/> at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)<br/> at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2491)<br/> at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2647)<br/> at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:74)<br/> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)<br/> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)<br/> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:144)<br/> at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)<br/> at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)<br/> at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)<br/> at org.jbpm.persistence.db.DbPersistenceService.flushSession(DbPersistenceService.java:267)<br/> at org.jbpm.persistence.db.DbPersistenceService.close(DbPersistenceService.java:231)<br/> ... 29 more<br/>Caused by: com.microsoft.sqlserver.jdbc.SQLServerException:<span style="color: #ff6600;"> DELETE 语句与 REFERENCE 约束"FK_TOKEN_SUBPI"冲突。该冲突发生于数据库"PES"，表"dbo.JBPM_TOKEN", column 'SUBPROCESSINSTANCE_'。<br/></span> at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)<br/> at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)<br/> at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)<br/> at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(Unknown Source)<br/> at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)<br/> at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)<br/> at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source)<br/> at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source)<br/> at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(Unknown Source)<br/> at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2473)<br/> ... 39 more</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><strong>see database.JBPM_PROCESSINSTANCE and JBPM_TOKEN.Table.subprocessinstance_ is null.</strong></p><p><strong>why I can't delete it?  how should I delete?</strong> </p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/558440#558440">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in jBPM Development at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2035">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>