[Archivesspace_Users_Group] trouble deleting some archival objects

[Valerie Addonizio]

Alston,

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.

-Valerie

From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> On Behalf Of Cobourn, Alston
Sent: Wednesday, February 1, 2023 10:02 AM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: [Archivesspace_Users_Group] trouble deleting some archival objects

Hello,

We've been running into an issue periodically where archival objects won't delete.  AS returns this message: 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`))

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.
More details:
Table:
    archival_object - objects have an aoID

Table:
    lang_material - objects have a langID and are related to the archival_object table via the aoID

Table:
    language_and_script - objects are related to the lang_material table via the langID

Are others running into this?  I would like to determine if this is an AS bug or something specific with our data.

Thanks,
Alston Cobourn, MLS, CA
Head, University History and Records
East Carolina University
252-328-4090
Cobourna18 at ecu.edu<mailto:Cobourna18 at ecu.edu>

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