[Archivesspace_Users_Group] New School bulk update plugin error

Joshua D. Shaw Joshua.D.Shaw at dartmouth.edu
Wed Aug 4 16:53:56 EDT 2021

Looks like the migration that added that column came in 2.8.0. Though the bulk updater *might* work with 2.8.0 (I have not tested it), it definitely will *not* work with 2.7.1


From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of McLaughlin, Brianna Jean <brijmcla at iu.edu>
Sent: Wednesday, August 4, 2021 4:21 PM
To: archivesspace_users_group at lyralists.lyrasis.org <archivesspace_users_group at lyralists.lyrasis.org>
Subject: [Archivesspace_Users_Group] New School bulk update plugin error

Hi everyone,

Has anyone tried to use the New School bulk updater plugin on AS versions before 2.8.1? We’re on 2.7.1 and I got this error when I tried to use the plugin:

{"error":{"db_error":["Database integrity constraint conflict: Java::JavaSql::SQLSyntaxErrorException: Unknown column 'sub_container.barcode_2' in 'field list'"]}}

The README says the plugin is compatible with 2.8.1, so we just may not have a compatible AS version. However, I’m trying to rule out other reasons I could have gotten this error. Relatedly, is there a sample spreadsheet someone could link?


Bri McLaughlin, she/her/hers

Visiting Metadata Services Librarian

Indiana University


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20210804/03871090/attachment.html>

More information about the Archivesspace_Users_Group mailing list