<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
</head>
<body>
<div style="color: rgb(33, 33, 33); background-color: rgb(255, 255, 255);" dir="auto">
That's exactly it, is this caused by the database migration script? I'm not sure what to do about it. It looks like its affecting almost every archival object.<span></span></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 Brian Hoffman
 <brian.hoffman@lyrasis.org><br>
<b>Sent:</b> Thursday, May 19, 2022 7:52:28 AM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Errors Upgrading from 2.7.0 to 2.8.1</font>
<div> </div>
</div>
<style>
<!--
@font-face
        {font-family:"Cambria Math"}
@font-face
        {font-family:Calibri}
@font-face
        {font-family:Cambria}
p.x_MsoNormal, li.x_MsoNormal, div.x_MsoNormal
        {margin:0in;
        font-size:11.0pt;
        font-family:"Calibri",sans-serif}
a:link, span.x_MsoHyperlink
        {color:blue;
        text-decoration:underline}
p.x_xmsonormal, li.x_xmsonormal, div.x_xmsonormal
        {margin:0in;
        font-size:11.0pt;
        font-family:"Calibri",sans-serif}
span.x_EmailStyle22
        {font-family:"Calibri",sans-serif;
        color:windowtext}
.x_MsoChpDefault
        {font-size:10.0pt}
@page WordSection1
        {margin:1.0in 1.0in 1.0in 1.0in}
div.x_WordSection1
        {}
-->
</style>
<div lang="EN-US" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="x_WordSection1">
<p class="x_MsoNormal">You could also try running this query in MySQL. If you get any results, that would likely be the problem:</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">select id, aspace_relationship_position from top_container_link_rlshp where aspace_relationship_position is null;</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal"> </p>
<div style="border:none; border-top:solid #B5C4DF 1.0pt; padding:3.0pt 0in 0in 0in">
<p class="x_MsoNormal" style="margin-bottom:12.0pt"><b><span style="font-size:12.0pt; color:black">From:
</span></b><span style="font-size:12.0pt; color:black">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>Date: </b>Wednesday, May 18, 2022 at 4:13 PM<br>
<b>To: </b>Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject: </b>Re: [Archivesspace_Users_Group] Errors Upgrading from 2.7.0 to 2.8.1</span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black">That looks pretty bad, not sure what it means, but I would start over, maybe something is missing or there's a bad plugin or some other mysterious thing has failed.</span></p>
</div>
<div>
<div id="x_Signature">
<div>
<div id="x_divtagdefaultwrapper">
<div name="x_divtagdefaultwrapper">
<p class="x_MsoNormal" style="background:white"><span style="font-size:12.0pt; color:black"> </span></p>
</div>
</div>
</div>
</div>
</div>
<div class="x_MsoNormal" align="center" style="text-align:center">
<hr size="0" width="100%" align="center">
</div>
<div id="x_divRplyFwdMsg">
<p class="x_MsoNormal"><b><span style="color:black">From:</span></b><span style="color:black"> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Corinne Chatnik <Corinne.Chatnik@nysed.gov><br>
<b>Sent:</b> Wednesday, May 18, 2022 3:25 PM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> [Archivesspace_Users_Group] Errors Upgrading from 2.7.0 to 2.8.1</span>
</p>
<div>
<p class="x_MsoNormal"> </p>
</div>
</div>
<div>
<div>
<p class="x_xmsonormal">Hi,</p>
<p class="x_xmsonormal"> </p>
<p class="x_xmsonormal">Trying to upgrade from 2.7.0 to 2.8.1 and we keep getting the same error repeated over and over for nearly every record and we donít know where to start looking. Iíve done a complete reindex and redid the database migration etc. The
 log file keeps repeating this:</p>
<p class="x_xmsonormal">E, [2022-05-18T14:07:50.629287 #48326] ERROR -- : Thread-2902: Unhandled exception!</p>
<p class="x_xmsonormal">E, [2022-05-18T14:07:50.630620 #48326] ERROR -- : </p>
<p class="x_xmsonormal">comparison of NilClass with 0 failed</p>
<p class="x_xmsonormal">org/jruby/RubyEnumerable.java:574:in `sort_by'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/mixins/relationships.rb:347:in `find_by_participant'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/mixins/relationships.rb:411:in `who_participates_with'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/mixins/relationships.rb:545:in `related_records'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/top_container.rb:170:in `find_subcontainer_barcodes'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/top_container.rb:190:in `block in sequel_to_jsonmodel'</p>
<p class="x_xmsonormal">org/jruby/RubyArray.java:1809:in `each'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/top_container.rb:184:in `sequel_to_jsonmodel'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/uri_resolver.rb:336:in `block in resolve'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/request_context.rb:24:in `open'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/uri_resolver.rb:335:in `block in resolve'</p>
<p class="x_xmsonormal">org/jruby/RubyHash.java:1415:in `each'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/uri_resolver.rb:331:in `block in resolve'</p>
<p class="x_xmsonormal">org/jruby/RubyGenerator.java:104:in `each'</p>
<p class="x_xmsonormal">org/jruby/RubyEnumerator.java:396:in `each'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/uri_resolver.rb:247:in `block in fetch_records_by_uri'</p>
<p class="x_xmsonormal">org/jruby/RubyHash.java:1415:in `each'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/uri_resolver.rb:241:in `fetch_records_by_uri'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/uri_resolver.rb:130:in `resolve_references'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/uri_resolver.rb:44:in `resolve_references'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/crud_helpers.rb:113:in `listing_response'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/crud_helpers.rb:68:in `handle_listing'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/controllers/archival_object.rb:97:in `block in ArchivesSpaceService'</p>
<p class="x_xmsonormal">org/jruby/RubyBasicObject.java:2622:in `instance_eval'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/rest.rb:368:in `block in GET /repositories/:repo_id/archival_objects'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:105:in `block in open'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:69:in `block in transaction'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/gems/gems/sequel-5.9.0/lib/sequel/database/transactions.rb:204:in `_transaction'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/gems/gems/sequel-5.9.0/lib/sequel/database/transactions.rb:179:in `block in transaction'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/gems/gems/sequel-5.9.0/lib/sequel/connection_pool/threaded.rb:91:in `hold'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/gems/gems/sequel-5.9.0/lib/sequel/database/connecting.rb:270:in `synchronize'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/gems/gems/sequel-5.9.0/lib/sequel/database/transactions.rb:145:in `transaction'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:68:in `transaction'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:104:in `block in open'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:101:in `open'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:426:in `block in DB'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/rest.rb:351:in `block in GET /repositories/:repo_id/archival_objects'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/request_context.rb:24:in `open'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/rest.rb:319:in `block in GET /repositories/:repo_id/archival_objects'</p>
<p class="x_xmsonormal">org/jruby/RubyMethod.java:115:in `call'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:1635:in `block in compile!'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:992:in `block in route!'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:1011:in `route_eval'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:992:in `block in route!'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:1040:in `block in process_route'</p>
<p class="x_xmsonormal">org/jruby/RubyKernel.java:1189:in `catch'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:1038:in `process_route'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:990:in `block in route!'</p>
<p class="x_xmsonormal">org/jruby/RubyArray.java:1809:in `each'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:989:in `route!'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:1097:in `block in dispatch!'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:1076:in `block in invoke'</p>
<p class="x_xmsonormal">org/jruby/RubyKernel.java:1189:in `catch'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:1076:in `invoke'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:1094:in `dispatch!'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:924:in `block in call!'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:1076:in `block in invoke'</p>
<p class="x_xmsonormal">org/jruby/RubyKernel.java:1189:in `catch'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:1076:in `invoke'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:924:in `call!'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:913:in `call'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/main.rb:292:in `call'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/gems/gems/rack-protection-2.0.5/lib/rack/protection/xss_header.rb:18:in `call'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/gems/gems/rack-protection-2.0.5/lib/rack/protection/path_traversal.rb:16:in `call'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/gems/gems/rack-protection-2.0.5/lib/rack/protection/json_csrf.rb:26:in `call'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/gems/gems/rack-protection-2.0.5/lib/rack/protection/base.rb:50:in `call'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/gems/gems/rack-protection-2.0.5/lib/rack/protection/base.rb:50:in `call'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/gems/gems/rack-protection-2.0.5/lib/rack/protection/frame_options.rb:31:in `call'</p>
<p class="x_xmsonormal">uri:classloader:/vendor/rack-2.2.3/rack/null_logger.rb:11:in `call'</p>
<p class="x_xmsonormal">uri:classloader:/vendor/rack-2.2.3/rack/head.rb:12:in `call'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:194:in `call'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:1957:in `call'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:1502:in `block in call'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:1729:in `synchronize'</p>
<p class="x_xmsonormal">/opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:1502:in `call'</p>
<p class="x_xmsonormal">uri:classloader:/vendor/rack-2.2.3/rack/urlmap.rb:74:in `block in call'</p>
<p class="x_xmsonormal">org/jruby/RubyArray.java:1809:in `each'</p>
<p class="x_xmsonormal">uri:classloader:/vendor/rack-2.2.3/rack/urlmap.rb:58:in `call'</p>
<p class="x_xmsonormal">uri:classloader:/rack/handler/servlet.rb:22:in `call'</p>
<p class="x_xmsonormal"> </p>
<p class="x_xmsonormal">Thanks!</p>
<p class="x_xmsonormal"><span style="font-size:12.0pt; color:black">Corinne Chatnik</span></p>
<p class="x_xmsonormal"><span style="font-size:12.0pt; color:black">Archivist </span>
</p>
<p class="x_xmsonormal"><span style="font-size:12.0pt; color:black">Digital Strategies</span></p>
<p class="x_xmsonormal"><span style="font-size:12.0pt; color:black">New York State Archives</span></p>
<p class="x_xmsonormal" style="background:white"><span style="font-size:10.0pt; color:#458993"><a href="http://www.archives.nysed.gov/" target="_blank"><br>
<span style="color:#0563C1">www.archives.nysed.gov</span></a></span><span style="font-size:10.0pt; color:blue"> </span><span style="font-size:10.0pt; color:black">| <a href="mailto:Corinne.Chatnik@nysed.gov"><span style="color:#0563C1">Corinne.Chatnik@nysed.gov</span></a>
</span><span style="color:#201F1E"> </span></p>
<p class="x_xmsonormal" style="background:white"><span style="font-size:10.0pt; color:#458993"><a href="https://www.facebook.com/nysarchives" target="_blank"><span style="color:#458993">Facebook</span></a></span><span style="font-size:10.0pt; color:black"> | </span><span style="font-size:10.0pt; color:#458993"><a href="https://twitter.com/nysarchives" target="_blank"><span style="color:#458993">Twitter</span></a> </span><span style="font-size:10.0pt; color:#201F1E">|</span><span style="font-size:10.0pt; color:black"> <i><a href="https://www.nysarchivestrust.org/new-york-archives-magazine" target="_blank"><span style="color:#0563C1">New
 York Archives</span><span style="color:#0563C1; font-style:normal"> Magazine</span></a></i> | <a href="https://www.youtube.com/user/nysarchives" target="_blank"><span style="color:#0563C1">YouTube</span></a></span></p>
<p class="x_xmsonormal" style="background:white"><span style="color:#201F1E"> </span></p>
<p class="x_xmsonormal"> </p>
</div>
<p class="x_MsoNormal" style="margin-bottom:12.0pt"> </p>
<div style="border:dotted #003333 1.0pt; padding:10.0pt 10.0pt 10.0pt 10.0pt">
<p class="x_MsoNormal" style="background:#D5EAFF"><span style="font-size:12.0pt; font-family:"Cambria",serif; color:red">Confidentiality Notice
</span></p>
<p style="line-height:10.0pt; background:#D5EAFF"><span style="font-size:9.0pt; font-family:"Cambria",serif; color:black">This email including all attachments is confidential and intended solely for the use of the individual or entity to which it is addressed.
 This communication may contain information that is protected from disclosure under State and/or Federal law. Please notify the sender immediately if you have received this communication in error and delete this email from your system. If you are not the intended
 recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.
</span><span style="font-size:9.0pt; font-family:"Cambria",serif"></span></p>
<p class="x_MsoNormal" style="background:#D5EAFF"> </p>
</div>
</div>
</div>
</div>
</body>
</html>