[Archivesspace_Users_Group] Error deleting agents

[Clayton Joseph Ruminski]

Thanks for your response. I see no indication that there is a user linked to this particular agent. Maybe the agent name might help, as it seems autogenerated: "full name not entered ##2e3 zzzz."

From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> On Behalf Of Blake Carver
Sent: Thursday, June 4, 2020 3:46 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] Error deleting agents

We've seen that happen when a user is also an agent.  Probably there's an agent (person) record linked to that user account so the account cannot be deleted. You can delete the agent record first, then the user -- that should work. Careful, sometimes you need that agent record. In that case I'd suggest disabling the account by resetting the password to something long and random so the account cannot be used (and perhaps add "DISABLED" to "Additional Contact Information" as a note).
________________________________
From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org> <archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org>> on behalf of Clayton Joseph Ruminski <crumins at clemson.edu<mailto:crumins at clemson.edu>>
Sent: Thursday, June 4, 2020 3:42 PM
To: archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at lyralists.lyrasis.org> <archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at lyralists.lyrasis.org>>
Subject: [Archivesspace_Users_Group] Error deleting agents


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/20200612/494ac60a/attachment.html>