[Archivesspace_Users_Group] Issues with spreadsheet load

[Noah Huffman]

Hi Tom,

We have been experiencing this same issue for a while on our production v2.8.1 instance and on a test version of v3.1.0.

If we attempt to load a spreadsheet that does not validate it not only fails, but essentially wrecks the importer for all future imports, even spreadsheets that are properly formatted. Any subsequent import attempt will return a server error in the UI. I’m also seeing the same error you reported in my log file.

The only fix we have found is to restart the application.

I thought I had submitted a bug report for this, but I’ll double-check now.

-Noah

================
Noah Huffman
Archivist for Metadata, Systems, and Digital Records
David M. Rubenstein Rare Book & Manuscript Library
Duke University | 919-660-5982
http://library.duke.edu/rubenstein/
Pronouns: he / him / his

From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> On Behalf Of Tom Hanstra
Sent: Tuesday, November 30, 2021 11:08 AM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: [Archivesspace_Users_Group] Issues with spreadsheet load

I'm trying to track down some issues we are having with the load of a spreadsheet. I'm wondering if I have some database corruption behind the scenes or just have some bad spreadsheet info.

We are running ArchivesSpace v 2.8.1. When trying to load the spreadsheet, we consistently get the error in the background log of:

E, [2021-11-30T10:59:08.769519 #7965] ERROR -- : Thread-3238: Unhandled exception!
E, [2021-11-30T10:59:08.770805 #7965] ERROR -- :
invalid byte sequence in UTF-8

I got this error just with the Only Validate option chosen, but I don't know enough about what Only validate does.

We've also now gotten this with a couple of different spreadsheets against a few different records. We have not found a spreadsheet that will work as things currently stand.

How can I best track down where the issue lies. Might I have an issue with the database? Or just bad data somewhere in this spreadsheet? Is there a way to validate an archivesspace database?

Thanks,
Tom

--
Tom Hanstra
Sr. Systems Administrator
hanstra at nd.edu<mailto:hanstra at nd.edu>

[https://docs.google.com/uc?export=download&id=1GFX1KaaMTtQ2Kg2u8bMXt1YwBp96bvf0&revid=0B7APN9POn6xAQ244WWFYMFU3aVJwZ0lxbmVHK3FxNXlCd0RRPQ]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20211130/82af77ac/attachment.html>