<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:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" 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)">
<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;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.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="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">Hi ArchivesSpace Users;<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">It appears we have found the answer to our question on <a href="https://archivesspace.github.io/archivesspace/user/re-creating-indexes/">
https://archivesspace.github.io/archivesspace/user/re-creating-indexes/</a>. By rebuilding the index files all records are now found from the MySQL database. The issues seems to be related to refreshing the database in a test environment from production, but
the index files not picking up the new records. Rebuilding the index files also appears to address the issue we outlined in our eMail “Error browsing Resources in version 2.6”.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">One other observation we made when refreshing the database is that the script archivesspace/scripts/setup-database.sh does not appear to work on later refreshes. The firs time we ran the script, the beginning of the output was as follows:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Courier New"">[scripts]$ ./setup-database.sh<o:p></o:p></span></p>
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Courier New"">Loading ArchivesSpace configuration file from path: /apps/archivesspace/config/config.rb<o:p></o:p></span></p>
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Courier New"">Loading ArchivesSpace configuration file from path: /apps/archivesspace/config/config.rb<o:p></o:p></span></p>
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Courier New"">Loading ArchivesSpace configuration file from path: /apps/archivesspace/config/config.rb<o:p></o:p></span></p>
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Courier New"">Running migrations against jdbc:mysql://mysqldev-a.mitre.org:3306/archivesspace?user=[REDACTED]&password=[REDACTED]&useUnicode=true&characterEncoding=UTF-8&autoReconnect=true<o:p></o:p></span></p>
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Courier New"">I, [2019-10-18T13:24:53.944292 #48098] INFO -- : Begin applying migration version 98, direction: up<o:p></o:p></span></p>
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Courier New"">I, [2019-10-18T13:24:54.123838 #48098] INFO -- : Finished applying migration version 98, direction: up, took 0.179616 seconds<o:p></o:p></span></p>
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Courier New"">I, [2019-10-18T13:24:54.124897 #48098] INFO -- : Begin applying migration version 99, direction: up<o:p></o:p></span></p>
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Courier New"">I, [2019-10-18T13:24:54.290539 #48098] INFO -- : Finished applying migration version 99, direction: up, took 0.165550 seconds<o:p></o:p></span></p>
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Courier New"">I, [2019-10-18T13:24:54.291407 #48098] INFO -- : Begin applying migration version 100, direction: up<o:p></o:p></span></p>
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Courier New"">I, [2019-10-18T13:25:01.935442 #48098] INFO -- : Finished applying migration version 100, direction: up, took 7.643832 seconds<o:p></o:p></span></p>
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Courier New"">I, [2019-10-18T13:25:01.936657 #48098] INFO -- : Begin applying migration version 101, direction: up<o:p></o:p></span></p>
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Courier New"">I, [2019-10-18T13:25:02.357509 #48098] INFO -- : Finished applying migration version 101, direction: up, took 0.420813 seconds<o:p></o:p></span></p>
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Courier New"">I, [2019-10-18T13:25:02.358205 #48098] INFO -- : Begin applying migration version 102, direction: up<o:p></o:p></span></p>
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Courier New"">I, [2019-10-18T13:25:02.706000 #48098] INFO -- : Finished applying migration version 102, direction: up, took 0.347575 seconds<o:p></o:p></span></p>
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Courier New"">I, [2019-10-18T13:25:02.707015 #48098] INFO -- : Begin applying migration version 103, direction: up<o:p></o:p></span></p>
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Courier New"">Updating qaa-qtz to und<o:p></o:p></span></p>
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Courier New"">Deleting enumeration_id for qaa-qtz<o:p></o:p></span></p>
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Courier New"">I, [2019-10-18T13:25:03.059206 #48098] INFO -- : Finished applying migration version 103, direction: up, took 0.352167 seconds<o:p></o:p></span></p>
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Courier New"">:<o:p></o:p></span></p>
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Courier New"">:<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">After later refreshes, the output contained only these messages:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.0pt;font-family:"Courier New"">[logs]$ more setup-database.log_20191202_1504<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.0pt;font-family:"Courier New"">Loading ArchivesSpace configuration file from path: /apps/archivesspace/config/config.rb<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.0pt;font-family:"Courier New"">Loading ArchivesSpace configuration file from path: /apps/archivesspace/config/config.rb<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.0pt;font-family:"Courier New"">Loading ArchivesSpace configuration file from path: /apps/archivesspace/config/config.rb<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.0pt;font-family:"Courier New"">Running migrations against jdbc:mysql://mysqldev-a.mitre.org:3306/archivesspace?user=[REDACTED]&password=[REDACTED]&useUnicode=true&characterEncoding=UTF-8&autoReconnect=true<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.0pt;font-family:"Courier New"">All done.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.0pt;font-family:"Courier New"">[m91981@archspcdev1 logs]$<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Does something need to be “reset” in a file or someplace else to allow the database conversion to happen again?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">We would also still be interested in seeing document that identifies the relationships between tables, if available.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Please advise.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thank you!<o:p></o:p></p>
<div>
<p class="MsoNormal"><b><span style="color:#2F5496">Gerard (Jerry) Boggio</span></b> |
<b>MITRE Corporation</b> | R504 - <span style="color:#111113">Collaboration & Info Management</span><span style="font-size:18.5pt;font-family:"Arial",sans-serif;color:#111113">
</span>| 781-271-2719 <span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:#333333">
| </span>Bedford, MA | 2K132<o:p></o:p></p>
</div>
<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> Boggio, Jerry <gboggio@mitre.org> <br>
<b>Sent:</b> Wednesday, November 27, 2019 12:01 PM<br>
<b>To:</b> archivesspace_users_group@lyralists.lyrasis.org<br>
<b>Subject:</b> Accessions Query<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Hi ArchivesSpace Users;<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">We are seeing an issue in our Linux based installation of version 2.6 where we are not seeing all of my Accession records when selecting Browse > Accessions. Could you please provide the SQL query used to populate that page so that we may
see if there is selection criteria being applied? With that information we can compare to our SQL query going directly against the database to identify differences.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Is there also a document that identifies the relationships between tables in ArchivesSpace?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thank you!<o:p></o:p></p>
<p class="MsoNormal"><b><span style="color:#2F5496">Gerard (Jerry) Boggio</span></b> |
<b>MITRE Corporation</b> | R504 - <span style="color:#111113">Collaboration & Info Management</span><span style="font-size:18.5pt;font-family:"Arial",sans-serif;color:#111113">
</span>| 781-271-2719 <span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:#333333">
| </span>Bedford, MA | 2K132<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>