[Archivesspace_Users_Group] Error deleting agents

[Clayton Joseph Ruminski]

Hello,

We are doing some data cleanup in ASpace, and one agent in particular is giving me the following error when trying to delete it:

Record deletion failed: Java::ComMysqlJdbcExceptionsJdbc4::MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`archivesspace`.`user`, CONSTRAINT `user_ibfk_1` FOREIGN KEY (`agent_record_id`) REFERENCES `agent_person` (`id`))

I looked on the user group archives but was unable to find an answer. The agent looks to have been autogenerated at some point and is not linked to any records.

Thanks!

Clayton Ruminski CLEMSON UNIVERSITY

Digital and Preservation Archivist
Special Collections and Archives
Clemson University Libraries
crumins at clemson.edu<mailto:crumins at clemson.edu>
864-656-0234

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20200604/5e0ccdac/attachment.html>