[Archivesspace_Users_Group] Error when deleting location despite no linked records

Mark Cooper mark.cooper at lyrasis.org
Thu Jun 29 11:42:01 EDT 2017

Hi Craig,

That error appears related to some leftover cruft from the container conversion upgrade. The housed_at_rlshp table is a legacy table related to the legacy container table (not top containers) and location. The v2.1.0 release is under active testing, looking good for July, and removes all of the legacy data so it should resolve things for you (the release candidate is available if you want to test with a copy of your database: https://github.com/archivesspace/archivesspace/releases/download/v2.1.0-RC1/archivesspace-v2.1.0-RC1.zip).



Mark Cooper
Technical Lead, Hosting and Support
email: mark.cooper at lyrasis.org
skype: mark_c_cooper
From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of Craig P Savino <craig.savino at nyu.edu>
Sent: Thursday, June 29, 2017 8:00:48 AM
To: Archivesspace Users Group
Subject: [Archivesspace_Users_Group] Error when deleting location despite no linked records


We have not been able to replicate the following problem in the ASpace test instance, but were wondering if anyone else has run across this problem or may have recommendations in how to resolve it.

After merging three separate repositories from Toolkit into ASpace we are left with many legacy locations that we would like to delete. However, in some cases we have run across locations that the system will not let us delete, giving the following error instead:


Text of the error is the following:

translation missing: en.validation_errors.record_deletion_failed__java__commysqljdbcexceptionsjdbc4__mysqlintegrityconstraintviolationexception__cannot_delete_or_update_a_parent_row__a_foreign_key_constraint_fails_(`asdb`.`housed_at_rlshp`__constraint_`housed_at_rlshp_ibfk_2`_foreign_key_(`location_id`)_references_`location`_(`id`))

I have checked across all three repositories and cannot find any top container records linked to this location (or others which refuse to delete) so I am not sure why we are getting this error.


Craig Savino
Senior Processing Archivist
Archival Collections Management, NYU

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20170629/162277f3/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: cannot delete error.png
Type: image/png
Size: 72917 bytes
Desc: cannot delete error.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20170629/162277f3/attachment.png>

More information about the Archivesspace_Users_Group mailing list