<div dir="ltr">Hello,<div><br></div><div>I also ran into this bug during some testing of reports in 2.2.0.</div><div><br></div><div>I just submitted a PR with a fix for this: <a href="https://github.com/archivesspace/archivesspace/pull/1021">https://github.com/archivesspace/archivesspace/pull/1021</a></div><div><br></div><div>Dallas</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Nov 6, 2017 at 11:43 AM, Laney McGlohon <span dir="ltr"><<a href="mailto:laney.mcglohon@lyrasis.org" target="_blank">laney.mcglohon@lyrasis.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="white" lang="EN-US" link="blue" vlink="purple">
<div class="m_1051958047275189884WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri">Hey Steve and Noah,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri"><u></u> <u></u></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" target="_blank">https://archivesspace.<wbr>atlassian.net/browse/ANW-265</a> and am looking into it today.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri">Laney<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri"><u></u> <u></u></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"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri;color:black">ArchivesSpace Tech Lead<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri;color:black"><a href="mailto:laney.mcglohon@lyrasis.org" target="_blank"><span style="color:#0563c1">laney.mcglohon@lyrasis.org</span></a><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri;color:black"><a href="tel:(800)%20999-8558" value="+18009998558" target="_blank">800.999.8558 x2927</a><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri;color:black">laneymcglohon Skype<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri;color:black"><u></u> <u></u></span></p>
</div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri"><u></u> <u></u></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"><<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_group-<wbr>bounces@lyralists.lyrasis.org</a>> on behalf of Noah Huffman <<a href="mailto:noah.huffman@duke.edu" target="_blank">noah.huffman@duke.edu</a>><br>
<b>Reply-To: </b>Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" target="_blank">archivesspace_users_group@<wbr>lyralists.lyrasis.org</a>><br>
<b>Date: </b>Friday, November 3, 2017 at 4:09 PM<br>
<b>To: </b>Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" target="_blank">archivesspace_users_group@<wbr>lyralists.lyrasis.org</a>><br>
<b>Subject: </b>Re: [Archivesspace_Users_Group] Reports broken in 2.2.0 ??<u></u><u></u></span></p>
</div><div><div class="h5">
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri;color:#1f497d">Hi Steve,</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri;color:#1f497d"> </span><u></u><u></u></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><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri;color:#1f497d">-Noah</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri;color:#1f497d"> </span><u></u><u></u></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"> <a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_group-<wbr>bounces@lyralists.lyrasis.org</a> [mailto:<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_<wbr>group-bounces@lyralists.<wbr>lyrasis.org</a>]
<b>On Behalf Of </b>Majewski, Steven (sdm7g)<br>
<b>Sent:</b> Friday, November 3, 2017 3:35 PM<br>
<b>To:</b> <a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" target="_blank">archivesspace_users_group@<wbr>lyralists.lyrasis.org</a><br>
<b>Subject:</b> [Archivesspace_Users_Group] Reports broken in 2.2.0 ??</span><u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"> <u></u><u></u></p>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Since upgrading to 2.2.0, most Reports have been broken for us. <u></u><u></u></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. <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Is anyone else seeing a problem ? <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></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. <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Some reports, like Location Report complete successfully, but all Accessions Reports seem to fail. <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></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:<wbr>0x7f80f16> Did you</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#33ee33;background:#333333"> </span><u></u><u></u></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:<wbr>1000:in `eval' uri:classloader:/META-INF/<wbr>jruby.home/lib/ruby/stdlib/<wbr>erb.rb:864:in
`result' /projects/Archivespace/dcs-<wbr>archivesspace/backend/app/lib/<wbr>reports/report_response.rb:50:<wbr>in `render' /projects/Archivespace/dcs-<wbr>archivesspace/backend/app/lib/<wbr>reports/report_response.rb:21:<wbr>in</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#33ee33;background:#333333"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#33ee33;background:#333333">`block in generate' /projects/Archivespace/dcs-<wbr>archivesspace/backend/app/lib/<wbr>reports/json_response.rb:5:in `initialize' /projects/Archivespace/dcs-<wbr>archivesspace/backend/app/lib/<wbr>reports/report_response.rb:27:<wbr>in
`generate' /projects/Archivespace/dcs-<wbr>archivesspace/backend/app/lib/<wbr>job_runners/reports_runner.rb:<wbr>37:in</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#33ee33;background:#333333"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#33ee33;background:#333333">`block in run' /projects/Archivespace/dcs-<wbr>archivesspace/backend/app/<wbr>model/db.rb:111:in `block in open' /projects/Archivespace/dcs-<wbr>archivesspace/backend/app/<wbr>model/db.rb:75:in
`block in transaction' /projects/Archivespace/dcs-<wbr>archivesspace/build/gems/gems/<wbr>sequel-4.20.0/lib/sequel/<wbr>database/transactions.rb:134:<wbr>in</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#33ee33;background:#333333"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#33ee33;background:#333333">`_transaction' /projects/Archivespace/dcs-<wbr>archivesspace/build/gems/gems/<wbr>sequel-4.20.0/lib/sequel/<wbr>database/transactions.rb:108:<wbr>in `block in transaction'
/projects/Archivespace/dcs-<wbr>archivesspace/build/gems/gems/<wbr>sequel-4.20.0/lib/sequel/<wbr>connection_pool/threaded.rb:<wbr>98:in</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#33ee33;background:#333333"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#33ee33;background:#333333">`hold' /projects/Archivespace/dcs-<wbr>archivesspace/build/gems/gems/<wbr>sequel-4.20.0/lib/sequel/<wbr>database/connecting.rb:255:in `synchronize' /projects/Archivespace/dcs-<wbr>archivesspace/build/gems/gems/<wbr>sequel-4.20.0/lib/sequel/<wbr>database/transactions.rb:97:in
`transaction'</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#33ee33;background:#333333"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#33ee33;background:#333333">/projects/Archivespace/dcs-<wbr>archivesspace/backend/app/<wbr>model/db.rb:74:in `transaction' /projects/Archivespace/dcs-<wbr>archivesspace/backend/app/<wbr>model/db.rb:110:in
`block in open' org/jruby/RubyFixnum.java:305:<wbr>in `times' /projects/Archivespace/dcs-<wbr>archivesspace/backend/app/<wbr>model/db.rb:107:in</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#33ee33;background:#333333"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#33ee33;background:#333333">`open' /projects/Archivespace/dcs-<wbr>archivesspace/backend/app/<wbr>model/db.rb:432:in `block in DB' /projects/Archivespace/dcs-<wbr>archivesspace/backend/app/lib/<wbr>job_runners/reports_runner.rb:<wbr>36:in
`run' /projects/Archivespace/dcs-<wbr>archivesspace/backend/app/lib/<wbr>background_job_queue.rb:126:in</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#33ee33;background:#333333"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#33ee33;background:#333333">`run_pending_job' /projects/Archivespace/dcs-<wbr>archivesspace/backend/app/lib/<wbr>background_job_queue.rb:169:in `block in start_background_thread' Done.</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">I have gotten them to run successfully by commenting out this line:<u></u><u></u></p>
</div>
<div>
<table class="m_1051958047275189884MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="border-collapse:collapse;box-sizing:border-box;border-spacing:0px">
<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="m_1051958047275189884LC6">
<p class="MsoNormal" style="line-height:15.0pt"><span style="font-size:9.0pt;font-family:Consolas;color:#24292e"> </span><u></u><u></u></p>
<p class="MsoNormal" style="line-height:15.0pt"><span style="font-size:9.0pt;font-family:Consolas;color:#24292e"> </span><u></u><u></u></p>
<p class="MsoNormal" style="line-height:15.0pt"><span class="m_1051958047275189884pl-sre"><span style="font-size:9.0pt;font-family:Consolas;color:#24292e">#
</span></span><u></u><u></u></p>
<p class="MsoNormal" style="line-height:15.0pt"><span class="m_1051958047275189884pl-smi"><span style="font-size:9.0pt;font-family:Consolas;color:#24292e"> </span></span><u></u><u></u></p>
<p class="MsoNormal" style="line-height:15.0pt"><span class="m_1051958047275189884pl-smi"><span style="font-size:9.0pt;font-family:Consolas;color:#24292e">@report</span></span><span class="m_1051958047275189884pl-sre"><span style="font-size:9.0pt;font-family:Consolas;color:#24292e">.orientation
</span></span><u></u><u></u></p>
<p class="MsoNormal" style="line-height:15.0pt"><span class="m_1051958047275189884pl-k"><span style="font-size:9.0pt;font-family:Consolas;color:#d73a49"> </span></span><u></u><u></u></p>
<p class="MsoNormal" style="line-height:15.0pt"><span class="m_1051958047275189884pl-k"><span style="font-size:9.0pt;font-family:Consolas;color:#d73a49">=</span></span><span class="m_1051958047275189884pl-sre"><span style="font-size:9.0pt;font-family:Consolas;color:#24292e">
</span></span><u></u><u></u></p>
<p class="MsoNormal" style="line-height:15.0pt"><span class="m_1051958047275189884pl-s"><span style="font-size:9.0pt;font-family:Consolas;color:#032f62"> </span></span><u></u><u></u></p>
<p class="MsoNormal" style="line-height:15.0pt"><span class="m_1051958047275189884pl-pds"><span style="font-size:9.0pt;font-family:Consolas;color:#032f62">'</span></span><span class="m_1051958047275189884pl-s"><span style="font-size:9.0pt;font-family:Consolas;color:#032f62">landscape</span></span><span class="m_1051958047275189884pl-pds"><span style="font-size:9.0pt;font-family:Consolas;color:#032f62">'</span></span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Segoe UI";color:#24292e"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Segoe UI";color:#24292e"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Segoe UI";color:#24292e"> </span><u></u><u></u></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><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Segoe UI";color:#24292e"> </span><u></u><u></u></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=" target="_blank">https://github.com/<wbr>archivesspace/archivesspace/<wbr>blob/master/backend/app/views/<wbr>reports/report.erb#L6</a><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">But this is not a new addition and was not (I believe) broken earlier. <u></u><u></u></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. <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">— Steve. <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</div></div></div>
</div>
<br>______________________________<wbr>_________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org">Archivesspace_Users_Group@<wbr>lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" rel="noreferrer" target="_blank">http://lyralists.lyrasis.org/<wbr>mailman/listinfo/<wbr>archivesspace_users_group</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div style="font-size:12.8000001907349px"><b>Dallas Pillen<br></b>Archivist for Metadata and Digital Projects<b><br></b></div><div style="font-size:12.8000001907349px"><br></div><div style="font-size:12.8000001907349px;color:rgb(0,0,0)"><img src="https://webapps.lsa.umich.edu/dean/lsa_emails/bentley-sig-em.png" height="40" width="351"><br></div><div style="font-size:12.8000001907349px;color:rgb(0,0,0)"><font size="1"> <a href="http://bentley.umich.edu/" style="color:rgb(17,85,204)" target="_blank">Bentley Historical Library</a></font></div><div style="font-size:12.8000001907349px;color:rgb(0,0,0)"><font size="1"> 1150 Beal Avenue</font></div><div style="font-size:12.8000001907349px;color:rgb(0,0,0)"><font size="1"> Ann Arbor, Michigan 48109-2113</font><span style="font-size:x-small"> </span></div><div style="font-size:12.8000001907349px"><a value="+17347643482" style="font-size:x-small"><font color="#000000"> </font></a><a value="+17347643482" style="color:rgb(34,34,34);font-size:x-small">734.647.3559</a></div><div style="font-size:12.8000001907349px;color:rgb(0,0,0)"><font size="1"> <a href="https://twitter.com/umichBentley" style="color:rgb(17,85,204)" target="_blank">Twitter</a> <a href="https://www.facebook.com/bentleyhistoricallibrary" style="color:rgb(17,85,204)" target="_blank">Facebook </a></font></div></div></div></div></div></div></div></div></div></div>
</div>