Hej,
Thanks Peter. I got rid of my submission and the test collections by simply
approving the submission, which made it exit workflow and possible to withdraw.
Once the post was withdrawn it was possible to delete the two test collections.
However, it does seem like an issue. The possibility to assign two collections
to an item in a csv-import is also not documented (which might be a good thing
considering the issue).
We use 4.1 XMLUI
Cheers,
Jacob
-----------------------
Jacob Andersson
Librarian
Library & IT
Malmö University
205 06 Malmö
Sweden
+46-(0)40-66 58387
[email protected]
Från: Peter Dietz [mailto:[email protected]]
Skickat: den 26 september 2014 16:41
Till: Jacob Andersson
Kopia: [email protected]
Ämne: Re: [Dspace-tech] Removing submission mapped to 2nd colelction
God dag Jacob,
Perhaps there is an issue in the workflow step rejection logic, where it isn't
considering the mapped collection, only the primary collection. That would be
wise for someone to look into.
Unfortunately, your item is in a weird state, and I think you'll need to use
SQL to manually delete this item.
First, try to directly access this item, and delete it from DSpace:
http://example.edu/xmlui/admin/item
Use itemID of: 29244
If that doesn't work, here is some SQL that might help you get further. The
safest route to follow would be to make a backup of your database, and set up a
testing instance of your DSpace, and practice the following advice on your
testing instance of DSpace. If that succeeds, then consider doing it on the
production instance.
## See which collections this item is connected to:
SELECT * FROM public.collection2item WHERE collection2item.item_id = 29244;
That might return you two records. Maybe one with collection_id of 10, and
another with collection_id of 20. If you figure out which of those
collectionID's correspond to the secondary/mapped collection, you might be able
to just delete the secondary mapping (leaving the item connected to the primary
collection).
## Delete the second collection from being connected (assuming collection_id 20
is the second collection).
BEGIN;
DELETE FROM public.collection2item WHERE collection2item.item_id = 29244 AND
collection2item.collection_id = 20;
COMMIT;
Then, try to go back to where you were using DSpace to delete the item. It's
best if DSpace can do the item deletion, since there are a lot of database
relationships to catch.
Hope this helps
________________
Peter Dietz
Longsight
www.longsight.com<http://www.longsight.com>
[email protected]<mailto:[email protected]>
p: 740-599-5005 x809
On Fri, Sep 26, 2014 at 4:34 AM, Jacob Andersson
<[email protected]<mailto:[email protected]>> wrote:
Hej!
I did a csv-file import where I entered two values in the collection column.
This imports the item to the first collection and maps it to the second
collection. The import was made into the workflows of the collections.
In the workflow the item was rejected back to me. I then tried to remove the
submission, which resulted in the following error:
org.postgresql.util.PSQLException: ERROR: update or delete on table "item"
violates foreign key constraint "coll2item_item_fk" on table "collection2item"
Detail: Key (item_id)=(29244) is still referenced from table "collection2item".
I’m assuming it’s because the item has a mapping to a second collection.
So, I can’t remove the submission.
I can also not delete the test-collections I created for this test-import:
org.postgresql.util.PSQLException: ERROR: update or delete on table "item"
violates foreign key constraint "$1" on table "workspaceitem"
Detail: Key (item_id)=(29244) is still referenced from table "workspaceitem".
/Jacob
-----------------------
Jacob Andersson
Librarian
Library & IT
Malmö University
205 06 Malmö
Sweden
+46-(0)40-66 58387
[email protected]<mailto:[email protected]>
------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
_______________________________________________
DSpace-tech mailing list
[email protected]<mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
------------------------------------------------------------------------------
Slashdot TV. Videos for Nerds. Stuff that Matters.
http://pubads.g.doubleclick.net/gampad/clk?id=160591471&iu=/4140/ostg.clktrk
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
