<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal><span style='color:#1F497D'>Maureen,<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><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.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>We are not on the newest version of AS though.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><div><p class=MsoNormal><span style='color:#1F497D'>Patrick Galligan<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Rockefeller Archive Center<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Assistant Digital Archivist<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>914-366-6386<o:p></o:p></span></p></div><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><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<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Hey folks,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I’m getting this error:<o:p></o:p></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica","sans-serif";color:#B94A48;background:#F2DEDE'><a 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><o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>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.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thanks,<o:p></o:p></p><p class=MsoNormal>Maureen<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Maureen Callahan<o:p></o:p></p><p class=MsoNormal><span style='color:#404040'>Archivist, Metadata Specialist<o:p></o:p></span></p><p class=MsoNormal><span style='color:#404040'>Manuscripts & Archives<o:p></o:p></span></p><p class=MsoNormal><span style='color:#404040'>Yale University Library<o:p></o:p></span></p><p class=MsoNormal><span style='color:#8496B0'><a href="mailto:maureen.callahan@yale.edu"><span style='color:#8496B0'>maureen.callahan@yale.edu</span></a><o:p></o:p></span></p><p class=MsoNormal><span style='color:#404040'>203.432.3627<o:p></o:p></span></p><p class=MsoNormal><span style='color:#7F7F7F'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#404040'>Webpage:</span><span style='color:#7F7F7F'> </span><span style='color:#8496B0'><a href="web.library.yale.edu/mssa"><span style='color:#8496B0'>web.library.yale.edu/mssa</span></a></span><span style='color:#7F7F7F'><o:p></o:p></span></p><p class=MsoNormal><span style='color:#404040'>Collections:</span><span style='color:#7F7F7F'> </span><span style='color:#8496B0'><a href="drs.library.yale.edu"><span style='color:#8496B0'>drs.library.yale.edu</span></a></span><span style='color:#7F7F7F'><o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>