<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 15 (filtered medium)">
<style><!--
/* Font Definitions */
@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:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:"Courier New";}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.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" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Alston,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">This is a type of error I used to encounter frequently but haven’t seen in the more recent versions of ASpace. That makes me curious if you could share what version of ArchivesSpace your are currently on? You can see this information in
the footer on any page on the staff side, like v 2.7.1.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">-Valerie<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org>
<b>On Behalf Of </b>Cobourn, Alston<br>
<b>Sent:</b> Wednesday, February 1, 2023 10:02 AM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> [Archivesspace_Users_Group] trouble deleting some archival objects<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Hello,<o:p></o:p></p>
<pre style="margin-bottom:7.5pt;background:white;word-break:break-all"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">We’ve been running into an issue periodically where archival objects won’t delete. AS returns this message</span><span style="color:black">: </span><span style="font-family:Consolas;color:#333333">Record deletion failed: Java::JavaSql::SQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`archivesspace`.`lang_material`, CONSTRAINT `lang_material_ibfk_1` FOREIGN KEY (`archival_object_id`) REFERENCES `archival_object` (`id`))<o:p></o:p></span></pre>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Our wonderful IT guy explained it to me as “There’s a relationship in the database that ArchivesSpace is (sometimes?) not removing when an archival object is being deleted.” He’s not sure if it’s an AS issue or a problem with our data.
He has solved the problem each time for us by manually removing the language_and_script object, so he can then remove the lang_material object, so I can then remove the archival_object.<o:p></o:p></p>
<p class="MsoNormal">More details:<o:p></o:p></p>
<p class="MsoNormal">Table: <o:p></o:p></p>
<p class="MsoNormal"> archival_object - objects have an aoID<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Table:<o:p></o:p></p>
<p class="MsoNormal"> lang_material - objects have a langID and are related to the archival_object table via the aoID<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Table:<o:p></o:p></p>
<p class="MsoNormal"> language_and_script - objects are related to the lang_material table via the langID
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Are others running into this? I would like to determine if this is an AS bug or something specific with our data.<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">Alston Cobourn, MLS, CA<o:p></o:p></p>
<p class="MsoNormal">Head, University History and Records<o:p></o:p></p>
<p class="MsoNormal">East Carolina University<o:p></o:p></p>
<p class="MsoNormal">252-328-4090<o:p></o:p></p>
<p class="MsoNormal"><a href="mailto:Cobourna18@ecu.edu">Cobourna18@ecu.edu</a><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>