<div dir="ltr">Hi,<div><br></div><div>We had the same issue going from 1.5.x to 2.x. The agent_representation_id value in the repository table was null. I 'fixed' it by making a small edit to the Repository and saving it. The column then got populated.</div><div><br></div><div>We migrated from Archon as well. I have sql dumps from each upgrade and it appears that the column was never populated to begin with. </div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Apr 17, 2019 at 10:14 AM Flanagan, Patrick <<a href="mailto:PJFlanagan@ship.edu">PJFlanagan@ship.edu</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div id="gmail-m_1217165677119386841divtagdefaultwrapper" style="font-size:12pt;color:rgb(0,0,0);font-family:Calibri,Helvetica,sans-serif" dir="ltr">
<p>Thanks for the information! I should have added that this repository was originally migrated from Archon, so it's possible some strangeness carried over from the migration.</p>
<p><br>
</p>
<p>I ran <span><i>SELECT CONCAT('/agents/agent_corporate_entity/', id) AS 'url_stub' FROM agent_corporate_entity WHERE id IN (SELECT agent_representation_id FROM repository);
</i>but received an empty set. Doing <i>select agent_representation_id from repository;</i> comes up with two rows of NULL. I tried editing each of the agents and saving them again, as well as the resource itself, but that didn't seem to correct it, unfortunately.
If this is the issue, is there a way I can correct them in SQL en masse? </span></p>
<p><span><br>
</span></p>
<p><span>As for everything showing under /repositories - I think so, but I'm not sure. It looks fine to me, unless 2.5.2 would have added more data. It looks like this:</span></p>
<p><span><br>
</span></p>
<p><span><img size="36541" style="max-width: 99.9%;" id="gmail-m_1217165677119386841img303805" src="cid:16a2bb5605f7ff380022"><br>
</span></p>
<p><br>
</p>
<p>It's considered repository 2 in the URLs, but that's normal for our instances.</p>
<p><br>
</p>
<p>Thanks again,<br>
</p>
<p><br>
</p>
<div id="gmail-m_1217165677119386841Signature">
<div id="gmail-m_1217165677119386841divtagdefaultwrapper" style="font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255);font-family:Calibri,Arial,Helvetica,sans-serif,EmojiFont,"Apple Color Emoji","Segoe UI Emoji",NotoColorEmoji,"Segoe UI Symbol","Android Emoji",EmojiSymbols">
<p>~Patrick Flanagan</p>
<p><i>KLN Applications Administrator</i></p>
<p><i>Keystone Library Network Hub</i><br>
</p>
</div>
</div>
</div>
<hr style="display:inline-block;width:98%">
<div id="gmail-m_1217165677119386841divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> <a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>> on behalf of Blake Carver
<<a href="mailto:blake.carver@lyrasis.org" target="_blank">blake.carver@lyrasis.org</a>><br>
<b>Sent:</b> Monday, April 15, 2019 2:24:37 PM<br>
<b>To:</b> Archivesspace Users Group<br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Unable to view collections (public interface) after upgrading from 1.5.1 to 2.5.2</font>
<div> </div>
</div>
<div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<span style="color:rgb(47,57,65);font-family:system-ui,-apple-system,BlinkMacSystemFont,"Segoe UI",Roboto,Oxygen-Sans,Ubuntu,Cantarell,"Helvetica Neue",Arial,sans-serif;font-size:14px;background-color:rgb(255,255,255);display:inline"></span></div>
<span>We've seen this (infrequently) with upgrades from 1.5.x to 2.x: If I was a betting man, I'd bet a/the repository has lost its agent representation (which needs to be a reference to a corporate entity). If you try to view the repository in the admin "/repositories"
page (that is under SYSTEM "manage repositories"), does it show everything it should?<br>
</span><span></span>
<div id="gmail-m_1217165677119386841Signature">
<div id="gmail-m_1217165677119386841divtagdefaultwrapper" dir="ltr" style="color:rgb(0,0,0);background-color:rgb(255,255,255)">
<div name="divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;margin:0px">
<font face="Calibri,Arial,Helvetica,sans-serif" size="3" color="black"><span dir="ltr" style="font-size:12pt;background-color:white"><font size="2"><span style="font-size:11pt"></span></font></span></font></div>
</div>
</div>
<div><span><br>
</span></div>
<div><span>Could also be a plugin. </span></div>
<div id="gmail-m_1217165677119386841appendonsend"></div>
<hr style="display:inline-block;width:98%">
<div id="gmail-m_1217165677119386841divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> <a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>> on behalf of Flanagan, Patrick
<<a href="mailto:PJFlanagan@ship.edu" target="_blank">PJFlanagan@ship.edu</a>><br>
<b>Sent:</b> Monday, April 15, 2019 1:57 PM<br>
<b>To:</b> <a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" target="_blank">archivesspace_users_group@lyralists.lyrasis.org</a><br>
<b>Subject:</b> [Archivesspace_Users_Group] Unable to view collections (public interface) after upgrading from 1.5.1 to 2.5.2</font>
<div> </div>
</div>
<div dir="ltr">
<div id="gmail-m_1217165677119386841x_divtagdefaultwrapper" dir="ltr" style="font-size:12pt;color:rgb(0,0,0);font-family:Calibri,Helvetica,sans-serif">
<p>I've also attempted to step the upgrades down to 2.5.1, 2.4.0, then 2.1.0, to see if some aspect of the migration was responsible; but the issue remains regardless. The staff interface is not impacted to the best of my knowledge.</p>
<p><br>
</p>
<p>Upon clicking any collection in thew new public interface I'm greeted with the
<b>We're sorry, but something went wrong</b> error message. The log file indicates the following error at the same time:</p>
<p><br>
</p>
<p></p>
<div><span style="font-family:Consolas,Courier,monospace">Apr 15, 2019 11:28:16 AM org.apache.solr.core.SolrCore execute</span><br>
<span style="font-family:Consolas,Courier,monospace">INFO: [collection1] webapp= path=/select params={facet=true&start=0&csv.encapsulator="&q=(id:("\/repositories\/2\/top_containers\/1143")+OR+id:("\/repositories\/2\/top_containers\/1144")+OR+id:("\/repositories\/2\/top_containers\/1145")+OR+id:("\/repositories\/2\/top_containers\/1146")+OR+id:("\/repositories\/2\/top_containers\/1147")+OR+id:("\/repositories\/2\/top_containers\/1149"))&q.op=AND&csv.header=true&csv.escape=\&wt=json&fq=-exclude_by_default:true&fq=suppressed:false&rows=500}
hits=6 status=0 QTime=2 </span><br>
<span style="font-family:Consolas,Courier,monospace">F, [2019-04-15T11:28:16.525748 #54143] FATAL -- : [15f88748-5b17-4145-97f9-9fef25df3ba0] </span><br>
<span style="font-family:Consolas,Courier,monospace">F, [2019-04-15T11:28:16.526196 #54143] FATAL -- : [15f88748-5b17-4145-97f9-9fef25df3ba0]
<b>ActionView::Template::Error (undefined method `[]' for nil:NilClass):</b></span><br>
<span style="font-family:Consolas,Courier,monospace">F, [2019-04-15T11:28:16.527030 #54143] FATAL -- : [15f88748-5b17-4145-97f9-9fef25df3ba0] 1: <% if @result && @result.respond_to?(:metadata) %></span><br>
<span style="font-family:Consolas,Courier,monospace">[15f88748-5b17-4145-97f9-9fef25df3ba0] 2:
</span><br>
<span style="font-family:Consolas,Courier,monospace">[15f88748-5b17-4145-97f9-9fef25df3ba0] 3: <script type="application/ld+json"></span><br>
<span style="font-family:Consolas,Courier,monospace">[15f88748-5b17-4145-97f9-9fef25df3ba0] 4: <%= JSON.pretty_generate(@result.metadata).html_safe %></span><br>
<span style="font-family:Consolas,Courier,monospace">[15f88748-5b17-4145-97f9-9fef25df3ba0] 5: </script></span><br>
<span style="font-family:Consolas,Courier,monospace">[15f88748-5b17-4145-97f9-9fef25df3ba0] 6: <% end %></span><br>
<span style="font-family:Consolas,Courier,monospace">F, [2019-04-15T11:28:16.527849 #54143] FATAL -- : [15f88748-5b17-4145-97f9-9fef25df3ba0] </span><br>
<span style="font-family:Consolas,Courier,monospace">F, [2019-04-15T11:28:16.528196 #54143] FATAL -- : [15f88748-5b17-4145-97f9-9fef25df3ba0]
<b>app/models/resource.rb:104</b>:in `metadata'</span><br>
<span style="font-family:Consolas,Courier,monospace">[15f88748-5b17-4145-97f9-9fef25df3ba0] app/views/shared/_metadata.html.erb:4:in `_app_views_shared__metadata_html_erb___128582640_2336'</span><br>
<span style="font-family:Consolas,Courier,monospace">[15f88748-5b17-4145-97f9-9fef25df3ba0] app/views/layouts/application.html.erb:24:in `_app_views_layouts_application_html_erb___683597418_2334'</span></div>
<p></p>
<p><br>
</p>
<p>I investigated a little bit and found a reference to authority ID around that line. It's worth noting that this particular institution seems to have authority ID blank for every agent, which makes the record look like this in the staff interface:</p>
<p><br>
</p>
<p><img size="39697" id="gmail-m_1217165677119386841x_img404119" style="max-width: 99.9%;" src="cid:16a2bb5605f7a0274fa1"><br>
</p>
<p><br>
</p>
<p>This aspect of the problem might be unrelated, but it was the only lead I had.<br>
</p>
<p><br>
</p>
<p>Any advice would be welcome! I thought I would ask here before heading to Jira with it.</p>
<p><br>
</p>
<p>Thanks,<br>
</p>
<p><br>
</p>
<div id="gmail-m_1217165677119386841x_Signature">
<div id="gmail-m_1217165677119386841x_divtagdefaultwrapper" style="font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255);font-family:Calibri,Arial,Helvetica,sans-serif,EmojiFont,"Apple Color Emoji","Segoe UI Emoji",NotoColorEmoji,"Segoe UI Symbol","Android Emoji",EmojiSymbols">
<p>~Patrick Flanagan</p>
<p><i>KLN Applications Administrator</i></p>
<p><i>Keystone Library Network Hub</i><br>
</p>
</div>
</div>
</div>
</div>
</div>
</div>
_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" rel="noreferrer" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr">Brian Meuse, MSLIS</div><div dir="ltr">he/him/his</div><div dir="ltr"><br><div>Digital Initiatives Librarian<br><div>Brandeis University Library</div></div><div><br></div><div><span><span style="font-family:Arial;background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><b><i><font color="#0000ff" size="4">Proud member of SEIU Local 888</font></i></b></span></span><br></div><div><br></div></div></div></div></div>