Ending or deleting process in bonita

[sabri.zaghdoudi]

Hi,
I have already posted a request related to process instance suppression in
bonita 4.0. All i know is that the error appeared sudently and before it was
working fine.
Does someone have a solution ?
thank you for your answers

regards
sabri
 
[ERROR] MetierVirements - message :Unexpected Exception arrived in Bonita:
could not delete: [org.ow2.bonita.runtime.XpdlExecution#8]
[ERROR] UICg38DemandeVirementForm - A failure occurs when submiting 'Valider
virement' the different parameters :Unexpected Exception arrived in Bonita:
could not delete: [org.ow2.bonita.runtime.XpdlExecution#8]
<org.ow2.bonita.facade.exception.BonitaInternalException: Unexpected Exception
arrived in Bonita: could not delet
e:
[org.ow2.bonita.runtime.XpdlExecution#8]>org.ow2.bonita.facade.exception.BonitaInternalException:
Unexpected Exception arrived in Bonita: could not delete:
[org.ow2.bonita.runtime.XpdlExecution#8]
        at
org.ow2.bonita.facade.exception.BonitaInternalException.build(BonitaInternalException.java:36)
        at org.ow2.bonita.facade.APIInterceptor.invoke(APIInterceptor.java:116)
        at $Proxy71.finishTask(Unknown Source)
        at
cg38.teleprocedures.metier.utils.WorkflowManagerServiceImpl.endTask(WorkflowManagerServiceImpl.java:385)
        at
cg38.teleprocedures.dfi.metier.MetierVirements.validerRefuserDemandeVirement(MetierVirements.java:444)
                                ...
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
        at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
        at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
        at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
        at java.lang.Thread.run(Thread.java:595)
Caused by: org.hibernate.exception.ConstraintViolationException: could not
delete: [org.ow2.bonita.runtime.XpdlExecution#8]
        at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
        at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2541)
        at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2697)
        at
org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:74)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:146)
        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.pvm.internal.tx.HibernateSessionResource.prepare(HibernateSessionResource.java:54)
        at
org.jbpm.pvm.internal.tx.StandardTransaction.commit(StandardTransaction.java:106)
        at
org.jbpm.pvm.internal.tx.StandardTransaction.complete(StandardTransaction.java:65)
        at
org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:61)
        at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)
        at
org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:52)
        at org.ow2.bonita.facade.APIInterceptor.invoke(APIInterceptor.java:100)
        ... 79 more
Caused by:
com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Cannot
delete or update a parent row: a foreign key constraint fails
(`bonita`.`nova_xpdl_exec`, CONSTRAINT `FK_XPDL_EXEC_INST` FOREIGN KEY
(`INSTANCE_`) REFERENCES `nova_xpdl_exec` (`DBID_`))
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:3249)
        at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1268)
        at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1541)
        at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1455)
        at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1440)
        at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
        at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2523)
        ... 94 more


--
You receive this message as a subscriber of the bonita@... mailing list.
To unsubscribe: mailto:bonita-unsubscribe@...
For general help: mailto:sympa@...?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws