<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p>Hi Maureen,</p>
<p><br>
</p>
<p>Which version are you all using? Was this record transferred recently?</p>
<p><br>
</p>
<p>b,chris. <br>
</p>
<p><br>
</p>
<div id="Signature">
<div name="divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:; margin:0">
<div class="BodyFragment"><font size="2">
<div class="PlainText">Chris Fitzpatrick | <font size="2">Developer, ArchivesSpace</font><br>
Skype: chrisfitzpat | Phone: 918.236.6048<br>
http://archivesspace.org/<br>
</div>
</font></div>
</div>
</div>
<br>
<br>
<div style="color: rgb(0, 0, 0);">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Galligan, Patrick
<PGalligan@rockarch.org><br>
<b>Sent:</b> Friday, July 17, 2015 9:33 PM<br>
<b>To:</b> Archivesspace Users Group<br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] database integrity constraint conflict</font>
<div> </div>
</div>
<div>
<div style="">
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color:#1F497D">Maureen,</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color:#1F497D"> </span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color:#1F497D">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.</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color:#1F497D"> </span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color:#1F497D">We are not on the newest version of AS though.</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color:#1F497D"> </span></p>
<div>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color:#1F497D">Patrick Galligan</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color:#1F497D">Rockefeller Archive Center</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color:#1F497D">Assistant Digital Archivist</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color:#1F497D">914-366-6386</span></p>
</div>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color:#1F497D"> </span></p>
<div>
<div style="border:none; border-top:solid #B5C4DF 1.0pt; padding:3.0pt 0in 0in 0in">
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<b><span style="font-size:10.0pt; font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt; font-family:"Tahoma","sans-serif""> archivesspace_users_group-bounces@lyralists.lyrasis.org [mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org]
<b>On Behalf Of </b>Callahan, Maureen<br>
<b>Sent:</b> Friday, July 17, 2015 1:45 PM<br>
<b>To:</b> 'archivesspace_users_group@lyralists.lyrasis.org'<br>
<b>Cc:</b> Connolly, Christine; Caldera, Mary<br>
<b>Subject:</b> [Archivesspace_Users_Group] database integrity constraint conflict</span></p>
</div>
</div>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
</p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
Hey folks,</p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
</p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
I’m getting this error:</p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="font-size:10.0pt; font-family:"Helvetica","sans-serif"; color:#B94A48; background:#F2DEDE"><a style="color: rgb(5, 99, 193); text-decoration: underline;" href="mailto:en.validation_errors.database_integrity_constraint_conflict__java__commysqljdbcexceptionsjdbc4__mysqlintegrityconstraintviolationexception__duplicate_entry__2101963@archival_object-4__for_key__uniq_ao_pos_">en.validation_errors.database_integrity_constraint_conflict__java__commysqljdbcexceptionsjdbc4__mysqlintegrityconstraintviolationexception__duplicate_entry__2101963@archival_object-4__for_key__uniq_ao_pos_</a></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
</p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
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.</p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
</p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
Thanks,</p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
Maureen</p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
</p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
Maureen Callahan</p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color:#404040">Archivist, Metadata Specialist</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color:#404040">Manuscripts & Archives</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color:#404040">Yale University Library</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color:#8496B0"><a style="color: rgb(5, 99, 193); text-decoration: underline;" href="mailto:maureen.callahan@yale.edu"><span style="color:#8496B0">maureen.callahan@yale.edu</span></a></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color:#404040">203.432.3627</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color:#7F7F7F"> </span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color:#404040">Webpage:</span><span style="color:#7F7F7F"> </span><span style="color:#8496B0"><a style="color: rgb(5, 99, 193); text-decoration: underline;" href="web.library.yale.edu/mssa"><span style="color:#8496B0">web.library.yale.edu/mssa</span></a></span><span style="color:#7F7F7F"></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color:#404040">Collections:</span><span style="color:#7F7F7F"> </span>
<span style="color:#8496B0"><a style="color: rgb(5, 99, 193); text-decoration: underline;" href="drs.library.yale.edu"><span style="color:#8496B0">drs.library.yale.edu</span></a></span><span style="color:#7F7F7F"></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
</p>
</div>
</div>
</div>
</div>
</body>
</html>