[Archivesspace_Users_Group] Unable to edit archival object after transferring

[Peterson, Christie]

Thank you so much, Noah! I thought there was an answer like this out there.

Christie

On Tue, Apr 18, 2017 at 10:43 AM, Noah Huffman <noah.huffman at duke.edu>
wrote:

> 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@
> 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> 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>
> 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_
>
>
>
> 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
>
> 202.994.3925 <(202)%20994-3925>
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> 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
> 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
>
> 202.994.3925 <(202)%20994-3925>
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>
>


-- 
Christie S. Peterson

University Archivist
George Washington University Libraries
704H Gelman Library
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/c4fb70d7/attachment.html>