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
