[Archivesspace_Users_Group] database integrity constraint conflict

Chris Fitzpatrick Chris.Fitzpatrick at lyrasis.org
Fri Jul 17 16:23:04 EDT 2015

Hi Maureen,

Which version are you all using? Was this record transferred recently?


Chris Fitzpatrick | Developer, ArchivesSpace
Skype: chrisfitzpat  | Phone: 918.236.6048

From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of Galligan, Patrick <PGalligan at rockarch.org>
Sent: Friday, July 17, 2015 9:33 PM
To: Archivesspace Users Group
Subject: Re: [Archivesspace_Users_Group] database integrity constraint conflict


I'm just chiming in to say this has also been happening at the RAC. The only fix we've found is to resequence each time we transfer components, which is obviously not ideal.

We are not on the newest version of AS though.

Patrick Galligan

Rockefeller Archive Center

Assistant Digital Archivist


From: archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of Callahan, Maureen
Sent: Friday, July 17, 2015 1:45 PM
To: 'archivesspace_users_group at lyralists.lyrasis.org'
Cc: Connolly, Christine; Caldera, Mary
Subject: [Archivesspace_Users_Group] database integrity constraint conflict

Hey folks,

I'm getting this error:

en.validation_errors.database_integrity_constraint_conflict__java__commysqljdbcexceptionsjdbc4__mysqlintegrityconstraintviolationexception__duplicate_entry__2101963 at archival_object-4__for_key__uniq_ao_pos_<mailto:en.validation_errors.database_integrity_constraint_conflict__java__commysqljdbcexceptionsjdbc4__mysqlintegrityconstraintviolationexception__duplicate_entry__2101963 at archival_object-4__for_key__uniq_ao_pos_>

when I try to save archival objects that had been transferred from another resource record. For instance, this archival object is number 2102081 but it looks like it's telling me that it conflicts with archival object 2101963. I'm happy to do something to change one of the sets of records, but it would be helpful to know what that change needs to look like and how I can avoid this constraint in the future.



Maureen Callahan

Archivist, Metadata Specialist

Manuscripts & Archives

Yale University Library

maureen.callahan at yale.edu<mailto:maureen.callahan at yale.edu>


Webpage: web.library.yale.edu/mssa

Collections: drs.library.yale.edu

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150717/cac9d85e/attachment.html>

More information about the Archivesspace_Users_Group mailing list