 | Mailing List | | Home | | Forum Home | | JBoss - Java Application Server | | Tomcat - JSP/Servlet container | | Struts - A MVC web framework | | iText - An open source PDF Java Library | | JDOM - JDOM XML Parser | | J2EE - A mailing list for Java(tm) 2 Platform, Enterprise Edition | | JSP - A mailing list about Java Server Pages specification and reference | | J2EE Pattern - An interest list for Sun Java Center J2EE Pattern Catalog | | Servlet - A mailing list for discussion about Sun Microsystem's Java Servlet API Technology | |
Struts & Hibernate
|
|
|
| | | - GraphSession.deleteProcessInstance(processid) fails | - GraphSession.deleteProcessInstance(processid) fails 2007-07-13 - By X490812
Back
I have written a servlet that cleans up ended processinstances from the jbpm
database. In the servlet, I am passing a processId of an ended process to
deleteProcessInstance. I want to clean out the jbpm tables of all information
related to that ended processinstance, as we have another db holding historical
data for our processes. I pass into deleteProcessInstance the id_ from the jbpm
_processinstance table of the ended processinstance and receive the following -
why?:
anonymous wrote :
| 15:43:19,531 WARN [JDBCExceptionReporter] SQL Error: 2292, SQLState: 23000
| 15:43:19,531 ERROR [JDBCExceptionReporter] ORA-02292 (See http://ORA-02292.ora-code.com): integrity constraint
(JBPM.FK_PROCIN_SPROCTKN) violated - child record found
|
| 15:43:19,531 ERROR [AbstractFlushingEventListener] Could not synchronize
database state with session
| org.hibernate.exception.ConstraintViolationException  : could not delete:
[org.jbpm.graph.exe.Token#5530]
| at org.hibernate.exception.SQLStateConverter (SQLStateConverter
.java:71)
| at org.hibernate.exception.JDBCExceptionHelper (JDBCExceptionHelper
.java:43)
| at org.hibernate.persister.entity.AbstractEntityPersister
(AbstractEntityPersister.java:2476)
| at org.hibernate.persister.entity.AbstractEntityPersister
(AbstractEntityPersister.java:2632)
| at org.hibernate.action.EntityDeleteAction (EntityDeleteAction.java
:73)
| at org.hibernate.engine.ActionQueue (ActionQueue.java:248)
| at org.hibernate.engine.ActionQueue (ActionQueue.java:232)
| at org.hibernate.engine.ActionQueue (ActionQueue.java:144)
| at org.hibernate.event.def.AbstractFlushingEventListener
(AbstractFlushingEventListener.java:298)
| at org.hibernate.event.def.DefaultFlushEventListener
(DefaultFlushEventListener.java:27)
| at org.hibernate.impl.SessionImpl (SessionImpl.java:1000)
| at org.jbpm.persistence.db.DbPersistenceService.close(DbPersistenceService
.java:187)
| at org.jbpm.svc.Services.close(Services.java:211)
| at org.jbpm.JbpmContext.close(JbpmContext.java:139)
| at com.homeq.payoffdemand.services.WorkflowFacadeBean
.cleanupEndedProcesses(WorkflowFacadeBean.java:1269)
| at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
| at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
| at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
| at java.lang.reflect.Method (Unknown Source)
| at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation
.java:112)
| at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed
(InvocationContextImpl.java:166)
| at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke
(EJB3InterceptorsInterceptor.java:63)
| at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation
.java:101)
| at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke
(TransactionScopedEntityManagerInterceptor.java:54)
| at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation
.java:101)
| at org.jboss.ejb3.AllowedOperationsInterceptor.invoke
(AllowedOperationsInterceptor.java:46)
| at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation
.java:101)
| at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
| at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java
:191)
| at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation
.java:101)
| at org.jboss.aspects.tx.TxPropagationInterceptor.invoke
(TxPropagationInterceptor.java:76)
| at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation
.java:101)
| at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke
(StatelessInstanceInterceptor.java:62)
| at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation
.java:101)
| at org.jboss.aspects.security.AuthenticationInterceptor.invoke
(AuthenticationInterceptor.java:77)
| at org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke
(Ejb3AuthenticationInterceptor.java:102)
| at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation
.java:101)
| at org.jboss.ejb3.ENCPropagationInterceptor.invoke
(ENCPropagationInterceptor.java:47)
| at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation
.java:101)
| at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke
(AsynchronousInterceptor.java:106)
| at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation
.java:101)
| at org.jboss.ejb3.stateless.StatelessContainer.localInvoke
(StatelessContainer.java:211)
| at org.jboss.ejb3.stateless.StatelessLocalProxy.invoke(StatelessLocalProxy
.java:79)
| at $Proxy221.cleanupEndedProcesses(Unknown Source)
| at com.homeq.payoffdemand.servlet.JBPM_DBJanitorServlet.doPost(JBPM
_DBJanitorServlet.java:42)
| at com.homeq.payoffdemand.servlet.JBPM_DBJanitorServlet.doGet(JBPM
_DBJanitorServlet.java:23)
| at javax.servlet.http.HttpServlet (HttpServlet.java:697)
| at javax.servlet.http.HttpServlet (HttpServlet.java:810)
| at org.apache.catalina.core.ApplicationFilterChain
(ApplicationFilterChain.java:252)
| at org.apache.catalina.core.ApplicationFilterChain
(ApplicationFilterChain.java:173)
| at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter
(ReplyHeaderFilter.java:96)
| at org.apache.catalina.core.ApplicationFilterChain
(ApplicationFilterChain.java:202)
| at org.apache.catalina.core.ApplicationFilterChain
(ApplicationFilterChain.java:173)
| at org.apache.catalina.core.StandardWrapperValve
(StandardWrapperValve.java:213)
| at org.apache.catalina.core.StandardContextValve
(StandardContextValve.java:178)
| at org.jboss.web.tomcat.security.SecurityAssociationValve
(SecurityAssociationValve.java:175)
| at org.apache.catalina.authenticator.AuthenticatorBase
(AuthenticatorBase.java:432)
| at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve
.java:74)
| at org.apache.catalina.core.StandardHostValve (StandardHostValve
.java:126)
| at org.apache.catalina.valves.ErrorReportValve (ErrorReportValve
.java:105)
| at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke
(CachedConnectionValve.java:156)
| at org.apache.catalina.core.StandardEngineValve (StandardEngineValve
.java:107)
| at org.apache.catalina.connector.CoyoteAdapter (CoyoteAdapter.java
:148)
| at org.apache.coyote.http11.Http11Processor (Http11Processor.java
:869)
| at org.apache.coyote.http11.Http11BaseProtocol $Http11ConnectionHandler
.processConnection(Http11BaseProtocol.java:664)
| at org.apache.tomcat.util.net.PoolTcpEndpoint
(PoolTcpEndpoint.java:527)
| at org.apache.tomcat.util.net.MasterSlaveWorkerThread
(MasterSlaveWorkerThread.java:112)
| at java.lang.Thread (Unknown Source)
| Caused by: java.sql.SQLException : ORA-02292 (See http://ORA-02292.ora-code.com): integrity constraint (JBPM.FK
_PROCIN_SPROCTKN) violated - child record found
|
| at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:112)
| at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
| at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
| at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
| at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement
.java:216)
| at oracle.jdbc.driver.T4CPreparedStatement.executeForRows
(T4CPreparedStatement.java:955)
| at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement
.java:1168)
| at oracle.jdbc.driver.OraclePreparedStatement.executeInternal
(OraclePreparedStatement.java:3285)
| at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate
(OraclePreparedStatement.java:3368)
| at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeUpdate
(CachedPreparedStatement.java:95)
| at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate
(WrappedPreparedStatement.java:251)
| at org.hibernate.persister.entity.AbstractEntityPersister
(AbstractEntityPersister.java:2458)
| ... 65 more
| 15:43:19,578 ERROR [STDERR] org.jbpm.persistence.JbpmPersistenceException:
couldn't flush hibernate session
|
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic
&p=4064172#4064172
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode
=reply&p=4064172
__ ____ ____ ____ ____ ____ ____ ____ ____ ____
jboss-user mailing list
jboss-user@(protected)
https://lists.jboss.org/mailman/listinfo/jboss-user
|
|
|
