Tim, spot on with your 'guess' here :-) I was actually tipped off to that script by and off-list mail. Running this fixed up my issue and I'm back in business migrating content from the old 1.3.bla system.
Thanks again. We'll let the archives keep this note that running the script fixed things up .. :-) ------ thanks kevin.foote On Mon, 22 Aug 2011, Tim Donohue wrote: -> Kevin, -> -> It sounds like somehow your database handle sequence has gotten messed -> up. This sequence is used to assign the next handle (and it just -> increments by one each time). It sounds like it may be attempting to -> assign a handle that already exists. -> -> If that's the case, running the following database script should fix -> things: -> -> [dspace]/etc/postgres/update-sequences.sql -> -> All that script does is ensure all the Database sequences are set to -> the next available value. -> -Tim -> -> On Thursday, August 18, 2011 1:35:14 PM, Kevin P. Foote wrote: -> > Hello all -> > -> > Working on (still) upgrading our dspace from 1.3.SOMETHING to 1.7.1 ... -> > -> > I'm getting some data moved over to the new host using the methods that -> > are outlined on this page[1]. This seems to be working for the most -> > part. -> > -> > However, I'm now trying to create a new temporary category for something -> > else and I'm getting the error below: -> > -> > --- -> > org.postgresql.util.PSQLException: ERROR: duplicate key value violates -> > -> unique constraint "handle_handle_key" -> > --- -> > -> > The full stack page is viewable here[2]. -> > -> > Additionally I have a general inquiry about importing items into dspace. -> > When you import an item into dspace it is given a unique content identifier -> > (number) within that particular dspace system .. correct? So their -> > should be no conflicts with items I've already imported or trying to -> > create new content. -> > -> > -> > -> > [1] -> > http://wiki.lib.sun.ac.za/index.php/SUNScholar/Asset_Import_and_Export -> > -> > [2] http://www.people.iup.edu/kpfoote/stuff/dspace-stack.html -> > -> > -> > ------ -> > thanks -> > kevin.foote -> > -> > ------------------------------------------------------------------------------ -> > Get a FREE DOWNLOAD! and learn more about uberSVN rich system, -> > user administration capabilities and model configuration. Take -> > the hassle out of deploying and managing Subversion and the -> > tools developers use with it. http://p.sf.net/sfu/wandisco-d2d-2 -> > ________________________________________ -> _______ -> > DSpace-tech mailing list -> > [email protected] -> > https://lists.sourceforge.net/lists/listinfo/dspace-tech -> -> ------------------------------------------------------------------------------ -> uberSVN's rich system and user administration capabilities and model -> configuration take the hassle out of deploying and managing Subversion and -> the tools developers use with it. Learn more about uberSVN and get a free -> download at: http://p.sf.net/sfu/wandisco-dev2dev -> _______________________________________________ -> DSpace-tech mailing list -> [email protected] -> https://lists.sourceforge.net/lists/listinfo/dspace-tech -> ------------------------------------------------------------------------------ EMC VNX: the world's simplest storage, starting under $10K The only unified storage solution that offers unified management Up to 160% more powerful than alternatives and 25% more efficient. Guaranteed. http://p.sf.net/sfu/emc-vnx-dev2dev _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
