[Archivesspace_Users_Group] Cannot delete duplicate agent record

Brian Hoffman brianjhoffman at gmail.com
Wed Feb 10 19:30:26 EST 2016

It looks like the agent you are trying to delete may be “in a relationship”. If you can remove that relationship (and perhaps recreate it on the duplicate agent you wish to keep), that may solve the problem. If it doesn’t, there may be a bug.

> On Feb 10, 2016, at 1:30 PM, Patricia Burdick <Patricia.Burdick at colby.edu> wrote:
> Hello--
> I have tried both Delete methods to remove a duplicate agent record. An error message results:
> Record deletion failed: Java::ComMysqlJdbcExceptionsJdbc4::MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`archivesspace`.`linked_agent_term`, CONSTRAINT `linked_agent_term_ibfk_1` FOREIGN KEY (`linked_agents_rlshp_id`) REFERENCES `linked_agents_rlshp` (`id`)) 
> Has anyone found a reason and solution for this situation?
> Many thanks,
> Pat Burdick
> Assistant Director for Special Collections
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group

More information about the Archivesspace_Users_Group mailing list