[Archivesspace_Users_Group] That ID is already in use problem and not being able to delete

Christine Di Bella christine.dibella at lyrasis.org
Wed Aug 8 10:15:29 EDT 2018

Hi Julie,

Typically this error comes up because something remained in your database after a delete, merge, or transfer - possibly because something happened while one of those was occurring that made the operation not fully complete. In most cases those records become "orphans" since they're no longer attached to anything.

To resolve the problem, look in your MySQL database for something with this ref_id - you will have to look directly in the database since it's not coming up via search or browse.  - and then do a MySQL update to get rid of that particular problem record from the database. There's some information on queries for locating and getting rid of orphan records in the ticket at https://archivesspace.atlassian.net/browse/ANW-220. Remember that backing up and testing first are really important before doing anything with the database.

A plugin is in the works that will make that process a little easier, but especially if it's only a small amount of problem data, there's no need to wait for that to resolve your issue.

If you need help with any of this, feel free to contact us directly at ArchivesSpaceHome at lyrasis.org<mailto:ArchivesSpaceHome at lyrasis.org> and we'll be glad to put a tech support ticket in for you.


Christine Di Bella
ArchivesSpace Program Manager
christine.dibella at lyrasis.org<mailto:christine.dibella at lyrasis.org>
800.999.8558 x2905
cdibella13 (Skype)


From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> On Behalf Of Wetherill, Julie M.
Sent: Monday, August 6, 2018 2:45 PM
To: archivesspace_users_group at lyralists.lyrasis.org
Subject: Re: [Archivesspace_Users_Group] That ID is already in use problem and not being able to delete

Hi Christine,

Harvard has experienced the same problem re: unable to re-import after deleting a record. In our case, a resource was deleted and any attempt to re-import produces the error "ref_id : An Archival Object Ref ID must be unique to its resource". The deleted resource is not findable thru search or browse, but we suspect some fragments of it were left behind in the index and preventing the re-import.

Has there been any progress on identifying the problem? Thanks. -julie

Julie Wetherill
Library Technology Services
Harvard University
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20180808/0011a622/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 6608 bytes
Desc: image002.jpg
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20180808/0011a622/attachment.jpg>

More information about the Archivesspace_Users_Group mailing list