<html 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=utf-8">
<meta name="Title" content="">
<meta name="Keywords" content="">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Courier New";
panose-1:2 7 3 9 2 2 5 2 4 4;}
@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:"Segoe UI";}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
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:12.0pt;
font-family:"Times New Roman";}
span.pl-sre
{mso-style-name:pl-sre;}
span.pl-smi
{mso-style-name:pl-smi;}
span.pl-k
{mso-style-name:pl-k;}
span.pl-s
{mso-style-name:pl-s;}
span.pl-pds
{mso-style-name:pl-pds;}
span.EmailStyle23
{mso-style-type:personal;
font-family:Calibri;
color:#1F497D;}
span.EmailStyle24
{mso-style-type:personal-reply;
font-family:Calibri;
color:windowtext;}
span.msoIns
{mso-style-type:export-only;
mso-style-name:"";
text-decoration:underline;
color:teal;}
.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>
</head>
<body bgcolor="white" lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri">Hey Steve and Noah,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri">I have added a JIRA ticket for this problem -
<a href="https://archivesspace.atlassian.net/browse/ANW-265">https://archivesspace.atlassian.net/browse/ANW-265</a> and am looking into it today.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri">Laney<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:Calibri;color:black">Laney McGlohon</span></b><span style="font-size:11.0pt;font-family:Calibri;color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri;color:black">ArchivesSpace Tech Lead<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri;color:black"><a href="mailto:laney.mcglohon@lyrasis.org"><span style="color:#0563C1">laney.mcglohon@lyrasis.org</span></a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri;color:black">800.999.8558 x2927<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri;color:black">laneymcglohon Skype<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri;color:black"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri"><o:p> </o:p></span></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-family:Calibri;color:black">From: </span>
</b><span style="font-family:Calibri;color:black"><archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Noah Huffman <noah.huffman@duke.edu><br>
<b>Reply-To: </b>Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Date: </b>Friday, November 3, 2017 at 4:09 PM<br>
<b>To: </b>Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject: </b>Re: [Archivesspace_Users_Group] Reports broken in 2.2.0 ??<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri;color:#1F497D">Hi Steve,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri;color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri;color:#1F497D">I’m seeing the same error you note with some reports in v2.2.0. Other reports are generating different errors. None of the reports seem to work.</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri;color:#1F497D">-Noah</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri;color:#1F497D"> </span><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><span style="font-size:11.0pt;font-family:Calibri">From:</span></b><span style="font-size:11.0pt;font-family:Calibri"> archivesspace_users_group-bounces@lyralists.lyrasis.org [mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org]
<b>On Behalf Of </b>Majewski, Steven (sdm7g)<br>
<b>Sent:</b> Friday, November 3, 2017 3:35 PM<br>
<b>To:</b> archivesspace_users_group@lyralists.lyrasis.org<br>
<b>Subject:</b> [Archivesspace_Users_Group] Reports broken in 2.2.0 ??</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Since upgrading to 2.2.0, most Reports have been broken for us. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">We also had some problems with a database migration to a new server, where initially the MySQL functions used in the reports module were missing. We have since restored those functions, but reports are still broken, but for a different
reason. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Is anyone else seeing a problem ? <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">None of the current errors seem to be related to MySQL, so I don’t believe those earlier issues are involved. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Some reports, like Location Report complete successfully, but all Accessions Reports seem to fail. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#33EE33;background:#333333">Generating report undefined method `orientation=' for #<UnprocessedAccessionsReport:0x7f80f16> Did you</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#33EE33;background:#333333"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#33EE33;background:#333333">mean? orientation (erb):6:in `<eval>' org/jruby/RubyKernel.java:1000:in `eval' uri:classloader:/META-INF/jruby.home/lib/ruby/stdlib/erb.rb:864:in
`result' /projects/Archivespace/dcs-archivesspace/backend/app/lib/reports/report_response.rb:50:in `render' /projects/Archivespace/dcs-archivesspace/backend/app/lib/reports/report_response.rb:21:in</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#33EE33;background:#333333"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#33EE33;background:#333333">`block in generate' /projects/Archivespace/dcs-archivesspace/backend/app/lib/reports/json_response.rb:5:in `initialize' /projects/Archivespace/dcs-archivesspace/backend/app/lib/reports/report_response.rb:27:in
`generate' /projects/Archivespace/dcs-archivesspace/backend/app/lib/job_runners/reports_runner.rb:37:in</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#33EE33;background:#333333"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#33EE33;background:#333333">`block in run' /projects/Archivespace/dcs-archivesspace/backend/app/model/db.rb:111:in `block in open' /projects/Archivespace/dcs-archivesspace/backend/app/model/db.rb:75:in
`block in transaction' /projects/Archivespace/dcs-archivesspace/build/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:134:in</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#33EE33;background:#333333"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#33EE33;background:#333333">`_transaction' /projects/Archivespace/dcs-archivesspace/build/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:108:in `block in transaction'
/projects/Archivespace/dcs-archivesspace/build/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:98:in</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#33EE33;background:#333333"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#33EE33;background:#333333">`hold' /projects/Archivespace/dcs-archivesspace/build/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255:in `synchronize' /projects/Archivespace/dcs-archivesspace/build/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:97:in
`transaction'</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#33EE33;background:#333333"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#33EE33;background:#333333">/projects/Archivespace/dcs-archivesspace/backend/app/model/db.rb:74:in `transaction' /projects/Archivespace/dcs-archivesspace/backend/app/model/db.rb:110:in
`block in open' org/jruby/RubyFixnum.java:305:in `times' /projects/Archivespace/dcs-archivesspace/backend/app/model/db.rb:107:in</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#33EE33;background:#333333"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#33EE33;background:#333333">`open' /projects/Archivespace/dcs-archivesspace/backend/app/model/db.rb:432:in `block in DB' /projects/Archivespace/dcs-archivesspace/backend/app/lib/job_runners/reports_runner.rb:36:in
`run' /projects/Archivespace/dcs-archivesspace/backend/app/lib/background_job_queue.rb:126:in</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#33EE33;background:#333333"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#33EE33;background:#333333">`run_pending_job' /projects/Archivespace/dcs-archivesspace/backend/app/lib/background_job_queue.rb:169:in `block in start_background_thread' Done.</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">I have gotten them to run successfully by commenting out this line:<o:p></o:p></p>
</div>
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="border-collapse:collapse;box-sizing: border-box;border-spacing: 0px;tab-size: 8">
<tbody>
<tr style="box-sizing: border-box">
<td style="padding:.75pt .75pt .75pt .75pt"></td>
</tr>
<tr style="box-sizing: border-box">
<td valign="top" style="background:#FFFBDD;padding:0in 7.5pt 0in 7.5pt;box-sizing: border-box;word-wrap: normal;overflow:visible" id="LC6">
<p class="MsoNormal" style="line-height:15.0pt"><span style="font-size:9.0pt;font-family:Consolas;color:#24292E"> </span><o:p></o:p></p>
<p class="MsoNormal" style="line-height:15.0pt"><span style="font-size:9.0pt;font-family:Consolas;color:#24292E"> </span><o:p></o:p></p>
<p class="MsoNormal" style="line-height:15.0pt"><span class="pl-sre"><span style="font-size:9.0pt;font-family:Consolas;color:#24292E">#
</span></span><o:p></o:p></p>
<p class="MsoNormal" style="line-height:15.0pt"><span class="pl-smi"><span style="font-size:9.0pt;font-family:Consolas;color:#24292E"> </span></span><o:p></o:p></p>
<p class="MsoNormal" style="line-height:15.0pt"><span class="pl-smi"><span style="font-size:9.0pt;font-family:Consolas;color:#24292E">@report</span></span><span class="pl-sre"><span style="font-size:9.0pt;font-family:Consolas;color:#24292E">.orientation
</span></span><o:p></o:p></p>
<p class="MsoNormal" style="line-height:15.0pt"><span class="pl-k"><span style="font-size:9.0pt;font-family:Consolas;color:#D73A49"> </span></span><o:p></o:p></p>
<p class="MsoNormal" style="line-height:15.0pt"><span class="pl-k"><span style="font-size:9.0pt;font-family:Consolas;color:#D73A49">=</span></span><span class="pl-sre"><span style="font-size:9.0pt;font-family:Consolas;color:#24292E">
</span></span><o:p></o:p></p>
<p class="MsoNormal" style="line-height:15.0pt"><span class="pl-s"><span style="font-size:9.0pt;font-family:Consolas;color:#032F62"> </span></span><o:p></o:p></p>
<p class="MsoNormal" style="line-height:15.0pt"><span class="pl-pds"><span style="font-size:9.0pt;font-family:Consolas;color:#032F62">'</span></span><span class="pl-s"><span style="font-size:9.0pt;font-family:Consolas;color:#032F62">landscape</span></span><span class="pl-pds"><span style="font-size:9.0pt;font-family:Consolas;color:#032F62">'</span></span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Segoe UI";color:#24292E"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Segoe UI";color:#24292E"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Segoe UI";color:#24292E"> </span><o:p></o:p></p>
</td>
</tr>
<tr style="box-sizing: border-box">
<td width="50" nowrap="" valign="top" style="width:37.5pt;padding:0in 7.5pt 0in 7.5pt">
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Segoe UI";color:#24292E"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Segoe UI";color:#24292E"> </span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal">in: <a href="https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_archivesspace_archivesspace_blob_master_backend_app_views_reports_report.erb-23L6&d=DwMGaQ&c=imBPVzF25OnBgGmVOlcsiEgHoG1i6YHLR0Sj_gZ4adc&r=F0JE8U9-xhxe_nE7d7aEUi-uqfKqvYJ222bS0oz9mko&m=ExG84eHqP2HuPVCgV2FwCyxFXY3PDMpzSACflyGvTeE&s=Cl-QtUH0xb1BxEExd4N3uyrlYUqJoQep76RTDAaOr90&e=">https://github.com/archivesspace/archivesspace/blob/master/backend/app/views/reports/report.erb#L6</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">But this is not a new addition and was not (I believe) broken earlier. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">This seems like it may be related to the assessment module addition, but I’m not sure exactly how. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">— Steve. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</div>
</body>
</html>