Hi,
DSpace v6.2, JSPUI . . .
I'm currently working on a REST API integration between our CRIS and a DSpace
v6.2 DEV system (upgraded from v4.2, and 3.x before that, and 1.4 before
that!). As Workflow will be carried out in the CRIS, I want to remove the
existing Workflow groups for all the relevant Collections from our DSpace, but
I'm not having any luck.
If (as an Administrator) I go to an Edit Collection page and click "Delete" on
either of the 2 Workflow steps we are using ("Accept/Reject/Edit Metadata" and
"Edit Metadata"), I get the following Internal Server Error:
2017-12-18 14:03:05,648 WARN org.dspace.app.webui.servlet.DSpaceServlet @
[email protected]:session_id=BD31AC823C9C7EF5DCF908B28E227ACE:ip_addr=139.153.86.2:general_jspui_error:org.hibernate.ObjectDeletedException\colon;
deleted object would be re-saved by cascade (remove deleted object from
associations)\colon; [org.dspace.authorize.ResourcePolicy#2902770]
org.hibernate.ObjectDeletedException: deleted object would be re-saved by
cascade (remove deleted object from associations):
[org.dspace.authorize.ResourcePolicy#2902770]
at org.hibernate.internal.SessionImpl.forceFlush(SessionImpl.java:1208)
at
org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:184)
at
org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:114)
at
org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:90)
at
org.hibernate.internal.SessionImpl.fireSaveOrUpdate(SessionImpl.java:654)
at org.hibernate.internal.SessionImpl.saveOrUpdate(SessionImpl.java:646)
at
org.hibernate.engine.spi.CascadingAction$5.cascade(CascadingAction.java:258)
at org.hibernate.engine.internal.Cascade.cascadeToOne(Cascade.java:396)
<snip>
- which appears to be telling me that I can't delete the Workflow group because
it is still associated with something (but I'm not sure what!) . . .
. . . and if I try to first remove the ePeople/Groups from the Workflow Group,
I also get an Internal System Error:
2017-12-18 14:18:55,451 WARN org.dspace.app.webui.servlet.DSpaceServlet @
[email protected]:session_id=892C49738C889568C97E4190EB484B63:ip_addr=139.153.86.2:general_jspui_error:java.util.ConcurrentModificationException
java.util.ConcurrentModificationException
at java.util.ArrayList$Itr.checkForComodification(ArrayList.java:907)
at java.util.ArrayList$Itr.next(ArrayList.java:857)
at
org.hibernate.collection.internal.AbstractPersistentCollection$IteratorProxy.next(AbstractPersistentCollection.java:810)
at
org.dspace.app.webui.servlet.admin.GroupEditServlet.doDSPost(GroupEditServlet.java:206)
at
org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:122)
at
org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:80)
- and if I try to simply delete the Group, I also get an error:
2017-12-18 14:21:29,734 ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper
@ ERROR: update or delete on table "epersongroup" violates foreign key
constraint "collection_workflow_step_3_fkey" on table "collection"
Detail: Key (uuid)=(245798d7-ff77-415d-be09-e74ec1556079) is still referenced
from table "collection".
2017-12-18 14:21:29,735 WARN org.dspace.app.webui.servlet.DSpaceServlet @
[email protected]:session_id=892C49738C889568C97E4190EB484B63:ip_addr=139.153.86.2:general_jspui_error:org.hibernate.exception.ConstraintViolationException\colon;
could not execute statement
org.hibernate.exception.ConstraintViolationException: could not execute
statement
at
org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:129)
at
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124)
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
- which appears to be telling me that I can't delete the Group because it is
still referenced (as a Workflow Group) in the database entry for the Collection
(which brings me back to step 1!).
I've been through and checked (as best I can) that there aren't any items in
Workflow for the Collection I'm trying to delete the Workflow groups for (and I
tested against a wide range of Collections). I do note quite a lot of "partial
submissions" (?) in the "workspaceitem" table, but I'm not able to delete
Workflow groups related to Collections that don't appear in the "workspaceitem"
table (so whilst this may be an issue for some Collections, it isn't the case
for all Collections?).
I've had a poke about in JIRA (in case I'd hit a known bug) and the mailing
list archives, but I couldn't find anything relevant, so I'm now at a loss as
to how I should go about deleting all the required Workflow groups :-(
Am I doing something daft? Does anyone have any suggestions how I can safely
delete existing Workflow groups?
Any assistance very gratefully received as I'm currently struggling to get past
this and I'm totally held up until I do!
Cheers,
Mike
Michael White
Senior Developer
Business Applications and Integrations
T: (01786) 466877
E: [email protected]<mailto:[email protected]>
A: G5, Airthrey Castle, University of Stirling, Stirling, FK9 4LA
--
The University achieved an overall 5 stars in the QS World University Rankings
2016/17
The University of Stirling is a charity registered in Scotland,
number SC 011159.
--
You received this message because you are subscribed to the Google Groups
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.
