Hi, I am investigating upgrading my University's DSpace instance from 5.6 to 7.6.1, moving to a new server in the process, following https://wiki.lyrasis.org/display/DSDOC7x/Migrating+DSpace+to+a+new+server. Starting with little knowledge of DSpace, both server- and user-side, I have been able to get 7.6.1 up and running as a fresh install, and have moved on to dumping/restoring the database etc.
After successfully restoring the database from a dump and running "dspace migrate ignored", both "dspace index-discovery -b" and "dspace oai import" fail with "java.lang.IllegalArgumentException: More than one result found" and a stack trace resembling what is reported ("Another question") in https://groups.google.com/g/dspace-tech/c/DIIDMcoWSzk/m/JPvN1E_qBgAJ. In my case, "select item_id, COUNT(item_id) from workspaceitem group by item_id having count(item_id)>1;" yields 71 duplicated IDs, mostly with a count of 2 and a handful with 3. In most cases, the workflow_item_id is the only difference between the duplicated rows but there are some with various other differences as well. I assume that ultimately the only solution is to delete the duplicates, as mentioned in the above link, but how should I decide which one to keep (and what other implications are there)? Thanks, Alex -- 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 the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/LO0P265MB5432D90EF8FFB2C3721829F2CB7C2%40LO0P265MB5432.GBRP265.PROD.OUTLOOK.COM.