couldn't delete process definition

[tinico]

Hi,

I've a problem... I need some help... I use jBPM web-console to deploy my process and to delete it... I deploy lot of process and I often delete it because I make lot of tests !!

But, There is a problem... When I use the agument "notify='yes' " on task, I can't delete process... When I delete "notify='yes' " I can...

Here the error message :

Delete failed: An exception of type "org.jbpm.JbpmException" was thrown. The message is: couldn't delete process definition '1602'

Someone has any idea ?? please ??? :s

[kukeltje]

show stacktraces..., versions etc....

[tinico]

Here stackTrace :

16:39:32,248 ERROR [STDERR] org.hibernate.HibernateException: null index column for collection: org.jbpm.graph.def.ProcessDefinition.actions
 at org.hibernate.persister.collection.AbstractCollectionPersister.readIndex(Ljava/sql/ResultSet;[Ljava/lang/String;Lorg/hibernate/engine/SessionImplemen
tor;)Ljava/lang/Object;(AbstractCollectionPersister.java:687)
 at org.hibernate.collection.PersistentMap.readFrom(Ljava/sql/ResultSet;Lorg/hibernate/persister/collection/CollectionPersister;Lorg/hibernate/loader/Col
lectionAliases;Ljava/lang/Object;)Ljava/lang/Object;(PersistentMap.java:222)
 at org.hibernate.loader.Loader.readCollectionElement(Ljava/lang/Object;Ljava/io/Serializable;Lorg/hibernate/persister/collection/CollectionPersister;Lor
g/hibernate/loader/CollectionAliases;Ljava/sql/ResultSet;Lorg/hibernate/engine/SessionImplementor;)V(Loader.java:994)
 at org.hibernate.loader.Loader.readCollectionElements([Ljava/lang/Object;Ljava/sql/ResultSet;Lorg/hibernate/engine/SessionImplementor;)V(Loader.java:635
)
 at org.hibernate.loader.Loader.getRowFromResultSet(Ljava/sql/ResultSet;Lorg/hibernate/engine/SessionImplementor;Lorg/hibernate/engine/QueryParameters;[L
org/hibernate/LockMode;Lorg/hibernate/engine/EntityKey;Ljava/util/List;[Lorg/hibernate/engine/EntityKey;Z)Ljava/lang/Object;(Loader.java:580)
 at org.hibernate.loader.Loader.doQuery(Lorg/hibernate/engine/SessionImplementor;Lorg/hibernate/engine/QueryParameters;Z)Ljava/util/List;(Loader.java:689
)
 at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lorg/hibernate/engine/SessionImplementor;Lorg/hibernate/engine/QueryParameters;Z)L
java/util/List;(Loader.java:224)
 at org.hibernate.loader.Loader.loadCollection(Lorg/hibernate/engine/SessionImplementor;Ljava/io/Serializable;Lorg/hibernate/type/Type;)V(Loader.java:191
9)
 at org.hibernate.loader.collection.CollectionLoader.initialize(Ljava/io/Serializable;Lorg/hibernate/engine/SessionImplementor;)V(CollectionLoader.java:3
6)
 at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(Ljava/io/Serializable;Lorg/hibernate/engine/SessionImplementor;)V(AbstractC
ollectionPersister.java:541)
 at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(Lorg/hibernate/event/InitializeCollectionEvent;)V(DefaultInit
ializeCollectionEventListener.java:60)
 at org.hibernate.impl.SessionImpl.initializeCollection(Lorg/hibernate/collection/PersistentCollection;Z)V(SessionImpl.java:1705)
 at org.hibernate.collection.AbstractPersistentCollection.initialize(Z)V(AbstractPersistentCollection.java:344)
 at org.hibernate.collection.AbstractPersistentCollection.read()V(AbstractPersistentCollection.java:86)
 at org.hibernate.collection.PersistentMap.values()Ljava/util/Collection;(PersistentMap.java:198)
 at org.hibernate.type.MapType.getElementsIterator(Ljava/lang/Object;)Ljava/util/Iterator;(MapType.java:39)
 at org.hibernate.type.CollectionType.getElementsIterator(Ljava/lang/Object;Lorg/hibernate/engine/SessionImplementor;)Ljava/util/Iterator;(CollectionType
.java:188)
 at org.hibernate.engine.CascadingAction.getAllElementsIterator(Lorg/hibernate/event/EventSource;Lorg/hibernate/type/CollectionType;Ljava/lang/Object;)Lj
ava/util/Iterator;(CascadingAction.java:266)
 at org.hibernate.engine.CascadingAction.access$100(Lorg/hibernate/event/EventSource;Lorg/hibernate/type/CollectionType;Ljava/lang/Object;)Ljava/util/Ite
rator;(CascadingAction.java:21)
 at org.hibernate.engine.CascadingAction$2.getCascadableChildrenIterator(Lorg/hibernate/event/EventSource;Lorg/hibernate/type/CollectionType;Ljava/lang/O
bject;)Ljava/util/Iterator;(CascadingAction.java:52)
 at org.hibernate.engine.Cascade.cascadeCollectionElements(Ljava/lang/Object;Lorg/hibernate/type/CollectionType;Lorg/hibernate/engine/CascadeStyle;Lorg/h
ibernate/type/Type;Ljava/lang/Object;Z)V(Cascade.java:288)
 at org.hibernate.engine.Cascade.cascadeCollection(Ljava/lang/Object;Lorg/hibernate/engine/CascadeStyle;Ljava/lang/Object;Lorg/hibernate/type/CollectionT
ype;)V(Cascade.java:185)
 at org.hibernate.engine.Cascade.cascadeAssociation(Ljava/lang/Object;Lorg/hibernate/type/Type;Lorg/hibernate/engine/CascadeStyle;Ljava/lang/Object;Z)V(C
ascade.java:160)
 at org.hibernate.engine.Cascade.cascadeProperty(Ljava/lang/Object;Lorg/hibernate/type/Type;Lorg/hibernate/engine/CascadeStyle;Ljava/lang/Object;Z)V(Casc
ade.java:108)
 at org.hibernate.engine.Cascade.cascade(Lorg/hibernate/persister/entity/EntityPersister;Ljava/lang/Object;Ljava/lang/Object;)V(Cascade.java:248)
 at org.hibernate.engine.Cascade.cascade(Lorg/hibernate/persister/entity/EntityPersister;Ljava/lang/Object;)V(Cascade.java:223)
 at org.hibernate.event.def.DefaultDeleteEventListener.cascadeBeforeDelete(Lorg/hibernate/event/EventSource;Lorg/hibernate/persister/entity/EntityPersist
er;Ljava/lang/Object;Lorg/hibernate/engine/EntityEntry;)V(DefaultDeleteEventListener.java:220)
 at org.hibernate.event.def.DefaultDeleteEventListener.deleteEntity(Lorg/hibernate/event/EventSource;Ljava/lang/Object;Lorg/hibernate/engine/EntityEntry;
ZLorg/hibernate/persister/entity/EntityPersister;)V(DefaultDeleteEventListener.java:169)
 at org.hibernate.event.def.DefaultDeleteEventListener.onDelete(Lorg/hibernate/event/DeleteEvent;)V(DefaultDeleteEventListener.java:110)
 at org.hibernate.impl.SessionImpl.fireDelete(Lorg/hibernate/event/DeleteEvent;)V(SessionImpl.java:768)
 at org.hibernate.impl.SessionImpl.delete(Ljava/lang/Object;)V(SessionImpl.java:746)
 at org.jbpm.db.GraphSession.deleteProcessDefinition(Lorg/jbpm/graph/def/ProcessDefinition;)V(GraphSession.java:249)
16:39:32,248 ERROR [GraphSession] org.hibernate.HibernateException: null index column for collection: org.jbpm.graph.def.ProcessDefinition.actions
18:48:00,733 ERROR [STDERR] org.hibernate.HibernateException: null index column for collection: org.jbpm.graph.def.ProcessDefinition.actions
 at org.hibernate.persister.collection.AbstractCollectionPersister.readIndex(Ljava/sql/ResultSet;[Ljava/lang/String;Lorg/hibernate/engine/SessionImplemen
tor;)Ljava/lang/Object;(AbstractCollectionPersister.java:687)
 at org.hibernate.collection.PersistentMap.readFrom(Ljava/sql/ResultSet;Lorg/hibernate/persister/collection/CollectionPersister;Lorg/hibernate/loader/Col
lectionAliases;Ljava/lang/Object;)Ljava/lang/Object;(PersistentMap.java:222)
 at org.hibernate.loader.Loader.readCollectionElement(Ljava/lang/Object;Ljava/io/Serializable;Lorg/hibernate/persister/collection/CollectionPersister;Lor
g/hibernate/loader/CollectionAliases;Ljava/sql/ResultSet;Lorg/hibernate/engine/SessionImplementor;)V(Loader.java:994)
 at org.hibernate.loader.Loader.readCollectionElements([Ljava/lang/Object;Ljava/sql/ResultSet;Lorg/hibernate/engine/SessionImplementor;)V(Loader.java:635
)
 at org.hibernate.loader.Loader.getRowFromResultSet(Ljava/sql/ResultSet;Lorg/hibernate/engine/SessionImplementor;Lorg/hibernate/engine/QueryParameters;[L
org/hibernate/LockMode;Lorg/hibernate/engine/EntityKey;Ljava/util/List;[Lorg/hibernate/engine/EntityKey;Z)Ljava/lang/Object;(Loader.java:580)
 at org.hibernate.loader.Loader.doQuery(Lorg/hibernate/engine/SessionImplementor;Lorg/hibernate/engine/QueryParameters;Z)Ljava/util/List;(Loader.java:689
)
 at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lorg/hibernate/engine/SessionImplementor;Lorg/hibernate/engine/QueryParameters;Z)L
java/util/List;(Loader.java:224)
 at org.hibernate.loader.Loader.loadCollection(Lorg/hibernate/engine/SessionImplementor;Ljava/io/Serializable;Lorg/hibernate/type/Type;)V(Loader.java:191
9)
 at org.hibernate.loader.collection.CollectionLoader.initialize(Ljava/io/Serializable;Lorg/hibernate/engine/SessionImplementor;)V(CollectionLoader.java:3
6)
 at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(Ljava/io/Serializable;Lorg/hibernate/engine/SessionImplementor;)V(AbstractC
ollectionPersister.java:541)
 at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(Lorg/hibernate/event/InitializeCollectionEvent;)V(DefaultInit
ializeCollectionEventListener.java:60)
 at org.hibernate.impl.SessionImpl.initializeCollection(Lorg/hibernate/collection/PersistentCollection;Z)V(SessionImpl.java:1705)
 at org.hibernate.collection.AbstractPersistentCollection.initialize(Z)V(AbstractPersistentCollection.java:344)
 at org.hibernate.collection.AbstractPersistentCollection.read()V(AbstractPersistentCollection.java:86)
 at org.hibernate.collection.PersistentMap.values()Ljava/util/Collection;(PersistentMap.java:198)
 at org.hibernate.type.MapType.getElementsIterator(Ljava/lang/Object;)Ljava/util/Iterator;(MapType.java:39)
 at org.hibernate.type.CollectionType.getElementsIterator(Ljava/lang/Object;Lorg/hibernate/engine/SessionImplementor;)Ljava/util/Iterator;(CollectionType
.java:188)
 at org.hibernate.engine.CascadingAction.getAllElementsIterator(Lorg/hibernate/event/EventSource;Lorg/hibernate/type/CollectionType;Ljava/lang/Object;)Lj
ava/util/Iterator;(CascadingAction.java:266)
 at org.hibernate.engine.CascadingAction.access$100(Lorg/hibernate/event/EventSource;Lorg/hibernate/type/CollectionType;Ljava/lang/Object;)Ljava/util/Ite
rator;(CascadingAction.java:21)
 at org.hibernate.engine.CascadingAction$2.getCascadableChildrenIterator(Lorg/hibernate/event/EventSource;Lorg/hibernate/type/CollectionType;Ljava/lang/O
bject;)Ljava/util/Iterator;(CascadingAction.java:52)
 at org.hibernate.engine.Cascade.cascadeCollectionElements(Ljava/lang/Object;Lorg/hibernate/type/CollectionType;Lorg/hibernate/engine/CascadeStyle;Lorg/h
ibernate/type/Type;Ljava/lang/Object;Z)V(Cascade.java:288)
 at org.hibernate.engine.Cascade.cascadeCollection(Ljava/lang/Object;Lorg/hibernate/engine/CascadeStyle;Ljava/lang/Object;Lorg/hibernate/type/CollectionT
ype;)V(Cascade.java:185)
 at org.hibernate.engine.Cascade.cascadeAssociation(Ljava/lang/Object;Lorg/hibernate/type/Type;Lorg/hibernate/engine/CascadeStyle;Ljava/lang/Object;Z)V(C
ascade.java:160)
 at org.hibernate.engine.Cascade.cascadeProperty(Ljava/lang/Object;Lorg/hibernate/type/Type;Lorg/hibernate/engine/CascadeStyle;Ljava/lang/Object;Z)V(Casc
ade.java:108)
 at org.hibernate.engine.Cascade.cascade(Lorg/hibernate/persister/entity/EntityPersister;Ljava/lang/Object;Ljava/lang/Object;)V(Cascade.java:248)
 at org.hibernate.engine.Cascade.cascade(Lorg/hibernate/persister/entity/EntityPersister;Ljava/lang/Object;)V(Cascade.java:223)
 at org.hibernate.event.def.DefaultDeleteEventListener.cascadeBeforeDelete(Lorg/hibernate/event/EventSource;Lorg/hibernate/persister/entity/EntityPersist
er;Ljava/lang/Object;Lorg/hibernate/engine/EntityEntry;)V(DefaultDeleteEventListener.java:220)
 at org.hibernate.event.def.DefaultDeleteEventListener.deleteEntity(Lorg/hibernate/event/EventSource;Ljava/lang/Object;Lorg/hibernate/engine/EntityEntry;
ZLorg/hibernate/persister/entity/EntityPersister;)V(DefaultDeleteEventListener.java:169)
 at org.hibernate.event.def.DefaultDeleteEventListener.onDelete(Lorg/hibernate/event/DeleteEvent;)V(DefaultDeleteEventListener.java:110)
 at org.hibernate.impl.SessionImpl.fireDelete(Lorg/hibernate/event/DeleteEvent;)V(SessionImpl.java:768)
 at org.hibernate.impl.SessionImpl.delete(Ljava/lang/Object;)V(SessionImpl.java:746)
 at org.jbpm.db.GraphSession.deleteProcessDefinition(Lorg/jbpm/graph/def/ProcessDefinition;)V(GraphSession.java:249)
18:48:00,733 ERROR [GraphSession] org.hibernate.HibernateException: null index column for collection: org.jbpm.graph.def.ProcessDefinition.actions

Version de jBPM : 3.2.1

[kukeltje]

http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3996973#3996973

if it helps... remember.... 3 words in google... null index jbpm... and then the first hit.

If not, I have no idea.

[tinico]

No, I've verified, all my jbpm context that I've created are closed... In all my classes, I write that :

JbpmContext jbpmContext = jbpmconf.createJbpmContext();

try {
 ...code...
}
finally {
 jbpmContext.close();
}

So, I don't think the problem is that... When I remove "notify='yes' ", it work !!

Someone have any idea(s) ??

[mputz]

To me this looks like a bug. I'm having a closer look at the mappings now - in the meantime, could you enter a JIRA entry for this?

[mputz]

created this JIRA issue:

http://jira.jboss.com/jira/browse/JBPM-1043

[tejjbpm]

Thanks for updating the JIRA details..i got the same bug now and i am recompiling the files with the change as i had to stick with JBPM 3.2.1..