[Archivesspace_Users_Group] Cannot delete duplicate agent record

[Brian Hoffman]

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