<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
p.xmsonormal, li.xmsonormal, div.xmsonormal
{mso-style-name:x_msonormal;
margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Looking at the record, there are 604 top containers associated with the resource record. Overall, the collection has 632 top container records.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Cory<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org>
<b>On Behalf Of </b>Joshua D. Shaw<br>
<b>Sent:</b> Wednesday, September 30, 2020 11:18 AM<br>
<b>To:</b> Archivesspace Users Group (archivesspace_users_group@lyralists.lyrasis.org) <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Database connection error in ArchivesSpace 2.8 PUI<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Just a guess, but are there more than 1024 top containers that you are trying to retrieve? The maxBooleanClauses setting in
<a href="https://github.com/archivesspace/archivesspace/blob/master/solr/solrconfig.xml#L69">
https://github.com/archivesspace/archivesspace/blob/master/solr/solrconfig.xml#L69</a> limits the max number of booleans to 1024.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="2" width="98%" align="center">
</div>
<div id="divRplyFwdMsg">
<p class="MsoNormal"><b><span style="color:black">From:</span></b><span style="color:black">
<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>>
on behalf of Cory Nimer <<a href="mailto:cory_nimer@byu.edu">cory_nimer@byu.edu</a>><br>
<b>Sent:</b> Wednesday, September 30, 2020 12:09 PM<br>
<b>To:</b> Archivesspace Users Group (<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a>) <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<b>Subject:</b> [Archivesspace_Users_Group] Database connection error in ArchivesSpace 2.8 PUI</span>
<o:p></o:p></p>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="xmsonormal">Colleagues,<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">While testing ArchivesSpace 2.8, we have run into occasional problems loading some records in the PUI, receiving the message "Unable to Connect to Database". Looking at the log files, it reports that the Solr search failed, caused by "too
many boolean clauses". A copy of the relevant portion of the log file is attached.
<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">We had experienced similar issues in 2.5.1 as well, but hoped that this would be resolved by the 2.8 release. Reviewing GitHub, the only similar references that we found were pull requests 1155 (<a href="https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Farchivesspace%2Farchivesspace%2Fpull%2F1155&data=02%7C01%7Cjoshua.d.shaw%40dartmouth.edu%7Cb964b77d8c734c505dac08d8655b4804%7C995b093648d640e5a31ebf689ec9446f%7C0%7C1%7C637370790074461570&sdata=luMVoRgj245fXpohvHhuuUYglynRRPUIjaTG2pxqEqI%3D&reserved=0">https://github.com/archivesspace/archivesspace/pull/1155</a>)
and 1257 (<a href="https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Farchivesspace%2Farchivesspace%2Fissues%2F1257&data=02%7C01%7Cjoshua.d.shaw%40dartmouth.edu%7Cb964b77d8c734c505dac08d8655b4804%7C995b093648d640e5a31ebf689ec9446f%7C0%7C1%7C637370790074471523&sdata=2%2BGYq9uEXpPP%2FtTLlhJ0zFhHlFxLKlYHPhj4sSQNxG4%3D&reserved=0">https://github.com/archivesspace/archivesspace/issues/1257</a>),
though these were back in the 2.3.1 release.<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">Have others encountered similar issues, and if so how were they resolved?<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">Thank you for your help,<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">Cory Nimer<o:p></o:p></p>
<p class="xmsonormal">University Archivist<o:p></o:p></p>
<p class="xmsonormal">Brigham Young University<o:p></o:p></p>
<p class="xmsonormal">801-422-6091<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
</div>
</div>
</div>
</div>
</body>
</html>