<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<p data-pm-slice="1 1 []" class="ContentPasted0 ContentPasted1"></p>
<div style="font-size: 12pt; color: rgb(0, 0, 0);">
<p data-pm-slice="1 1 []" class="ContentPasted0 ContentPasted1">Blake, one other question. Background job links in 3.3.1 all point to localhost instead of domain
<a href="http://localhost:8080/jobs/208/file/309?ext=.xlsx" class="ContentPasted0 ContentPasted2">
http://localhost:8080/jobs/208/file/309?ext=.xlsx</a> for example. I had setup a few instances before migrating prod, and these all reflected that. I was wondering if this was a configuration issue on my end and possibly related. If configuration issue, I'm
all out of ideas on what could be causing it. <span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Links in 2.5 with same setup as my original 3.3.1. test box show the domain url instead.
<br>
</span></p>
</div>
<p></p>
</div>
<div class="elementToProof">
<div id="Signature">
<div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Robert</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<br>
</div>
</div>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Blake Carver
<blake.carver@lyrasis.org><br>
<b>Sent:</b> Wednesday, May 10, 2023 09:10<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Error trying to load via spredsheet</font>
<div> </div>
</div>
<style type="text/css" style="display:none">
<!--
p
{margin-top:0;
margin-bottom:0}
-->
</style>
<div dir="ltr">
<div class="x_elementToProof" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
</div>
<p class="x_ContentPasted0">It looks like you're hitting a known issue, with no known fix yet. Here's the JIRA with some details:</p>
<p><br class="x_ContentPasted0">
<a target="_blank" rel="noopener noreferrer" href="https://archivesspace.atlassian.net/browse/ANW-1427" class="x_ContentPasted0">https://archivesspace.atlassian.net/browse/ANW-1427</a></p>
<p class="x_ContentPasted0"> </p>
<p class="x_ContentPasted0 x_elementToProof">Long story short, the importer just falls apart sometimes. If you can replicate this problem reliably, be sure to comment there.<br class="x_ContentPasted0">
</p>
<p class="x_ContentPasted0"> </p>
<p class="x_ContentPasted0">All I can say is SOMETHING goes wrong, and then it just stops working.<br class="x_ContentPasted0">
</p>
<p class="x_ContentPasted0">Restarting always clears it up. </p>
<p class="x_ContentPasted0"> </p>
<div class="x_elementToProof">
<div id="x_Signature">
<div>
<div id="x_divtagdefaultwrapper" dir="ltr" style="color:rgb(0,0,0); background-color:rgb(255,255,255)">
<div name="x_divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; margin:0px">
<font face="Calibri,Arial,Helvetica,sans-serif" size="3" style="color:black"><span dir="ltr" style="font-size:12pt; background-color:white"><font size="2"><span style="font-size:11pt"><br>
</span></font></span></font></div>
</div>
</div>
</div>
</div>
<div id="x_appendonsend"></div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="x_divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Robert T.
Wilson <rtwilson@cornell.edu><br>
<b>Sent:</b> Wednesday, May 10, 2023 9:58 AM<br>
<b>To:</b> archivesspace_users_group@lyralists.lyrasis.org <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> [Archivesspace_Users_Group] Error trying to load via spredsheet</font>
<div> </div>
</div>
<style type="text/css" style="display:none">
<!--
p
{margin-top:0;
margin-bottom:0}
-->
</style>
<div dir="ltr">
<div class="x_x_elementToProof" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Hi folks, <br>
</div>
<div class="x_x_elementToProof" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div class="x_x_elementToProof" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
We've just moved to 3.3.1, and I am seeing an odd issue when users try to load via spreadsheet. We can select our file, but when we click "import selected" we get the generic "something went wrong" 500 page.
<br>
</div>
<div class="x_x_elementToProof" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div class="x_x_elementToProof" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
I've attached debug logs, but these were logs at warn level<br>
</div>
<div class="x_x_elementToProof" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div class="x_x_elementToProof x_x_ContentPasted0" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
F, [2023-05-09T17:59:29.110284 #23230] FATAL -- :
<div class="x_x_ContentPasted0">F, [2023-05-09T17:59:29.110478 #23230] FATAL -- : RuntimeError (Couldn't make an ID out of URI: ):</div>
<div class="x_x_ContentPasted0">F, [2023-05-09T17:59:29.110534 #23230] FATAL -- :</div>
<div class="x_x_ContentPasted0">F, [2023-05-09T17:59:29.110576 #23230] FATAL -- : app/controllers/jobs_controller.rb:51:in `create'</div>
<div class="x_x_ContentPasted0">app/controllers/application_controller.rb:744:in `set_locale'</div>
<div class="x_x_ContentPasted0">E, [2023-05-09T17:59:31.130959 #23230] ERROR -- : Thread-8720: Unhandled exception!</div>
<div class="x_x_ContentPasted0">E, [2023-05-09T17:59:31.131241 #23230] ERROR -- :</div>
<div class="x_x_ContentPasted0">invalid byte sequence in UTF-8</div>
</div>
<div class="x_x_elementToProof x_x_ContentPasted0" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div class="x_x_elementToProof">If a user is seeing this, I am easily able to reproduce. With the invalid byte sequence message, I assumed it was something in the spreadsheet (attached is associated with debug log), BUT the workaround I've found makes me think
this is something else. The workaround: If I try creating another background job for resource in question like generate pdf then I try the load via spreadsheet again, the job queues and runs without issue or delay.</div>
<div class="x_x_elementToProof" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div class="x_x_elementToProof" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Has anyone seen something like this or have any recommendations?</div>
<div class="x_x_elementToProof" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div class="x_x_elementToProof" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Thanks in advance for any assistance y'all can provide. <br>
</div>
<div class="x_x_elementToProof" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div class="x_x_elementToProof" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Robert<br>
</div>
<div class="x_x_elementToProof"><br>
</div>
<div class="x_x_elementToProof">
<div id="x_x_Signature">
<div><span style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt"><span style="font-size:10pt">Robert T. Wilson (he/him)<br>
</span></span>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt"><span style="font-size:10pt">Cloud Systems Administrator</span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt"><span style="font-size:10pt">Cornell University Library</span></div>
<div><span style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt"><span style="font-size:10pt">rtwilson@cornell.edu</span></span></div>
<div><span style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt"><span style="font-size:10pt">607.254.3483<br>
</span></span></div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>