[Archivesspace_Users_Group] Unable to edit archival object after transferring

[Noah Huffman]

Hi Christie,

You can resequence your entire database on startup to solve the problem.  Or, you can install this plugin and resequence just the offending resource record: https://github.com/archivesspace-plugins/resync

You can read the long history of this issue in JIRA: https://archivesspace.atlassian.net/browse/AR-1326

-Noah

From: archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of Peterson, Christie
Sent: Tuesday, April 18, 2017 10:16 AM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] Unable to edit archival object after transferring

Thanks, yeah, that's what I thought might have happened. Was wondering if anyone else had encountered it and if there was a known fix, since the transfer was done months ago and rolling back the db is not an option at this point.

On Tue, Apr 18, 2017 at 9:48 AM, Lora Davis <ljdavis at jhu.edu<mailto:ljdavis at jhu.edu>> wrote:
Hey Christie,

Given this:

duplicate_entry__297608 at archival_object-0__for_key__uniq_ao_pos_

I’m thinking that what is going on is that during the merge you’ve ended up with two sets of archival_objects belonging to the same parent that have matching “positions" (the ao field that tells ASpace where to place an object in the collection’s tree).  If you have a way to look at the JSON for the archival objects you could confirm that multiple objects have the same position #.

So, for example, archival_objects/2 would be:

{
  "lock_version": 0,
  "position": 0,
  "publish": true,
  "ref_id": "9759e8ea59d8e8c95237974522c97551",
  "title": "Research Materials”,
     <snip>
  "parent": {
    "ref": "/repositories/2/archival_objects/1"
  }
}

And archival_objects/3 is also:

{
  "lock_version": 0,
  "position": 0,
  "publish": true,
  "ref_id": "4b2114851f10f24ea86c6506fb1a829f",
  "title": "Rabelais-Villon",
     <snip>
  "parent": {
    "ref": "/repositories/2/archival_objects/1"
  }
}

That said, if this is the culprit, clearly this shouldn’t happen when transferring ao’s from one collection to another via the staff interface!

Or, I could be way off base… :)

Lora


On Apr 18, 2017, at 8:57 AM, Peterson, Christie <cspeterson at email.gwu.edu<mailto:cspeterson at email.gwu.edu>> wrote:

Hello,

I'm having a problem with some archival objects where any attempt to edit them through the user interface results in the following error:

translation missing: en.no<https://urldefense.proofpoint.com/v2/url?u=http-3A__en.no_&d=DwMFaQ&c=imBPVzF25OnBgGmVOlcsiEgHoG1i6YHLR0Sj_gZ4adc&r=F0JE8U9-xhxe_nE7d7aEUi-uqfKqvYJ222bS0oz9mko&m=wQ0lm1Sws0EAC5SGYnSlccdMpQU4arrAmNQhFmZoVZk&s=oFZTbDLle3T8zFxUoF1JkQM_jsxMql-JcJjOZi0k_no&e=> key - translation missing: en.validation_errors.database_integrity_constraint_conflict__java__commysqljdbcexceptionsjdbc4__mysqlintegrityconstraintviolationexception__duplicate_entry__297608 at archival_object-0__for_key__uniq_ao_pos_<mailto:en.validation_errors.database_integrity_constraint_conflict__java__commysqljdbcexceptionsjdbc4__mysqlintegrityconstraintviolationexception__duplicate_entry__297608 at archival_object-0__for_key__uniq_ao_pos_>

The only thing I can think of that might be relevant is that these are objects in a series that was transferred from one collection to another via the interface.

Has anyone run into this before? Have any suggestions?

Thanks,

Christie

--
Christie S. Peterson

University Archivist
George Washington University Libraries
704H Gelman Library
cspeterson at gwu.edu<mailto:cspeterson at gwu.edu>
202.994.3925<tel:(202)%20994-3925>
_______________________________________________
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group at lyralists.lyrasis.org<mailto:Archivesspace_Users_Group at lyralists.lyrasis.org>
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group<https://urldefense.proofpoint.com/v2/url?u=http-3A__lyralists.lyrasis.org_mailman_listinfo_archivesspace-5Fusers-5Fgroup&d=DwMFaQ&c=imBPVzF25OnBgGmVOlcsiEgHoG1i6YHLR0Sj_gZ4adc&r=F0JE8U9-xhxe_nE7d7aEUi-uqfKqvYJ222bS0oz9mko&m=wQ0lm1Sws0EAC5SGYnSlccdMpQU4arrAmNQhFmZoVZk&s=B1Ur4bQrcikUF8YU81rUqVssn7kAkiQ1XvrwnGUhAf4&e=>


_______________________________________________
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group at lyralists.lyrasis.org<mailto:Archivesspace_Users_Group at lyralists.lyrasis.org>
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group<https://urldefense.proofpoint.com/v2/url?u=http-3A__lyralists.lyrasis.org_mailman_listinfo_archivesspace-5Fusers-5Fgroup&d=DwMFaQ&c=imBPVzF25OnBgGmVOlcsiEgHoG1i6YHLR0Sj_gZ4adc&r=F0JE8U9-xhxe_nE7d7aEUi-uqfKqvYJ222bS0oz9mko&m=wQ0lm1Sws0EAC5SGYnSlccdMpQU4arrAmNQhFmZoVZk&s=B1Ur4bQrcikUF8YU81rUqVssn7kAkiQ1XvrwnGUhAf4&e=>



--
Christie S. Peterson

University Archivist
George Washington University Libraries
704H Gelman Library
cspeterson at gwu.edu<mailto:cspeterson at gwu.edu>
202.994.3925
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20170418/fd82536e/attachment.html>