An error occurred while deleting the item - DSpace 7.2

[Evelin Bányai]

Dear All,

We have a problem with one particular item which cannot be deleted. Probably due to this we cannot delete the parent collection and community of this item. When we try to permanently delete it we get the following message:

An error occurred while deleting the item.

I can see this error message in the inspector:

DELETE [url_of_the_item] 500

Can anyone help us to solve this issue? 

We can withdraw the item, but we need to delete the community and its collection, and simply withdrawing this bad item doesn't help. We are able to delete other items/collections.

Thanks,

Evelin

[Aroldo Rique]

Did you manage to solve the problem?
I have a similar error currently (dspace 7.5). When trying to delete an item, the following error occurs: "An error occurred while deleting the item".
This happens when I try to delete anything, be it community, collection, item, or even a bitstream of an item. No error message appears in the log. I don't know what to do anymore...

[Aroldo Rique]

Error 403...

--
All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx
---
You received this message because you are subscribed to a topic in the Google Groups "DSpace Technical Support" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/dspace-tech/mDJd_OtXo5Y/unsubscribe.
To unsubscribe from this group and all its topics, send an email to dspace-tech...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/a604d722-7451-4228-9544-2b1791d9fca7n%40googlegroups.com.

[Aroldo Rique]

We found the problem. It was missing to enable the delete command in the reverse proxy.

[Evelin Bányai]

Thanks for the info and the update. 

No, not really. I'll try and look if I can see anything on the server side. Unfortunately, we have error code 500... and there is only one un-deletable item. Otherwise deleting anything else works fine.

[Evelin Bányai]

Okay, I see the following error on the server side:

Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table "item" violates foreign key constraint "requestitem_item_id_fkey" on table "requestitem" Detail: Key (uuid)=(0db42ab6-6e51-4c4b-a04c-d043ef63247b) is still referenced from table "requestitem".

What is the safest why to deal with this issue?

Thanks,

Evelin

[DSpace Technical Support]

Hi Evelin,

This was a bug that was fixed in 7.5: https://github.com/DSpace/DSpace/issues/8654   Here's the fix: https://github.com/DSpace/DSpace/pull/8660

So, the safest approach is to upgrade to 7.5 or 7.6 and that will allow you to delete this Item.

Otherwise, you could manually delete that row in your  "requestitem" database table. 

Tim

[Evelin Bányai]

Dear Tim,

Thank you for your reply. We might have to upgrade sooner or later, but for the time being I ended up removing the reference from the "requestitem" table manually.

Thanks,

Evelin