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-boun...@lyralists.lyrasis.org
On Behalf Of Cobourn,
Alston
Sent: Wednesday, February 1, 2023 10:02 AM
To: Archivesspace Users Group
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
cobourn...@ecu.edu<mailto:cobourn...@ecu.edu>
___
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group@lyralists.lyrasis.org
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group