<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 12 (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:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:Courier;
panose-1:2 7 4 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:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Segoe UI";
panose-1:2 11 5 2 4 2 4 2 2 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
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;}
span.apple-converted-space
{mso-style-name:apple-converted-space;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.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;}
/* List Definitions */
@list l0
{mso-list-id:244387403;
mso-list-template-ids:737072518;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1
{mso-list-id:750273177;
mso-list-template-ids:1923530826;}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2
{mso-list-id:1039168168;
mso-list-template-ids:-1067403672;}
@list l2:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3
{mso-list-id:1145732372;
mso-list-template-ids:-2023216928;}
@list l3:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l4
{mso-list-id:1300762360;
mso-list-template-ids:-292416740;}
@list l4:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l5
{mso-list-id:1482307035;
mso-list-template-ids:-1158223256;}
@list l5:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l6
{mso-list-id:1801604875;
mso-list-template-ids:1672611896;}
@list l6:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l7
{mso-list-id:2050179244;
mso-list-template-ids:-2053066124;}
@list l7:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l8
{mso-list-id:2124692114;
mso-list-template-ids:1275761202;}
@list l8:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></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 style='word-wrap: break-word;-webkit-nbsp-mode: space;-webkit-line-break: after-white-space'><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Awesome! Thanks so much.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Patrick Galligan<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Rockefeller Archive Center<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Assistant Digital Archivist<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>914-366-6386<o:p></o:p></span></p></div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> archivesspace_users_group-bounces@lyralists.lyrasis.org [mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org] <b>On Behalf Of </b>Brian Hoffman<br><b>Sent:</b> Tuesday, September 01, 2015 5:39 PM<br><b>To:</b> Archivesspace Users Group<br><b>Subject:</b> Re: [Archivesspace_Users_Group] Problems with ASpace reports<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Hi Karrie,<o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Yes, as it happens I was dealing with the same issue today. You can install this plugin and it will bring back the stored procedures. Please test this on a copy of your database first!<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><a href="https://github.com/quoideneuf/aspace_stored_procedures">https://github.com/quoideneuf/aspace_stored_procedures</a><o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>And I am obliged to say tsk tsk for doing find and replace on your sql dump but will leave it at that if you promise not to do it again!<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Brian<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><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><p class=MsoNormal>On Sep 1, 2015, at 5:33 PM, Karrie L Roberson <<a href="mailto:robersonkl@sfasu.edu">robersonkl@sfasu.edu</a>> wrote:<o:p></o:p></p></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>It returns "empty set". Is there anything we can do to add those stored procedures back?<o:p></o:p></span></p><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'><o:p> </o:p></span></p><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>We had to make some changes to the data that got carried over from the migration from Archon. :/<o:p></o:p></span></p><div><div><div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Thanks,<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Karrie<o:p></o:p></span></p></div></div></div><div><div class=MsoNormal align=center style='text-align:center'><hr size=2 width="100%" align=center></div><div id=divRpF779671><p class=MsoNormal style='margin-bottom:12.0pt'><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span class=apple-converted-space><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> </span></span><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><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 Brian Hoffman [<a href="mailto:brianjhoffman@gmail.com">brianjhoffman@gmail.com</a>]<br><b>Sent:</b><span class=apple-converted-space> </span>Tuesday, September 01, 2015 4:28 PM<br><b>To:</b><span class=apple-converted-space> </span>Archivesspace Users Group<br><b>Subject:</b><span class=apple-converted-space> </span>Re: [Archivesspace_Users_Group] Problems with ASpace reports</span><o:p></o:p></p></div><div><p class=MsoNormal>Hi,<o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>It sounds like you may have lost the mysql stored procedures that the reports require.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>What happens when you log in to mysql and type:<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>> select name from mysql.proc<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>P.S. What caused you to dump the mysql file, edit it, and reload it? That is not something I recommend doing.<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><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><p class=MsoNormal>On Sep 1, 2015, at 5:08 PM, Karrie L Roberson <<a href="mailto:robersonkl@sfasu.edu" target="_blank">robersonkl@sfasu.edu</a>> wrote:<o:p></o:p></p></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>We're seeing the same type of messages as below with the messages that are seen below. Our error message is "</span><span style='font-size:10.5pt;font-family:"Helvetica","sans-serif";color:#A94442;background:#F2DEDE'>ResourcesLocationsListReport - net.sf.jasperreports.engine.JRException: Error executing SQL statement for : resourcesLocationsList</span><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>".<o:p></o:p></span></p><div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>We edited the 'config.rb' file with the jasper reports uncommented, updated the 2 files in the PR issue mentioned below, and restarted Archivesspace.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Just FYI: Weeks ago, we've done a command line mysqldump of the database without the "--routines" flag added (with ArchivesSpace shutdown), made some changes to the file and replaced the database with the updated file.<o:p></o:p></span></p></div><div><div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'><o:p> </o:p></span></p><div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Thanks,<br>Karrie <o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'><br>“The views and opinions expressed in this message are my own and do not necessarily reflect the views and opinions of Stephen F. Austin State University, its Board of Regents, or the State of Texas.”<o:p></o:p></span></p></div></div></div><div><div class=MsoNormal align=center style='text-align:center'><hr size=2 width="100%" align=center></div><div id=divRpF559546><p class=MsoNormal style='margin-bottom:12.0pt'><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span class=apple-converted-space><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> </span></span><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a><span class=apple-converted-space> </span>[<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>] on behalf of Emma Jolley [<a href="mailto:EJOLLEY@nla.gov.au" target="_blank">EJOLLEY@nla.gov.au</a>]<br><b>Sent:</b><span class=apple-converted-space> </span>Sunday, August 30, 2015 11:57 PM<br><b>To:</b><span class=apple-converted-space> </span>Archivesspace Users Group<br><b>Subject:</b><span class=apple-converted-space> </span>Re: [Archivesspace_Users_Group] Problems with ASpace reports</span><o:p></o:p></p></div><div><div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Hi</span><o:p></o:p></p></div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Apologies for the long delay in replying. I can send you a MySQL dump of the AS database – however there is a lot of confidential acquisition information in the database. Are there any procedures for confidential information?</span><o:p></o:p></p></div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Thanks</span><o:p></o:p></p></div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Emma</span><o:p></o:p></p></div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><div><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span class=apple-converted-space><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> </span></span><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a><span class=apple-converted-space> </span>[<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org</a>]<span class=apple-converted-space> </span><b>On Behalf Of<span class=apple-converted-space> </span></b>Nathan Stevens<br><b>Sent:</b><span class=apple-converted-space> </span>Friday, 14 August 2015 10:28 PM<br><b>To:</b><span class=apple-converted-space> </span>Archivesspace Users Group<br><b>Subject:</b><span class=apple-converted-space> </span>Re: [Archivesspace_Users_Group] Problems with ASpace reports</span><o:p></o:p></p></div><p class=MsoNormal> <o:p></o:p></p><div><div><p class=MsoNormal>Hi,<br><br>The JDK version shouldn't be a problem. This seems like the report is encountering some data it can't handle. Can you send us a MySQL dump of your ASpace database so we can try and replicate the problem on our end?<o:p></o:p></p></div></div><div><p class=MsoNormal> <o:p></o:p></p><div><div><p class=MsoNormal>On Fri, Aug 14, 2015 at 3:31 AM, Emma Jolley <<a href="mailto:EJOLLEY@nla.gov.au" target="_blank"><span style='color:purple'>EJOLLEY@nla.gov.au</span></a>> wrote:<o:p></o:p></p></div><div><div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>My apologies for not having sent through the information about the Log. I have to liaise for some time with our IT to get this information. They have sent me the following information which may be of help?</span><o:p></o:p></p></div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Many thanks</span><o:p></o:p></p></div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Emma</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>****</span><o:p></o:p></p></div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><div><p class=MsoNormal><span style='font-size:10.5pt;font-family:"Calibri","sans-serif"'>The log entry when running (as an example) the report mentioned in the email below is:</span><o:p></o:p></p></div><p class=MsoNormal><span style='font-size:10.5pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:#EBEBEB'><span style='font-size:9.0pt;font-family:Courier;color:#011993'>D, [2015-08-10T17:58:14.599000 #3236] DEBUG -- : Thread-10076116: GET /repositories/2/reports/accessionsunprocessedreport?lock_version=&format=json [session: nil]</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:#EBEBEB'><span style='font-size:9.0pt;font-family:Courier;color:#011993'>D, [2015-08-10T17:58:14.602000 #3236] DEBUG -- : Thread-10076116: Post-processed params: {:format=>"json", :repo_id=>2}</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:Courier;color:#007F00;background:aqua'>D, [2015-08-10T17:58:14.892000 #3236] DEBUG -- : Thread-10076116: Responded with [404, {"Content-Type"=>"application/json; charset=UTF-8", "Cache-Control"=>"private, must-revalidate, max-age=0", "Content-Length"=>"144"}, ["{\"error\":{\"AccessionsUnprocessedReport\":[\"net.sf.jasperreports.engine.JRException: Error executing SQL statement for : accessionsUnprocessed\"]}}"]]... in 292.0ms</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:#EBEBEB'><span style='font-size:9.0pt;font-family:Courier;color:#011993'> Rendered shared/_breadcrumb.html.erb (1.0ms)</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:#EBEBEB'><span style='font-size:9.0pt;font-family:Courier;color:#011993'> Rendered /opt/archivesspace-1.3.0/archivesspace/plugins/nla_accession_reports/frontend/views/reports/index.html.erb within layouts/application (82.0ms)</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:#EBEBEB'><span style='font-size:9.0pt;font-family:Courier;color:#011993'> Rendered shared/_browser_support.html.erb (0.0ms)</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:#EBEBEB'><span style='font-size:9.0pt;font-family:Courier;color:#011993'> Rendered shared/_header_user.html.erb (6.0ms)</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:#EBEBEB'><span style='font-size:9.0pt;font-family:Courier;color:#011993'> Rendered shared/_header_global.html.erb (6.0ms)</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:#EBEBEB'><span style='font-size:9.0pt;font-family:Courier;color:#011993'> Rendered site/_branding.html.erb (0.0ms)</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:#EBEBEB'><span style='font-size:9.0pt;font-family:Courier;color:#011993'> Rendered shared/_advanced_search.html.erb (5.0ms)</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:#EBEBEB'><span style='font-size:9.0pt;font-family:Courier;color:#011993'> Rendered shared/_header_repository.html.erb (18.0ms)</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:#EBEBEB'><span style='font-size:9.0pt;font-family:Courier;color:#011993'> Rendered site/_footer.html.erb (0.0ms)</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:#EBEBEB'><span style='font-size:9.0pt;font-family:Courier;color:#011993'> Rendered shared/_templates.html.erb (2.0ms)</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:#EBEBEB'><span style='font-size:9.0pt;font-family:Courier;color:#011993'>Completed 200 OK in 448.0ms (Views: 114.0ms)</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:10.5pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><div><p class=MsoNormal><span style='font-size:10.5pt;font-family:"Calibri","sans-serif"'>Which is not helpful as it essentially just says exactly what gets displayed on the interface.</span><o:p></o:p></p></div><p class=MsoNormal><span style='font-size:10.5pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><div><p class=MsoNormal><span style='font-size:9.0pt;font-family:Courier;color:#011993;background:#EBEBEB'>net.sf.jasperreports.engine.JRException: Error executing SQL statement for : accessionsUnprocessed</span><o:p></o:p></p></div><p class=MsoNormal><span style='font-size:10.5pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><div><p class=MsoNormal><span style='font-size:10.5pt;font-family:"Calibri","sans-serif"'>I’ve run the query in this report directly against the database successfully (cut and paste from </span><span style='font-size:9.0pt;font-family:Courier;color:#011993;background:#EBEBEB'>reports/Accessions/AccessionsUnprocessedReport/AccessionsUnprocessedReport.jrxml</span><span style='font-size:10.5pt;font-family:"Calibri","sans-serif"'> and substituting in the repo id) so I think the SQL itself is sound. </span><o:p></o:p></p></div><p class=MsoNormal><span style='font-size:10.5pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><div><p class=MsoNormal><span style='font-size:10.5pt;font-family:"Calibri","sans-serif"'>Further info:</span><o:p></o:p></p></div><p class=MsoNormal><span style='font-size:10.5pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><div><p class=MsoNormal><span style='font-size:10.5pt;font-family:"Calibri","sans-serif"'>The report config being used are:</span><o:p></o:p></p></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:#EBEBEB'><span style='font-size:9.0pt;font-family:Courier;color:#011993'>#AppConfig[:report_page_layout] = "letter landscape"</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:#EBEBEB'><span style='font-size:9.0pt;font-family:Courier;color:#011993'>AppConfig[:enable_jasper] = true </span><o:p></o:p></p><div><p class=MsoNormal><span style='font-size:9.0pt;font-family:Courier;color:#011993;background:#EBEBEB'>AppConfig[:compile_jasper] = true</span><span style='font-size:9.0pt;font-family:Courier'> </span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:10.5pt;font-family:"Calibri","sans-serif"'>I’ve tried with the report_page_layout both commented and uncommented.</span><o:p></o:p></p></div><p class=MsoNormal><span style='font-size:10.5pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><div><p class=MsoNormal><span style='font-size:10.5pt;font-family:"Calibri","sans-serif"'>The java version is:</span><o:p></o:p></p></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:#EBEBEB'><span style='font-size:9.0pt;font-family:Courier;color:#011993'>java version "1.7.0_85"</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:#EBEBEB'><span style='font-size:9.0pt;font-family:Courier;color:#011993'>OpenJDK Runtime Environment (rhel-2.6.1.3.el6_7-x86_64 u85-b01)</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:#EBEBEB'><span style='font-size:9.0pt;font-family:Courier;color:#011993'>OpenJDK 64-Bit Server VM (build 24.85-b03, mixed mode)</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:10.5pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><div><p class=MsoNormal><span style='font-size:10.5pt;font-family:"Calibri","sans-serif"'>Could there be an issue with using the OpenJDK rather than Oracle’s JDK perhaps ?</span><o:p></o:p></p></div><p class=MsoNormal><span style='font-size:10.5pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><div><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span class=apple-converted-space><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> </span></span><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank"><span style='color:purple'>archivesspace_users_group-bounces@lyralists.lyrasis.org</span></a><span class=apple-converted-space> </span>[mailto:<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank"><span style='color:purple'>archivesspace_users_group-bounces@lyralists.lyrasis.org</span></a>]<span class=apple-converted-space> </span><b>On Behalf Of<span class=apple-converted-space> </span></b>Brian Hoffman<br><b>Sent:</b><span class=apple-converted-space> </span>Friday, 14 August 2015 12:37 PM<br><b>To:</b><span class=apple-converted-space> </span>Archivesspace Users Group</span><o:p></o:p></p></div><div><div><div><p class=MsoNormal><br><b>Subject:</b><span class=apple-converted-space> </span>Re: [Archivesspace_Users_Group] Problems with ASpace reports<o:p></o:p></p></div></div></div></div></div><div><div><p class=MsoNormal> <o:p></o:p></p><div><p class=MsoNormal><span style='background:yellow'>Is it possible that your database was restored from a backup or that you created your database elsewhere and then imported it into MySQL? If so, you may simply be missing the stored procedures the Jasper reports rely on. There is a PR concerning this issue here:</span><o:p></o:p></p></div><div><p class=MsoNormal> <o:p></o:p></p></div><div><div><p class=MsoNormal><a href="https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_archivesspace_archivesspace_pull_244&d=AwMGaQ&c=2X_btuPRWkGwRX26NHIotw&r=FD0Xci-wh01Dc1yt0aSp4ADMuu-zB2G2dpCCNNXfih0&m=fW2PblqG-EuWe_NmccDnQngjowe_utp-8LnFzzlbwaU&s=lnMBrdO99DMYnO5QSios7qmzuamXO_pZTlgirFph-9E&e=" target="_blank"><span style='color:purple'>https://github.com/archivesspace/archivesspace/pull/244</span></a><o:p></o:p></p></div></div><div><p class=MsoNormal> <o:p></o:p></p></div><div><div><p class=MsoNormal>Brian<o:p></o:p></p></div></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><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><div><p class=MsoNormal>On Aug 7, 2015, at 5:49 AM, Chris Fitzpatrick <<a href="mailto:Chris.Fitzpatrick@lyrasis.org" target="_blank"><span style='color:purple'>Chris.Fitzpatrick@lyrasis.org</span></a>> wrote:<o:p></o:p></p></div></div><p class=MsoNormal> <o:p></o:p></p><div><div><div><div style='margin-bottom:12.0pt'><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p></div></div><div><div><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'>Hi Emma,</span><o:p></o:p></p></div></div><div><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p></div><div><div><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'>Can you look at what's being output into the log? </span><o:p></o:p></p></div></div><div><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p></div><div><div><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'>The easiest way to see what the report is doing is to look at the Jasper XML, which you can see here =><a href="https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_archivesspace_archivesspace_blob_master_reports_Accessions_AccessionsUnprocessedReport_AccessionsUnprocessedReport.jrxml-23L20-2DL37&d=AwMGaQ&c=2X_btuPRWkGwRX26NHIotw&r=FD0Xci-wh01Dc1yt0aSp4ADMuu-zB2G2dpCCNNXfih0&m=fW2PblqG-EuWe_NmccDnQngjowe_utp-8LnFzzlbwaU&s=E3g_D7ALOFUy_TOVZ77fVSG_kMXqF5u9AZkt-ff0MVc&e=" target="_blank"><span style='color:purple'>https://github.com/archivesspace/archivesspace/blob/master/reports/Accessions/AccessionsUnprocessedReport/AccessionsUnprocessedReport.jrxml#L20-L37</span></a></span><o:p></o:p></p></div></div><div><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p></div><div><div><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'>The basic SQL query is defined in the <query> tag, with the formatting happening below. You can edit this file to fit your needs, then restart ASpace to have it recompiled. </span><o:p></o:p></p></div></div><div><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p></div><div><div><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'>b,chris. </span><o:p></o:p></p></div></div><div><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p></div><div><div name=divtagdefaultwrapper><div><div><p class=MsoNormal style='background:white'><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>Chris Fitzpatrick | Developer, ArchivesSpace<br>Skype: chrisfitzpat | Phone:<span class=apple-converted-space> </span><a href="tel:918.236.6048" target="_blank"><span style='color:purple'>918.236.6048</span></a><br><a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__archivesspace.org_&d=AwMGaQ&c=2X_btuPRWkGwRX26NHIotw&r=FD0Xci-wh01Dc1yt0aSp4ADMuu-zB2G2dpCCNNXfih0&m=fW2PblqG-EuWe_NmccDnQngjowe_utp-8LnFzzlbwaU&s=tLDoAR4LkXMLuD8XoLPRfR3Q--MISpnxaUxWqVJPZY8&e=" target="_blank"><span style='color:purple'>http://archivesspace.org/</span></a></span><o:p></o:p></p></div></div></div></div><div style='margin-bottom:12.0pt'><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p></div><div><div class=MsoNormal align=center style='text-align:center;background:white'><span style='font-family:"Calibri","sans-serif"'><hr size=3 width=571 style='width:428.5pt' align=center></span></div><div><div><p class=MsoNormal style='background:white'><b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>From:</span></b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> <a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank"><span style='color:purple'>archivesspace_users_group-bounces@lyralists.lyrasis.org</span></a><span class=apple-converted-space> </span><<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank"><span style='color:purple'>archivesspace_users_group-bounces@lyralists.lyrasis.org</span></a>> on behalf of Emma Jolley <<a href="mailto:EJOLLEY@nla.gov.au" target="_blank"><span style='color:purple'>EJOLLEY@nla.gov.au</span></a>><br><b>Sent:</b> Friday, August 7, 2015 7:13 AM<br><b>To:</b> Archivesspace Users Group (<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" target="_blank"><span style='color:purple'>archivesspace_users_group@lyralists.lyrasis.org</span></a>)<br><b>Subject:</b> Re: [Archivesspace_Users_Group] Problems with ASpace reports</span><o:p></o:p></p></div><div><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p></div></div><div><div><div><div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Hi Chris</span><o:p></o:p></p></div></div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><div><div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>We have had the same issues as Robin with the reports. We have tried to implement your suggested solutions below but now received the following error message which I’ve copied below. Any advice on this?</span><o:p></o:p></p></div></div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><div><div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>In addition, I have asked previously but have never received an answer – I wonder if there is any documentation on what criteria the reports use to identify records that meet the nominated criteria. For example what fields is used to indicate an unprocessed Accession and what field is used to indicate an uncatalogued accession?</span><o:p></o:p></p></div></div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><div><div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Many thanks</span><o:p></o:p></p></div></div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><div><div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Emma</span><o:p></o:p></p></div></div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><div><div><p class=MsoNormal style='background:white'><image007.png><o:p></o:p></p></div></div><div><p class=MsoNormal style='background:white'><span style='font-size:10.5pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p></div><div><div><p class=MsoNormal style='background:white'><span style='font-size:10.0pt;font-family:"Segoe UI","sans-serif";color:#1F497D'> </span><o:p></o:p></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><div><div><p class=MsoNormal style='background:white'><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> <a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank"><span style='color:purple'>archivesspace_users_group-bounces@lyralists.lyrasis.org</span></a> [<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank"><span style='color:purple'>mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org</span></a>] <b>On Behalf Of </b>Chris Fitzpatrick<br><b>Sent:</b> Thursday, 6 August 2015 9:16 PM<br><b>To:</b> Archivesspace Users Group<br><b>Cc:</b> Zalduendo, Ines; Wendler, Robin King; Della Monica, Ilaria<br><b>Subject:</b> Re: [Archivesspace_Users_Group] Problems with ASpace reports</span><o:p></o:p></p></div></div></div></div><p class=MsoNormal style='background:white'> <o:p></o:p></p><div><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><div><div><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'>Hi Robin,</span><o:p></o:p></p></div></div><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><div><div><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'>So, first you need to make sure you compiled your jasper reports on startup. To do this, edit the<span class=apple-converted-space> </span><a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__config.rb&d=AwQGaQ&c=2X_btuPRWkGwRX26NHIotw&r=FD0Xci-wh01Dc1yt0aSp4ADMuu-zB2G2dpCCNNXfih0&m=fW2PblqG-EuWe_NmccDnQngjowe_utp-8LnFzzlbwaU&s=gsazHb5GvapfRKK_QuagvejxEUPByer3KlDtd_8SStI&e=" target="_blank"><span style='color:purple'>config.rb</span></a><span class=apple-converted-space> </span>file to have:</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'>AppConfig[:compile_jasper] = true</span><o:p></o:p></p></div></div><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><div><div><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'>and restart ASpace.</span><o:p></o:p></p></div></div><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><div><div><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'>This will compile the jasper jxml files ( which is most likely what's causing the "can't convert nil to String" errors)</span><o:p></o:p></p></div></div><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><div><div><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'>Also, you'll need to look at both your application and database server and make sure you're not running into a performance issue. Reports can hit the database really hard, so the timeout errors you're seeing could be the result of your server running out of RAM. </span><o:p></o:p></p></div></div><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><div><div><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'>In regards to the CSV and Excel and HTML files, yes I would say those are formatted rather poorly by default. You can edit this by modifing your Jasper reports using something like iReport or <a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__community.jaspersoft.com_project_jaspersoft-2Dstudio&d=AwMGaQ&c=2X_btuPRWkGwRX26NHIotw&r=FD0Xci-wh01Dc1yt0aSp4ADMuu-zB2G2dpCCNNXfih0&m=fW2PblqG-EuWe_NmccDnQngjowe_utp-8LnFzzlbwaU&s=1ZkU9fzjJHPAB5OIF_s_JSQTeVGtBEcG5xDJVfwWvww&e=" target="_blank"><span style='color:purple'>Jasper studio</span></a>. Just be sure to recompile your reports.</span><o:p></o:p></p></div></div><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><div><div><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'>For the parameters, yes this feature is going to be included in a future release. I believe those labels are artifacts from AT. </span><o:p></o:p></p></div></div><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><div><div><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'>best, Chris. </span><o:p></o:p></p></div></div><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><div><div name=divtagdefaultwrapper><div><div><div><div><p class=MsoNormal style='background:white'><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>Chris Fitzpatrick | Developer, ArchivesSpace<br>Skype: chrisfitzpat | Phone:<span class=apple-converted-space> </span><a href="tel:918.236.6048" target="_blank"><span style='color:purple'>918.236.6048</span></a><br><a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__archivesspace.org_&d=AwMGaQ&c=2X_btuPRWkGwRX26NHIotw&r=FD0Xci-wh01Dc1yt0aSp4ADMuu-zB2G2dpCCNNXfih0&m=fW2PblqG-EuWe_NmccDnQngjowe_utp-8LnFzzlbwaU&s=tLDoAR4LkXMLuD8XoLPRfR3Q--MISpnxaUxWqVJPZY8&e=" target="_blank"><span style='color:purple'>http://archivesspace.org/</span></a></span><o:p></o:p></p></div></div></div></div></div></div><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><div><div class=MsoNormal align=center style='text-align:center;background:white'><span style='font-family:"Calibri","sans-serif"'><hr size=2 width="98%" align=center></span></div><div><div><div><p class=MsoNormal style='background:white'><b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>From:</span></b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'><a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank"><span style='color:purple'>archivesspace_users_group-bounces@lyralists.lyrasis.org</span></a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank"><span style='color:purple'>archivesspace_users_group-bounces@lyralists.lyrasis.org</span></a>> on behalf of McElheny, Robin G. <<a href="mailto:robin_mcelheny@harvard.edu" target="_blank"><span style='color:purple'>robin_mcelheny@harvard.edu</span></a>><br><b>Sent:</b> Wednesday, August 5, 2015 5:55 PM<br><b>To:</b> Archivesspace Users Group<br><b>Cc:</b> Zalduendo, Ines; Wendler, Robin King; Della Monica, Ilaria<br><b>Subject:</b> [Archivesspace_Users_Group] Problems with ASpace reports</span><o:p></o:p></p></div></div><div><p class=MsoNormal style='background:white'><span style='font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p></div></div><div><div><div><div><p class=MsoNormal style='line-height:13.8pt;background:white'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>At Harvard, we are having major problems with the reporting functionality in the latest ArchivesSpace release. We have tested the reports in our own installation and in the ASpace sandbox with very little success. See below for more details.</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal style='line-height:13.8pt;background:white'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>We didn’t see any issues in JIRA that reflects these problems. Has anyone else encountered them? If so, have you resolved them – and how?</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal style='line-height:13.8pt;background:white'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Record selection issues:</span><o:p></o:p></p></div></div><ul style='margin-top:0in' type=disc><li class=MsoNormal style='line-height:13.8pt;mso-list:l1 level1 lfo1;background:white'><span style='font-family:"Calibri","sans-serif"'>The Accessions Acquired and Accessions Production reports supposedly allow for specified time periods, but no date parameters show up in the report user interface.</span><o:p></o:p></li></ul><div><div><p class=MsoNormal style='line-height:13.8pt;background:white'><image008.jpg><o:p></o:p></p></div></div><p class=MsoNormal style='line-height:13.8pt;background:white'> <o:p></o:p></p><ul style='margin-top:0in' type=disc><li class=MsoNormal style='line-height:13.8pt;mso-list:l4 level1 lfo2;background:white'><span style='font-family:"Calibri","sans-serif"'>In other cases it is unclear how/where to select records for the report (e.g. Digital Object Record). No selection parameters appear in the report interface. Are we supposed to browse records, then select them using the check boxes, then generate reports?</span><o:p></o:p></li></ul><p class=MsoNormal style='line-height:13.8pt;background:white'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><div><div><p class=MsoNormal style='line-height:13.8pt;background:white'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Report format issues:</span><o:p></o:p></p></div></div><ul style='margin-top:0in' type=disc><li class=MsoNormal style='line-height:13.8pt;mso-list:l0 level1 lfo3;background:white'><span style='font-family:"Calibri","sans-serif"'>In cases where we were able to download CSV and Excel reports (Accessions Cataloged, Accessions Deaccessions List, Accessions Inventory), we were unable to sort these reports because the formatting appears to be frozen. The output of the report does not match the file type. It is like getting a static document layered on top of a spreadsheet, rather than an actual spreadsheet.</span><o:p></o:p></li></ul><p class=MsoNormal style='line-height:13.8pt;background:white'> <o:p></o:p></p><ul style='margin-top:0in' type=disc><li class=MsoNormal style='line-height:13.8pt;mso-list:l7 level1 lfo4;background:white'><span style='font-family:"Calibri","sans-serif"'>Xlsx downloads don't export uniform cell sizes, so Excel sorting returns a warning saying "this operation requires the merged cells to be identically sized"</span><o:p></o:p></li></ul><p class=MsoNormal style='line-height:13.8pt;background:white'> <o:p></o:p></p><ul style='margin-top:0in' type=disc><li class=MsoNormal style='line-height:13.8pt;mso-list:l2 level1 lfo5;background:white'><span style='font-family:"Calibri","sans-serif"'>In order for the Xlsx downloads to be useful, each field should be in a separate column to allow tallying and sorting, but the ASpace downloads don’t do this. Some examples:</span><o:p></o:p></li></ul><p class=MsoNormal style='line-height:13.8pt;background:white'> <o:p></o:p></p><div><div><p class=MsoNormal style='line-height:13.8pt;background:white'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>In the case of the Accession Deaccession List Report, opening the CSV download in Excel resulted in a very messy, single column spreadsheet that broke data about one deaccesion across multiple rows. (Example: row 48= "Additional records of the League of Women Voters (Cambridge, Mass.),,,,,,1376,,," and row 49 = ",Accession Date:,,05/01/1968,Extent:,1.00 Linear_feet,,,,:").</span><o:p></o:p></p></div></div><p class=MsoNormal style='line-height:13.8pt;background:white'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><div><div><p class=MsoNormal style='line-height:13.8pt;background:white'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Here is a screen shot:</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal style='line-height:13.8pt;background:white'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'><image009.jpg></span><o:p></o:p></p></div></div><ul style='margin-top:0in' type=disc><li class=MsoNormal style='line-height:13.8pt;mso-list:l5 level1 lfo6;background:white'><span style='font-family:"Calibri","sans-serif"'>Here’s another example:</span><o:p></o:p></li></ul><div><div><p class=MsoNormal style='line-height:13.8pt;background:white'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'><image010.jpg></span><o:p></o:p></p></div></div><ul style='margin-top:0in' type=disc><li class=MsoNormal style='line-height:13.8pt;mso-list:l6 level1 lfo7;background:white'><span style='font-family:"Calibri","sans-serif"'>In the case of an HTML report, it displays page footers – odd for online display.</span><o:p></o:p></li></ul><div><div><p class=MsoNormal style='line-height:13.8pt;background:white'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'><image011.jpg></span><o:p></o:p></p></div></div><p class=MsoNormal style='line-height:13.8pt;background:white'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><div><div><p class=MsoNormal style='line-height:13.8pt;background:white'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Report failure/timeout:</span><o:p></o:p></p></div></div><ul style='margin-top:0in' type=disc><li class=MsoNormal style='line-height:13.8pt;mso-list:l3 level1 lfo8;background:white'><span style='font-family:"Calibri","sans-serif"'>We encountered many failures.</span><o:p></o:p></li></ul><div><div><p class=MsoNormal style='line-height:13.8pt;background:white'>Example:<o:p></o:p></p></div></div><div><div><p class=MsoNormal style='line-height:13.8pt;background:white'>When we attempted to download an XLSX AccessionsAcquired report in the ArchivesSpace sandbox, we got the following message:<o:p></o:p></p></div></div><p class=MsoNormal style='line-height:13.8pt;background:white'> <o:p></o:p></p><div><div><p class=MsoNormal style='line-height:13.8pt;background:white'>Internal Server Error (500)<o:p></o:p></p></div></div><div><div><p class=MsoNormal style='line-height:13.8pt;background:white'>Request Method: GET<o:p></o:p></p></div></div><div><div><p class=MsoNormal style='line-height:13.8pt;background:white'>Request URL: <a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__localhost-3A8089_repositories_4_reports_accessionsacquiredreport-3Flock-5Fversion-3D-26format-3Dxlsx&d=AwMGaQ&c=2X_btuPRWkGwRX26NHIotw&r=FD0Xci-wh01Dc1yt0aSp4ADMuu-zB2G2dpCCNNXfih0&m=fW2PblqG-EuWe_NmccDnQngjowe_utp-8LnFzzlbwaU&s=QLVRITSkiwZ5mUuNKW9IXhybdcp_1VY7kG4axjN1YpI&e=" target="_blank"><span style='color:purple'>http://localhost:8089/repositories/4/reports/accessionsacquiredreport?lock_version=&format=xlsx</span></a><o:p></o:p></p></div></div><p class=MsoNormal style='line-height:13.8pt;background:white'> <o:p></o:p></p><div><div><p class=MsoNormal style='line-height:13.8pt;background:white'>(TypeError) can't convert nil into String<o:p></o:p></p></div></div><p class=MsoNormal style='line-height:13.8pt;background:white'> <o:p></o:p></p><div><div><p class=MsoNormal style='line-height:13.8pt;background:white'>You're seeing this error because you use JRuby::Rack::ErrorApp::ShowStatus.<o:p></o:p></p></div></div><p class=MsoNormal style='line-height:13.8pt;background:white'> <o:p></o:p></p><div><div><p class=MsoNormal style='line-height:13.8pt;background:white'>Another example:<o:p></o:p></p></div></div><div><div><p class=MsoNormal style='line-height:13.8pt;background:white'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'><image012.jpg></span><o:p></o:p></p></div></div><ul style='margin-top:0in' type=disc><li class=MsoNormal style='line-height:13.8pt;mso-list:l8 level1 lfo9;background:white'><span style='font-family:"Calibri","sans-serif"'>We were unable to generate any successful Resource reports. All attempts to download reports in any format resulted in “Waiting for (server)” messages with no results.</span><o:p></o:p></li></ul><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><div><div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Robin McElheny</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Associate University Archivist for Collections and Public Services</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Harvard University Archives</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Pusey Library</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Cambridge, MA 02138</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Email: <a href="mailto:robin_mcelheny@harvard.edu" target="_blank"><span style='color:purple'>robin_mcelheny@harvard.edu</span></a></span><o:p></o:p></p></div></div><div><div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Phone:<span class=apple-converted-space> </span><a href="tel:617-495-2461" target="_blank"><span style='color:purple'>617-495-2461</span></a></span><o:p></o:p></p></div></div><div><div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Fax:<span class=apple-converted-space> </span><a href="tel:617-495-8011" target="_blank"><span style='color:purple'>617-495-8011</span></a></span><o:p></o:p></p></div></div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p></div></div></div></div></div></div></div></div></div></div><div><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Helvetica","sans-serif"'>_______________________________________________<br>Archivesspace_Users_Group mailing list<br><a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank"><span style='color:purple'>Archivesspace_Users_Group@lyralists.lyrasis.org</span></a><br><a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__lyralists.lyrasis.org_mailman_listinfo_archivesspace-5Fusers-5Fgroup&d=AwMGaQ&c=2X_btuPRWkGwRX26NHIotw&r=FD0Xci-wh01Dc1yt0aSp4ADMuu-zB2G2dpCCNNXfih0&m=fW2PblqG-EuWe_NmccDnQngjowe_utp-8LnFzzlbwaU&s=UKQoV4YFnThAz6ota9QAIQcE7acnwRZOAFv-CYNYT00&e=" target="_blank"><span style='color:purple'>http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</span></a></span><o:p></o:p></p></div></div></blockquote></div><p class=MsoNormal> <o:p></o:p></p></div></div></div></div></div><p class=MsoNormal style='margin-bottom:12.0pt'><br>_______________________________________________<br>Archivesspace_Users_Group mailing list<br><a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank"><span style='color:purple'>Archivesspace_Users_Group@lyralists.lyrasis.org</span></a><br><a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__lyralists.lyrasis.org_mailman_listinfo_archivesspace-5Fusers-5Fgroup&d=AwMGaQ&c=2X_btuPRWkGwRX26NHIotw&r=FD0Xci-wh01Dc1yt0aSp4ADMuu-zB2G2dpCCNNXfih0&m=fW2PblqG-EuWe_NmccDnQngjowe_utp-8LnFzzlbwaU&s=UKQoV4YFnThAz6ota9QAIQcE7acnwRZOAFv-CYNYT00&e=" target="_blank"><span style='color:purple'>http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</span></a><o:p></o:p></p></div><div><p class=MsoNormal><br><br clear=all><br>--<span class=apple-converted-space> </span><o:p></o:p></p></div><div><div><p class=MsoNormal>Nathan Stevens<br>Programmer/Analyst<br>Digital Library Technology Services<br>New York University<br><br>1212-998-2653<br><a href="mailto:ns96@nyu.edu" target="_blank"><span style='color:purple'>ns96@nyu.edu</span></a><o:p></o:p></p></div></div></div></div></div></div></div></div></div></div><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Helvetica","sans-serif"'>_______________________________________________<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="https://urldefense.proofpoint.com/v2/url?u=http-3A__lyralists.lyrasis.org_mailman_listinfo_archivesspace-5Fusers-5Fgroup&d=AwMF-g&c=2X_btuPRWkGwRX26NHIotw&r=FD0Xci-wh01Dc1yt0aSp4ADMuu-zB2G2dpCCNNXfih0&m=m4k_eKATRBkkyELfLCrqHTHMjbgOiSmlN0YmAReLKiQ&s=51LSe_Vcf1uCLVXSMRiGrR4DlqfsMUZAUFSH0fTLhYE&e=" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a></span><o:p></o:p></p></div></blockquote></div><p class=MsoNormal><o:p> </o:p></p></div></div></div></div></div></div></div><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Helvetica","sans-serif"'>_______________________________________________<br>Archivesspace_Users_Group mailing list<br></span><a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org"><span style='font-size:9.0pt;font-family:"Helvetica","sans-serif"'>Archivesspace_Users_Group@lyralists.lyrasis.org</span></a><span style='font-size:9.0pt;font-family:"Helvetica","sans-serif"'><br></span><a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group"><span style='font-size:9.0pt;font-family:"Helvetica","sans-serif"'>http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</span></a><o:p></o:p></p></div></blockquote></div><p class=MsoNormal><o:p> </o:p></p></div></div></body></html>