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: [email protected] 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 <[email protected]> > Subject: [Dspace-tech] Item delete problem > To: "[email protected]" > <[email protected]>, General List > <[email protected]> > 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. ------------------------------------------------------------------------------ Slashdot TV. Video for Nerds. Stuff that matters. http://tv.slashdot.org/ _______________________________________________ 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
