[jboss-user] [JBoss jBPM] - Re: jbpm process undeploy constraint violation in jbpm 3.2.G

naseem.k do-not-reply at jboss.com
Fri Jun 22 02:26:22 EDT 2007 

The exact exception which I get on the console is:

anonymous wrote : 
  |   [exec] 11:25:33,259 DEBUG [JobExecutorThread] querying for acquirable job...
  |      [exec] 11:25:33,415 ERROR [STDERR] org.hibernate.HibernateException: null index column for collection: org.jbpm.graph.def.ProcessDefinition.actions
  |      [exec] at org.hibernate.persister.collection.AbstractCollectionPersister.readIndex(AbstractCollectionPersister.java:687)
  |      [exec] at org.hibernate.collection.PersistentMap.readFrom(PersistentMap.java:222)
  |      [exec] at org.hibernate.loader.Loader.readCollectionElement(Loader.java:994)
  |      [exec] at org.hibernate.loader.Loader.readCollectionElements(Loader.java:635)
  |      [exec] at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:580)
  |      [exec] at org.hibernate.loader.Loader.doQuery(Loader.java:689)
  |      [exec] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
  |      [exec] at org.hibernate.loader.Loader.loadCollection(Loader.java:1919)
  |      [exec] at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:36)
  |      [exec] at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:541)
  |      [exec] at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:60)
  |      [exec] at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1705)
  |      [exec] at org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:344)
  |      [exec] at org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:86)
  |      [exec] at org.hibernate.collection.PersistentMap.values(PersistentMap.java:198)
  |      [exec] at org.hibernate.type.MapType.getElementsIterator(MapType.java:39)
  |      [exec] at org.hibernate.type.CollectionType.getElementsIterator(CollectionType.java:188)
  |      [exec] at org.hibernate.engine.CascadingAction.getAllElementsIterator(CascadingAction.java:266)
  |      [exec] at org.hibernate.engine.CascadingAction.access$100(CascadingAction.java:21)
  |      [exec] at org.hibernate.engine.CascadingAction$2.getCascadableChildrenIterator(CascadingAction.java:52)
  |      [exec] at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:288)
  |      [exec] at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:185)
  |      [exec] at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:160)
  |      [exec] at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:108)
  |      [exec] at org.hibernate.engine.Cascade.cascade(Cascade.java:248)
  |      [exec] at org.hibernate.engine.Cascade.cascade(Cascade.java:223)
  |      [exec] at org.hibernate.event.def.DefaultDeleteEventListener.cascadeBeforeDelete(DefaultDeleteEventListener.java:220)
  |      [exec] at org.hibernate.event.def.DefaultDeleteEventListener.deleteEntity(DefaultDeleteEventListener.java:169)
  |      [exec] at org.hibernate.event.def.DefaultDeleteEventListener.onDelete(DefaultDeleteEventListener.java:110)
  |      [exec] at org.hibernate.impl.SessionImpl.fireDelete(SessionImpl.java:768)
  |      [exec] at org.hibernate.impl.SessionImpl.delete(SessionImpl.java:746)
  |      [exec] at org.jbpm.db.GraphSession.deleteProcessDefinition(GraphSession.java:249)
  |      [exec] at org.jbpm.db.GraphSession.deleteProcessDefinition(GraphSession.java:233)
  |      [exec] at com.traveldesk.bean.DeleteBean.undeployProcess(Unknown Source)
  |      [exec] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  |      [exec] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  |      [exec] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  |      [exec] at java.lang.reflect.Method.invoke(Method.java:585)
  |      [exec] at com.sun.el.parser.AstValue.invoke(AstValue.java:130)
  |      [exec] at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:274)
  |      [exec] at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)
  |      [exec] at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:77)
  |      [exec] at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:95)
  |      [exec] at javax.faces.component.UICommand.broadcast(UICommand.java:383)
  |      [exec] at javax.faces.component.UIData.broadcast(UIData.java:854)
  |      [exec] at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:448)
  |      [exec] at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:752)
  |      [exec] at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:97)
  |      [exec] at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:248)
  |      [exec] at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117)
  |      [exec] at javax.faces.webapp.FacesServlet.service(FacesServlet.java:244)
  |      [exec] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
  |      [exec] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
  |      [exec] at org.jbpm.webapp.filter.LogFilter.doFilter(LogFilter.java:59)
  |      [exec] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
  |      [exec] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
  |      [exec] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
  |      [exec] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
  |      [exec] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
  |      [exec] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
  |      [exec] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
  |      [exec] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
  |      [exec] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524)
  |      [exec] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
  |      [exec] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
  |      [exec] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
  |      [exec] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
  |      [exec] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
  |      [exec] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
  |      [exec] at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
  |      [exec] at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
  |      [exec] at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
  |      [exec] at java.lang.Thread.run(Thread.java:595)
  |      [exec] 11:25:33,415 ERROR [GraphSession] org.hibernate.HibernateException: null index column for collection: org.jbpm.graph.def.ProcessDefinition.actions
  |      [exec] 11:25:33,415 DEBUG [JbpmContext] closing JbpmContext
  |      [exec] 11:25:33,415 DEBUG [Services] closing service 'persistence': org.jbpm.persistence.db.DbPersistenceService at c1bb13
  |      [exec] 11:25:33,415 DEBUG [DbPersistenceService] committing hibernate transaction
  |      [exec] 11:25:33,509 DEBUG [JobExecutorThread] no acquirable jobs in job table
  |      [exec] 11:25:33,509 DEBUG [JbpmContext] closing JbpmContext
  |      [exec] 11:25:33,509 DEBUG [Services] closing service 'persistence': org.jbpm.persistence.db.DbPersistenceService at 1066718
  |      [exec] 11:25:33,509 DEBUG [DbPersistenceService] committing hibernate transaction
  |      [exec] 11:25:33,509 DEBUG [DbPersistenceService] closing hibernate session
  |      [exec] 11:25:33,509 DEBUG [Services] closing service 'tx': org.jbpm.tx.TxService at 15a6eb9
  |      [exec] 11:25:33,509 DEBUG [JobExecutorThread] obtained locks on following jobs: []
  |      [exec] 11:25:33,509 DEBUG [JbpmContextInfo] creating jbpm context with service factories '[tx, message, scheduler, logging, persistence, authentication]'
  |      [exec] 11:25:33,509 DEBUG [JbpmContext] creating org.jbpm.JbpmContext at 1b4cff
  |      [exec] 11:25:33,509 DEBUG [DbPersistenceServiceFactory] creating persistence service
  |      [exec] 11:25:33,509 DEBUG [DbPersistenceService] creating hibernate session
  |      [exec] 11:25:33,509 DEBUG [DbPersistenceService] beginning hibernate transaction
  |      [exec] 11:25:33,509 DEBUG [JbpmContext] closing JbpmContext
  |      [exec] 11:25:33,509 DEBUG [Services] closing service 'persistence': org.jbpm.persistence.db.DbPersistenceService at 38a763
  |      [exec] 11:25:33,509 DEBUG [DbPersistenceService] committing hibernate transaction
  |      [exec] 11:25:33,509 DEBUG [DbPersistenceService] closing hibernate session
  |      [exec] 11:25:33,509 DEBUG [Services] closing service 'tx': org.jbpm.tx.TxService at 17555b8
  |      [exec] 11:25:33,977 WARN  [JDBCExceptionReporter] SQL Error: 2292, SQLState: 23000
  |      [exec] 11:25:33,977 ERROR [JDBCExceptionReporter] ORA-02292: integrity constraint (RND.FK_PROCDEF_STRTSTA) violated - child record found
  |      [exec] 11:25:33,977 WARN  [JDBCExceptionReporter] SQL Error: 2292, SQLState: 23000
  |      [exec] 11:25:33,977 ERROR [JDBCExceptionReporter] ORA-02292: integrity constraint (RND.FK_PROCDEF_STRTSTA) violated - child record found
  |      [exec] 11:25:33,977 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session
  |      [exec] org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
  |      [exec] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
  |      [exec] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
  |      [exec] at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
  |      [exec] at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
  |      [exec] at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
  |      [exec] at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:218)
  |      [exec] at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2343)
  |      [exec] at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2516)
  |      [exec] at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:73)
  |      [exec] at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
  |      [exec] at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
  |      [exec] at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:144)
  |      [exec] at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297)
  |      [exec] at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
  |      [exec] at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:993)
  |      [exec] at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:340)
  |      [exec] at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
  |      [exec] at org.jbpm.persistence.db.DbPersistenceService.commit(DbPersistenceService.java:253)
  |      [exec] at org.jbpm.persistence.db.DbPersistenceService.close(DbPersistenceService.java:211)
  |      [exec] at org.jbpm.svc.Services.close(Services.java:222)
  |      [exec] at org.jbpm.JbpmContext.close(JbpmContext.java:139)
  |      [exec] at com.traveldesk.bean.DeleteBean.undeployProcess(Unknown Source)
  |      [exec] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  |      [exec] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  |      [exec] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  |      [exec] at java.lang.reflect.Method.invoke(Method.java:585)
  |      [exec] at com.sun.el.parser.AstValue.invoke(AstValue.java:130)
  |      [exec] at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:274)
  |      [exec] at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)
  |      [exec] at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:77)
  |      [exec] at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:95)
  |      [exec] at javax.faces.component.UICommand.broadcast(UICommand.java:383)
  |      [exec] at javax.faces.component.UIData.broadcast(UIData.java:854)
  |      [exec] at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:448)
  |      [exec] at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:752)
  |      [exec] at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:97)
  |      [exec] at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:248)
  |      [exec] at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117)
  |      [exec] at javax.faces.webapp.FacesServlet.service(FacesServlet.java:244)
  |      [exec] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
  |      [exec] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
  |      [exec] at org.jbpm.webapp.filter.LogFilter.doFilter(LogFilter.java:59)
  |      [exec] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
  |      [exec] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
  |      [exec] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
  |      [exec] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
  |      [exec] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
  |      [exec] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
  |      [exec] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
  |      [exec] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
  |      [exec] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524)
  |      [exec] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
  |      [exec] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
  |      [exec] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
  |      [exec] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
  |      [exec] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
  |      [exec] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
  |      [exec] at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
  |      [exec] at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
  |      [exec] at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
  |      [exec] at java.lang.Thread.run(Thread.java:595)
  |      [exec] Caused by: java.sql.BatchUpdateException: ORA-02292: integrity constraint (RND.FK_PROCDEF_STRTSTA) violated - child record found
  |      [exec] at oracle.jdbc.dbaccess.DBError.throwBatchUpdateException(DBError.java:459)
  |      [exec] at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:3907)
  |      [exec] at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:517)
  |      [exec] at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58)
  |      [exec] at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)
  |      [exec] ... 58 more
  |      [exec] 11:25:33,977 ERROR [DbPersistenceService] hibernate commit failed
  | ........... more
  | 

Why hibernate is not allowing to delete the process? What went wrong now?
     
I did just one change in the database and that too was for hibernate sequence. I reset its value as the value goes to 8000. So reset it. Then even after that I cleaned everything and run again my oracle scripts from \\jbpm-jpdl-suite-3.2.GA\jbpm-jpdl-3.2.GA\db\jbpm.jpdl.oracle.sql

Unique constaint problem which I faced earlier I removed that too for the composite column (KEY_ , PROCESSDEFINITION_) in the JBPM_PROCESSINSTANCE table.

Please help. I don't know what to do. This was the only way to delete the process. and now also its not working.:(

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

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

More information about the jboss-user mailing list