Thanks all it seems working fine for me also now.


On Fri, Aug 29, 2014 at 1:40 PM, Michael White <michael.white@stir.ac.uk> wrote:
Hi,

> When i attempt to delete item through JSPUI interface it gives internal system
> error message but when i delete the same through xmlui interface it aslo
> gives some error:

I came across the same problem with my upgrade from v1.6 to v4.1 last week - my understanding is that it is due to old data in the database that relates to the (legacy) Lucene indexing system used in the earlier versions - if you have switched to using the Discovery (SOLR) Browse/Search indexing system in v4.2 (which is the default out of the box), then the old Lucene data lying around in the database is preventing items from being deleted (due to a foreign key constraint on one of the tables used by the old Lucene system).

I also asked the question on the list, and Hilton Gibson kindly sent me these links which helped to confirm my suspicions:

--------------------------------------------------------------
Perhaps these links help.
http://wiki.lib.sun.ac.za/index.php/SUNScholar/Browse_Indexes/3.2#WARNING
http://wiki.lib.sun.ac.za/index.php/SUNScholar/Upgrading/DSpace/Release_Notes/3.X#During_our_upgrade_from_1.8.2_to_3.2.2C_the_following_errors_were_discovered_after_applying_the_upgrade_to_our_production_server
http://wiki.lib.sun.ac.za/index.php/SUNScholar/Upgrading/DSpace/Release_Notes/4.X
--------------------------------------------------------------

The advice on those pages suggests making changes in the database directly, which you may or may not be comfortable doing.

Instead of running SQL against the database directly, though, simply rebuilding the Lucene index as just empty tables with the following command seemed to do the trick for me (and no one on the list came back to me and said "don't do it that way because . . .", so I'm pretty sure it is OK):

[dspace]/bin/dspace index-lucene-init -r -t -v

When I ran this, it did throw an error (basically saying something about not setting up caching because SOLR is better, but I don't recall exactly) and most of the Lucene related tables actually disappeared! - but once I'd run it, I was able to delete items from my repository again, and I haven't noticed any other issues as a result.

I hope that helps.

Regards,

Mike

Michael White
eLearning Liaison and Development (eLD)
Information Services
S8, Library
University of Stirling
Stirling SCOTLAND
FK9 4LA
Email: michael.white@stir.ac.uk
Tel: +44 (0) 1786 466877
Fax: +44 (0) 1786 466880
http://www.stir.ac.uk/is/staff/about/teams/aldt/#eld


>
> Message: 1
> Date: Thu, 28 Aug 2014 09:47:40 +0530
> From: vinod mishra <mishravk79@gmail.com>
> Subject: [Dspace-tech] Item delete problem
> To: "dspace-tech@lists.sourceforge.net"
>       <dspace-tech@lists.sourceforge.net>,    General List
>       <dspace-general@lists.sourceforge.net>
> Message-ID:
>       <CAGLUwiTvs+QdVdeSFuHcuaLinANJJc0qi3Dwn=EEE1hrEtmkuw@mail
> .gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Dear All,
>
> When i attempt to delete item through JSPUI interface it gives internal system
> error message but when i delete the same through xmlui interface it aslo
> gives some error:
>
> "org.postgresql.util.PSQLException: ERROR: update or delete on table "item"
> violates foreign key constraint "$2" on table "collection2item""
> Detail: Key (item_id)=(429349) is still referenced from table
> "collection2item""
>
> But ultimately it seems to be deleted, i have updated my dspace 1.2.1 to 4.2
> by upgrading dabase schema as instructed for multiversion update option
> available at:
> https://wiki.duraspace.org/display/DSDOC4x/Multi-
> Version+Upgrade+Tips+and+Tricks
>
> Kindly suggest for correcting the error.
>
>
>
> --
> With Regards,
> Vinod Kumar Mishra,
> Assistant Librarian,
> Biju Patnaik Central Library (BPCL),
> NIT Rourkela.
> Mob:91+9439420860
> -------------- next part --------------
> An HTML attachment was scrubbed...
>


--
The University of Stirling has been ranked in the top 12 of UK universities for graduate employment*.
94% of our 2012 graduates were in work and/or further study within six months of graduation.
*The Telegraph
The University of Stirling is a charity registered in Scotland, number SC 011159.




--
With Regards,
Vinod Kumar Mishra,
Assistant Librarian,
Biju Patnaik Central Library (BPCL),
NIT Rourkela.
Mob:91+9439420860