Hi Andrew, I'm assuming you are looking at the URI from the DSpace 7 User Interface? If so, that's the "dc.identifier.uri" on that particular object. So you'd want to update your "dc.identifier.uri" field values. You could do this in bulk for Items by using the Batch Metadata Editing tool: https://wiki.lyrasis.org/display/DSDOC7x/Batch+Metadata+Editing
Or, there are other threads that point out how to do this at the database level (via SQL): For example, this one on dspace-devel: https://groups.google.com/g/dspace-devel/c/y-Mj8D2xpGM And this one on dspace-tech: https://groups.google.com/g/dspace-tech/c/njX68ISjJ3s/m/VuiUYmDvAQAJ Definitely keep in mind that some questions come up frequently, and it's worth a quick search or two to see if you can find the answer already on these lists. Tim On Thursday, October 19, 2023 at 12:39:53 PM UTC-5 DSpace Technical Support wrote: > Hello Tim, > > Thank you! It did the job perfectly. I found and deleted 3 duplicate items. > > Another question now. > All the imported items have URI > http://oldserver/jspui/handle/123456789/12345 > But I need them https://newserver/handle/123456789/12345 > What is the best way to replace all at once? > > Thanks, > Andrew > > понеділок, 16 жовтня 2023 р. о 23:13:11 UTC+3 DSpace Technical Support > пише: > >> Hi Andrew, >> >> Apologies for not getting back to this. I'm not always able to answer >> questions on this list quickly, but I see no one else has gotten to this >> one. >> >> The "More than one result found" error appears to be saying that somehow >> you have *two* WorkspaceItem objects that link to the same Item. In other >> words, somehow you have two entries in the "workspaceitem" table which have >> the *same value* in the "item_id" column. That's not supposed to be >> possible in DSpace, as every workspace Item should be linked to a different >> Item. >> >> You should be able to find the duplicate entry by running something like >> this: >> >> select item_id, COUNT(item_id) from workspaceitem group by item_id >> having count(item_id)>1; >> >> That should return duplicate "item_id" values. Then, for each, you'd >> have to find the duplicate rows: >> select * from workspaceitem where item_id=[value]; >> >> It's unclear to me why you have duplicates, but there should not be two >> rows with the same "item_id". So, you should delete one of them. >> >> It's difficult to answer your other question about the "psql" role. It >> might be possible to ignore if that role is no longer necessary in your new >> setup. But, if you notice odd permissions errors, then it's possible that >> role is needed. >> >> Tim >> On Friday, October 6, 2023 at 3:02:06 PM UTC-5 Andrew K wrote: >> >>> I probably should have mentioned that I run >>> *sudo /dspace/bin/dspace index-discovery -b* >>> on the new server first and it went OK. >>> After that I did >>> *sudo /dspace/bin/dspace filter-media* >>> and then >>> *sudo /dspace/bin/dspace index-discovery* >>> throws the error *java.lang.IllegalArgumentException: More than one >>> result found* >>> >>> Another question. >>> I moved the database and assetstore to the new server. >>> Then I did >>> *sudo /dspace/bin/dspace filter-media* >>> It took more than a day to complete (12+K items). >>> Now I try >>> *sudo /dspace/bin/dspace index-discovery* >>> but it fails: >>> >>> >>> >>> >>> *The script has startedUpdating Indexjava.lang.IllegalArgumentException: >>> More than one result found at >>> org.dspace.core.AbstractHibernateDAO.uniqueResult(AbstractHibernateDAO.java:242) >>> >>> at >>> org.dspace.content.dao.impl.WorkspaceItemDAOImpl.findByItem(WorkspaceItemDAOImpl.java:81)* >>> >>> -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/2fbbcc4c-20e0-419d-b58f-dc25a41ce428n%40googlegroups.com.
