<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 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";
panose-1:2 11 5 2 4 2 4 2 2 3;}
@font-face
{font-family:"Segoe UI Light";
panose-1:2 11 5 2 4 2 4 2 2 3;}
@font-face
{font-family:Menlo-Regular;
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* 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;}
p
{mso-style-priority:99;
margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle20
{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;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">I ran the sql/sp.sql scripts from the ASpace-Reports github repo and I didn’t receive errors in my test environment. Going to restart and see what’s what.
<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>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Thanks,
<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>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Phil
<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>
<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",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> archivesspace_users_group-bounces@lyralists.lyrasis.org [mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org]
<b>On Behalf Of </b>Suda, Phillip J<br>
<b>Sent:</b> Thursday, February 25, 2016 3:16 PM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Jasper Reports in 1.4.2<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">The query gives an error: Function aspace.GetAccessioinContainerSummary does not exist.
<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>
<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",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">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> [<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org</a>]
<b>On Behalf Of </b>Suda, Phillip J<br>
<b>Sent:</b> Thursday, February 25, 2016 3:10 PM<br>
<b>To:</b> Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Jasper Reports in 1.4.2<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Ok, so test in mysql session and then alter the jasper report so that it works in the ASpace staff interface?
<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>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Do I still need to run the stored procedure sql scripts or are those baked in?
<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>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Thanks Chris, I appreciate it.
<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>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Thanks, <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>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Phil
<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>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Phillip Suda<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Systems Librarian<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Howard-Tilton Memorial Library<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Tulane University<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><a href="mailto:psuda1@tulane.edu">psuda1@tulane.edu</a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">504-865-5607<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>
<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",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">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> [<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org</a>]
<b>On Behalf Of </b>Chris Fitzpatrick<br>
<b>Sent:</b> Thursday, February 25, 2016 3:07 PM<br>
<b>To:</b> Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Jasper Reports in 1.4.2<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div id="divtagdefaultwrapper">
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">Hi,<o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">Yeah, reports can be written with Sequel ( the ORM the backend uses ) or Jasper ( with something like Jasper studio ).
<o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">You can pull out the SQL in the Jasper report and see<o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">In a MySQL session, can you try :<o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">SELECT<br>
accession.`id` AS accessionId,<br>
accession.`repo_id` AS repo_id,<br>
accession.`identifier` AS accessionNumber,<br>
accession.`title` AS title,<br>
accession.`accession_date` AS accessionDate,<br>
GetAccessionContainerSummary(accession.`id`) AS containerSummary,<br>
GetAccessionProcessed(accession.`id`) AS accessionProcessed,<br>
GetAccessionProcessedDate(accession.`id`) AS accessionProcessedDate,<br>
GetAccessionCataloged(accession.`id`) AS cataloged,<br>
GetAccessionExtent(accession.`id`) AS extentNumber,<br>
GetAccessionExtentType(accession.`id`) AS extentType,<br>
GetAccessionRightsTransferred(accession.`id`) AS rightsTransferred<br>
FROM<br>
`accession` accession<br>
WHERE<br>
(accession.`repo_id` = 2 ); <o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">( ^^^ that's the SQL the AccessionAquired report. There might be an issue with on of the stored procedures...does the query give an error? )
<o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">b,chris.
<o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
<div id="Signature">
<div name="divtagdefaultwrapper">
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt;font-family:"Calibri",sans-serif;color:black">Chris Fitzpatrick | Developer, ArchivesSpace<br>
Skype: chrisfitzpat | Phone: 918.236.6048<br>
<a href="http://archivesspace.org/">http://archivesspace.org/</a><o:p></o:p></span></p>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt;background:white"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
<div>
<div class="MsoNormal" align="center" style="text-align:center;background:white">
<span style="font-family:"Calibri",sans-serif;color:black">
<hr size="2" width="98%" align="center">
</span></div>
<div id="divRplyFwdMsg">
<p class="MsoNormal" style="background:white"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">
<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>>
on behalf of Suda, Phillip J <<a href="mailto:psuda1@tulane.edu">psuda1@tulane.edu</a>><br>
<b>Sent:</b> Thursday, February 25, 2016 9:59 PM<br>
<b>To:</b> Archivesspace Users Group<br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Jasper Reports in 1.4.2</span><span style="font-family:"Calibri",sans-serif;color:black">
<o:p></o:p></span></p>
<div>
<p class="MsoNormal" style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> <o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">MySQL.
</span><span style="color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Sorry if I misunderstood your last email. Will there be another non-jasper option in the next release?
</span><span style="color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p style="background:white"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">
<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> [<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org</a>]
<b>On Behalf Of </b>Chris Fitzpatrick<br>
<b>Sent:</b> Thursday, February 25, 2016 2:57 PM<br>
<b>To:</b> Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Jasper Reports in 1.4.2</span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
<p style="background:white"><span style="color:black"> <o:p></o:p></span></p>
<div id="divtagdefaultwrapper">
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">Hi,<o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> <o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">Yeah, Jasper is a rather complicated...are you using a MySQL or Derby?
<o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> <o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">b,chris.
<o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> <o:p></o:p></span></p>
<div id="Signature">
<div name="divtagdefaultwrapper">
<div>
<div>
<p style="background:white"><span style="font-size:10.0pt;font-family:"Calibri",sans-serif;color:black">Chris Fitzpatrick | Developer, ArchivesSpace<br>
Skype: chrisfitzpat | Phone: 918.236.6048<br>
<a href="http://archivesspace.org/" id="LPlnk64088">http://archivesspace.org/</a></span><span style="color:black"><o:p></o:p></span></p>
<div style="margin-bottom:15.0pt;overflow:auto" id="LPBorder_GT_14564341339920.47866585334820777">
<table class="MsoNormalTable" border="1" cellspacing="0" cellpadding="0" width="90%" style="width:90.0%;background:white;border-top:dotted #C8C8C8 1.0pt;border-left:none;border-bottom:dotted #C8C8C8 1.0pt;border-right:none">
<tbody>
<tr>
<td width="250" valign="top" style="width:187.5pt;border:none;padding:15.0pt 15.0pt 15.0pt .75pt">
<div style="margin-top:5.0pt;margin-bottom:5.0pt;display:table" id="LPImageContainer_14564341339870.8400303961166288">
<p class="MsoNormal" style="margin-top:15.0pt;background:white"><a href="http://archivesspace.org/" target="_blank"><span style="text-decoration:none"><img border="0" width="250" height="74" id="_x0000_i1026" src="http://www.archivesspace.org/sites/default/files/ArchivesSpace%20Logo5.png"></span></a><o:p></o:p></p>
</div>
</td>
<td valign="top" style="border:none;padding:0in 0in 0in 0in;display:table-cell" id="TextCell_14564341339890.46778602586096873">
<div id="LPTitle_14564341339890.14248151824452904">
<p class="MsoNormal" style="margin-top:15.0pt;mso-line-height-alt:15.75pt"><span style="font-size:16.0pt;font-family:"Segoe UI Light",sans-serif;color:#0078D7"><a href="http://archivesspace.org/" target="_blank"><span style="text-decoration:none">ArchivesSpace
a community building an open-source web ...</span></a><o:p></o:p></span></p>
</div>
<div style="margin-top:7.5pt;margin-bottom:12.0pt" id="LPMetadata_14564341339910.6474438791997014">
<p class="MsoNormal" style="margin-top:15.0pt;line-height:10.5pt"><span style="font-size:10.5pt;font-family:"Segoe UI",sans-serif;color:#666666">archivesspace.org<o:p></o:p></span></p>
</div>
<div id="LPDescription_14564341339910.7440041151642479">
<p class="MsoNormal" style="margin-top:15.0pt;line-height:15.0pt"><span style="font-size:10.5pt;font-family:"Segoe UI",sans-serif;color:#666666">Built for archives by archivists, ArchivesSpace is the open source archives information management application for
managing and providing web access to archives ...<o:p></o:p></span></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
<p style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-family:"Calibri",sans-serif;color:black"> </span><span style="color:black"><o:p></o:p></span></p>
<div>
<div class="MsoNormal" align="center" style="text-align:center;background:white">
<span style="font-family:"Calibri",sans-serif;color:black">
<hr size="2" width="98%" align="center">
</span></div>
<div id="divRplyFwdMsg">
<p style="background:white"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">
<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>>
on behalf of Suda, Phillip J <<a href="mailto:psuda1@tulane.edu">psuda1@tulane.edu</a>><br>
<b>Sent:</b> Thursday, February 25, 2016 9:32 PM<br>
<b>To:</b> Archivesspace Users Group<br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Jasper Reports in 1.4.2</span><span style="font-family:"Calibri",sans-serif;color:black">
</span><span style="color:black"><o:p></o:p></span></p>
<div>
<p style="background:white;background-position-x:0%;background-position-y:0%;background-attachment:scroll">
<span style="font-family:"Calibri",sans-serif;color:black"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Running 1.4.2 on a Mac with this in the reports stanza:
</span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"># Jasper Reports</span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"># (<a href="https://community.jaspersoft.com/project/jasperreports-library">https://community.jaspersoft.com/project/jasperreports-library</a>)</span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"># require compilation. This can be done at startup. Please note, if you are</span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"># using Java 8 and you want to compile at startup, keep this setting at false,</span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"># but be sure to use the JDK version.</span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">AppConfig[:enable_jasper] = true</span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">AppConfig[:compile_jasper] = true</span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Here is an error I am getting:</span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
<p style="line-height:15.0pt;background:white"><span style="font-size:10.5pt;font-family:"Helvetica",sans-serif;color:#A94442">AccessionsAcquiredReport - net.sf.jasperreports.engine.JRException: Error executing SQL statement for : accessionsAcquired</span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
<p style="line-height:15.0pt;background:white"><span style="font-size:10.5pt;font-family:"Helvetica",sans-serif;color:#A94442">message - Error executing SQL statement for : accessionsAcquired</span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
<p style="line-height:15.0pt;background:white"><span style="font-size:10.5pt;font-family:"Helvetica",sans-serif;color:#A94442">backtrace - net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(net/sf/jasperreports/engine/query/JRJdbcQueryExecuter.java:240)
net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(net/sf/jasperreports/engine/fill/JRFillDataset.java:1114) net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(net/sf/jasperreports/engine/fill/JRFillDataset.java:691) net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(net/sf/jasperreports/engine/fill/JRBaseFiller.java:1314)
net.sf.jasperreports.engine.fill.JRBaseFiller.fill(net/sf/jasperreports/engine/fill/JRBaseFiller.java:931) net.sf.jasperreports.engine.fill.JRBaseFiller.fill(net/sf/jasperreports/engine/fill/JRBaseFiller.java:873) net.sf.jasperreports.engine.fill.JRFiller.fill(net/sf/jasperreports/engine/fill/JRFiller.java:87)
net.sf.jasperreports.engine.JasperFillManager.fill(net/sf/jasperreports/engine/JasperFillManager.java:287) net.sf.jasperreports.engine.JasperFillManager.fillReport(net/sf/jasperreports/engine/JasperFillManager.java:760) java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:497)
RUBY.fill(/Users/psuda1/ArchivesSpace/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/reports/jdbc_report.rb:22) Sequel::ThreadedConnectionPool.hold(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:85)
Sequel::ThreadedConnectionPool.hold(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:85) RUBY.fill(/Users/psuda1/ArchivesSpace/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/reports/jdbc_report.rb:21)
DB.open(/Users/psuda1/ArchivesSpace/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:131) DB.open(/Users/psuda1/ArchivesSpace/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:131) org.jruby.RubyFixnum.times(org/jruby/RubyFixnum.java:280)
DB.open(/Users/psuda1/ArchivesSpace/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:119) DB.open(/Users/psuda1/ArchivesSpace/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:119) RUBY.fill(/Users/psuda1/ArchivesSpace/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/reports/jdbc_report.rb:20)
RUBY.render(/Users/psuda1/ArchivesSpace/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/reports/jdbc_report.rb:75) RUBY.generate(/Users/psuda1/ArchivesSpace/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/reports/report_response.rb:25)
RUBY.report_response(/Users/psuda1/ArchivesSpace/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/reports/report_helper.rb:39) RUBY.ArchivesSpaceService(/Users/psuda1/ArchivesSpace/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/controllers/reports.rb:17)
org.jruby.RubyBasicObject.instance_eval(org/jruby/RubyBasicObject.java:1574) RESTHelpers::Endpoint.returns(/Users/psuda1/ArchivesSpace/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/rest.rb:241) RESTHelpers::Endpoint.returns(/Users/psuda1/ArchivesSpace/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/rest.rb:241)
DB.open(/Users/psuda1/ArchivesSpace/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:123) DB.open(/Users/psuda1/ArchivesSpace/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:123) DB.transaction(/Users/psuda1/ArchivesSpace/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:99)
DB.transaction(/Users/psuda1/ArchivesSpace/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:99) Sequel::Database._transaction(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:134) Sequel::Database._transaction(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:134)
Sequel::Database._transaction(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:122) Sequel::Database._transaction(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:122)
Sequel::Database.transaction(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:108) Sequel::Database.transaction(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:108)
Sequel::ThreadedConnectionPool.hold(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:98) Sequel::ThreadedConnectionPool.hold(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:98)
Sequel::ThreadedConnectionPool.hold(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:87) Sequel::ThreadedConnectionPool.hold(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:87)
Sequel::Database.synchronize(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255) Sequel::Database.synchronize(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255)
Sequel::Database.transaction(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:97) Sequel::Database.transaction(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:97)
DB.transaction(/Users/psuda1/ArchivesSpace/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:98) DB.transaction(/Users/psuda1/ArchivesSpace/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:98) DB.open(/Users/psuda1/ArchivesSpace/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:122)
DB.open(/Users/psuda1/ArchivesSpace/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:122) org.jruby.RubyFixnum.times(org/jruby/RubyFixnum.java:280) DB.open(/Users/psuda1/ArchivesSpace/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:119)
DB.open(/Users/psuda1/ArchivesSpace/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:119) RESTHelpers::Endpoint.returns(/Users/psuda1/ArchivesSpace/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/rest.rb:223) RESTHelpers::Endpoint.returns(/Users/psuda1/ArchivesSpace/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/rest.rb:223)
RequestContext.open(/Users/psuda1/ArchivesSpace/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/request_context.rb:24) RequestContext.open(/Users/psuda1/ArchivesSpace/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/request_context.rb:24)
RequestContext.open(/Users/psuda1/ArchivesSpace/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/request_context.rb:23) RequestContext.open(/Users/psuda1/ArchivesSpace/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/request_context.rb:23)
RESTHelpers::Endpoint.returns(/Users/psuda1/ArchivesSpace/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/rest.rb:207) RESTHelpers::Endpoint.returns(/Users/psuda1/ArchivesSpace/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/rest.rb:207)
org.jruby.RubyMethod.call(org/jruby/RubyMethod.java:116) Sinatra::Base.compile!(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:1293) Sinatra::Base.compile!(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:1293)
org.jruby.RubyProc.call(org/jruby/RubyProc.java:271) Sinatra::Base.route!(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:860) Sinatra::Base.route!(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:860)
Sinatra::Base.route_eval(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:876) Sinatra::Base.route_eval(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:876) Sinatra::Base.route!(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:860)
Sinatra::Base.route!(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:860) Sinatra::Base.process_route(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:897) Sinatra::Base.process_route(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:897)
org.jruby.RubyKernel.catch(org/jruby/RubyKernel.java:1242) Sinatra::Base.process_route(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:895) Sinatra::Base.process_route(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:895)
Sinatra::Base.route!(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:859) Sinatra::Base.route!(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:859) org.jruby.RubyArray.each(org/jruby/RubyArray.java:1613)
Sinatra::Base.route!(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:858) Sinatra::Base.route!(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:858) Sinatra::Base.dispatch!(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:963)
Sinatra::Base.dispatch!(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:963) Sinatra::Base.invoke(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:946) Sinatra::Base.invoke(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:946)
org.jruby.RubyKernel.catch(org/jruby/RubyKernel.java:1242) Sinatra::Base.invoke(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:946) Sinatra::Base.invoke(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:946)
Sinatra::Base.dispatch!(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:960) Sinatra::Base.dispatch!(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:960) Sinatra::Base.call!(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:794)
Sinatra::Base.call!(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:794) Sinatra::Base.invoke(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:946) Sinatra::Base.invoke(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:946)
org.jruby.RubyKernel.catch(org/jruby/RubyKernel.java:1242) Sinatra::Base.invoke(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:946) Sinatra::Base.invoke(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:946)
Sinatra::Base.call!(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:794) Sinatra::Base.call!(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:794) Sinatra::Base.call(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:780)
Sinatra::Base.call(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:780) ArchivesSpaceService::RequestWrappingMiddleware.call(/Users/psuda1/ArchivesSpace/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/main.rb:277)
ArchivesSpaceService::RequestWrappingMiddleware.call(/Users/psuda1/ArchivesSpace/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/main.rb:277) Rack::Protection::XSSHeader.call(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/rack-protection-1.5.3/lib/rack/protection/xss_header.rb:18)
Rack::Protection::XSSHeader.call(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/rack-protection-1.5.3/lib/rack/protection/xss_header.rb:18) Rack::Protection::PathTraversal.call(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/rack-protection-1.5.3/lib/rack/protection/path_traversal.rb:16)
Rack::Protection::PathTraversal.call(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/rack-protection-1.5.3/lib/rack/protection/path_traversal.rb:16) Rack::Protection::JsonCsrf.call(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/rack-protection-1.5.3/lib/rack/protection/json_csrf.rb:18)
Rack::Protection::JsonCsrf.call(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/rack-protection-1.5.3/lib/rack/protection/json_csrf.rb:18) Rack::Protection::Base.call(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/rack-protection-1.5.3/lib/rack/protection/base.rb:49)
Rack::Protection::Base.call(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/rack-protection-1.5.3/lib/rack/protection/base.rb:49) Rack::Protection::Base.call(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/rack-protection-1.5.3/lib/rack/protection/base.rb:49)
Rack::Protection::Base.call(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/rack-protection-1.5.3/lib/rack/protection/base.rb:49) Rack::Protection::FrameOptions.call(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/rack-protection-1.5.3/lib/rack/protection/frame_options.rb:31)
Rack::Protection::FrameOptions.call(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/rack-protection-1.5.3/lib/rack/protection/frame_options.rb:31) Rack::NullLogger.call(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/rack-1.4.7/lib/rack/nulllogger.rb:9)
Rack::NullLogger.call(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/rack-1.4.7/lib/rack/nulllogger.rb:9) Rack::Head.call(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/rack-1.4.7/lib/rack/head.rb:9) Rack::Head.call(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/rack-1.4.7/lib/rack/head.rb:9)
Sinatra::ExtendedRack.call(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:124) Sinatra::ExtendedRack.call(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:124) Sinatra::Base.call(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:1417)
Sinatra::Base.call(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:1417) Sinatra::Base.synchronize(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:1499) Sinatra::Base.synchronize(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:1499)
Sinatra::Base.call(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:1417) Sinatra::Base.call(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:1417) Rack::Builder.call(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/jruby-rack-1.1.19/lib/jruby-rack-1.1.19.jar!/vendor/rack-1.5.5/rack/builder.rb:138)
Rack::Builder.call(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/jruby-rack-1.1.19/lib/jruby-rack-1.1.19.jar!/vendor/rack-1.5.5/rack/builder.rb:138) Rack::URLMap.call(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/rack-1.4.7/lib/rack/urlmap.rb:64) Rack::URLMap.call(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/rack-1.4.7/lib/rack/urlmap.rb:64)
org.jruby.RubyArray.each(org/jruby/RubyArray.java:1613) Rack::URLMap.call(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/rack-1.4.7/lib/rack/urlmap.rb:49) Rack::URLMap.call(/Users/psuda1/sites/archivesspaceTUL142/gems/gems/rack-1.4.7/lib/rack/urlmap.rb:49)
Rack::Handler::Servlet.call(file:/Users/psuda1/sites/archivesspaceTUL142/gems/gems/jruby-rack-1.1.19/lib/jruby-rack-1.1.19.jar!/rack/handler/servlet.rb:22) Rack::Handler::Servlet.call(file:/Users/psuda1/sites/archivesspaceTUL142/gems/gems/jruby-rack-1.1.19/lib/jruby-rack-1.1.19.jar!/rack/handler/servlet.rb:22)
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(org/eclipse/jetty/servlet/ServletHandler.java:1302) org.eclipse.jetty.servlet.ServletHandler.doHandle(org/eclipse/jetty/servlet/ServletHandler.java:448) org.eclipse.jetty.server.handler.ScopedHandler.handle(org/eclipse/jetty/server/handler/ScopedHandler.java:131)
org.eclipse.jetty.security.SecurityHandler.handle(org/eclipse/jetty/security/SecurityHandler.java:524) org.eclipse.jetty.server.session.SessionHandler.doHandle(org/eclipse/jetty/server/session/SessionHandler.java:231) org.eclipse.jetty.server.handler.ContextHandler.doHandle(org/eclipse/jetty/server/handler/ContextHandler.java:1067)
org.eclipse.jetty.servlet.ServletHandler.doScope(org/eclipse/jetty/servlet/ServletHandler.java:377) org.eclipse.jetty.server.session.SessionHandler.doScope(org/eclipse/jetty/server/session/SessionHandler.java:192) org.eclipse.jetty.server.handler.ContextHandler.doScope(org/eclipse/jetty/server/handler/ContextHandler.java:1001)
org.eclipse.jetty.server.handler.ScopedHandler.handle(org/eclipse/jetty/server/handler/ScopedHandler.java:129) org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(org/eclipse/jetty/server/handler/ContextHandlerCollection.java:250) org.eclipse.jetty.server.handler.HandlerWrapper.handle(org/eclipse/jetty/server/handler/HandlerWrapper.java:111)
org.eclipse.jetty.server.Server.handle(org/eclipse/jetty/server/Server.java:360) org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(org/eclipse/jetty/server/AbstractHttpConnection.java:454) org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(org/eclipse/jetty/server/AbstractHttpConnection.java:890)
org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(org/eclipse/jetty/server/AbstractHttpConnection.java:944) org.eclipse.jetty.http.HttpParser.parseNext(org/eclipse/jetty/http/HttpParser.java:630) org.eclipse.jetty.http.HttpParser.parseAvailable(org/eclipse/jetty/http/HttpParser.java:230)
org.eclipse.jetty.server.AsyncHttpConnection.handle(org/eclipse/jetty/server/AsyncHttpConnection.java:77) org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(org/eclipse/jetty/io/nio/SelectChannelEndPoint.java:622) org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(org/eclipse/jetty/io/nio/SelectChannelEndPoint.java:46)
org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(org/eclipse/jetty/util/thread/QueuedThreadPool.java:603) org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(org/eclipse/jetty/util/thread/QueuedThreadPool.java:538) java.lang.Thread.run(java/lang/Thread.java:745)</span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p style="background:white"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">
<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> [<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org</a>]
<b>On Behalf Of </b>Chris Fitzpatrick<br>
<b>Sent:</b> Thursday, February 25, 2016 8:41 AM<br>
<b>To:</b> Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Jasper Reports in 1.4.2</span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
</div>
</div>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> <o:p></o:p></span></p>
<div id="divtagdefaultwrapper">
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">Hi,<o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> <o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">Yes, the reports/static directory was removed awhile back...and i can't remember why. I think it was because there was an expectation that Jasper would replace all reports
functionality. <o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> <o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">You can see the folder here:<o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><a href="https://github.com/archivesspace/archivesspace/tree/v1.2.0/reports/static" title="Cmd+Click or tap to follow the link" id="LPlnk981436">https://github.com/archivesspace/archivesspace/tree/v1.2.0/reports/static</a><o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> <o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">But I'll add these back as well for the next release.<o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">b,chris.
<o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> <o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> <o:p></o:p></span></p>
<div id="Signature">
<div name="divtagdefaultwrapper">
<div>
<div>
<p style="background:white"><span style="font-size:10.0pt;font-family:"Calibri",sans-serif;color:black">Chris Fitzpatrick | Developer, ArchivesSpace<br>
Skype: chrisfitzpat | Phone: 918.236.6048<br>
<a href="http://archivesspace.org/">http://archivesspace.org/</a></span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
</div>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> <o:p></o:p></span></p>
<div>
<div class="MsoNormal" align="center" style="text-align:center;background:white">
<span style="font-family:"Calibri",sans-serif;color:black">
<hr size="2" width="98%" align="center">
</span></div>
<div id="divRplyFwdMsg">
<p style="background:white"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">
<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>>
on behalf of Majewski, Steven Dennis (sdm7g) <<a href="mailto:sdm7g@eservices.virginia.edu">sdm7g@eservices.virginia.edu</a>><br>
<b>Sent:</b> Wednesday, February 24, 2016 11:50 PM<br>
<b>To:</b> Archivesspace Users Group<br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Jasper Reports in 1.4.2</span><span style="font-family:"Calibri",sans-serif;color:black">
<o:p></o:p></span></p>
<div>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> <o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> <o:p></o:p></span></p>
</div>
<div>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">Most of the reports work for me in 1.4.2. on Mac but some of them, like RepositoryReport, always fail. <o:p></o:p></span></p>
</div>
<div>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> <o:p></o:p></span></p>
</div>
<div>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">I did not seem to have to do any font installation on Mac as I did on Linux, but maybe there <o:p></o:p></span></p>
</div>
<div>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">are some remaining font issues on Mac as well, since the failing stacktrace is in in ITextFontResolver.java <o:p></o:p></span></p>
</div>
<div>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> <o:p></o:p></span></p>
</div>
<div>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> <o:p></o:p></span></p>
</div>
<div>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> <o:p></o:p></span></p>
</div>
<div>
<div>
<p style="background:#F2DEDE"><span style="font-family:"Helvetica",sans-serif;color:#A94442">RepositoryReport - java.lang.NullPointerException</span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
</div>
<div>
<p style="background:#F2DEDE"><span style="font-family:"Helvetica",sans-serif;color:#A94442">message - </span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
</div>
<div>
<p style="background:#F2DEDE"><span style="font-family:"Helvetica",sans-serif;color:#A94442">backtrace - org.xhtmlrenderer.swing.NaiveUserAgent.getBinaryResource(org/xhtmlrenderer/swing/NaiveUserAgent.java:228) org.xhtmlrenderer.pdf.ITextFontResolver.importFontFaces(org/xhtmlrenderer/pdf/ITextFontResolver.java:97)
org.xhtmlrenderer.pdf.ITextRenderer.setDocument(org/xhtmlrenderer/pdf/ITextRenderer.java:178) org.xhtmlrenderer.pdf.ITextRenderer.setDocument(org/xhtmlrenderer/pdf/ITextRenderer.java:142) java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:497) RUBY.render_pdf(/projects/Archivespace/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/reports/pdf_response.rb:46)
RUBY.generate(/projects/Archivespace/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/reports/pdf_response.rb:19) RUBY.generate(/projects/Archivespace/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/reports/report_response.rb:28) </span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
</div>
</div>
<div>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> <o:p></o:p></span></p>
</div>
<div>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> <o:p></o:p></span></p>
</div>
<div>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> <o:p></o:p></span></p>
</div>
<div>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">NamesListReport and ResourcesListReport though, for two examples, work without errors. <o:p></o:p></span></p>
</div>
<div>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> <o:p></o:p></span></p>
</div>
<div>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> <o:p></o:p></span></p>
</div>
<div>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> <o:p></o:p></span></p>
</div>
<div>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">— Steve M.<o:p></o:p></span></p>
</div>
<div>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> <o:p></o:p></span></p>
</div>
<div>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> <o:p></o:p></span></p>
</div>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> <o:p></o:p></span></p>
<div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">On Feb 24, 2016, at 5:24 PM, Suda, Phillip J <<a href="mailto:psuda1@TULANE.EDU">psuda1@TULANE.EDU</a>> wrote:<o:p></o:p></span></p>
</div>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> <o:p></o:p></span></p>
<div>
<div>
<div>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">Is anyone having trouble with reports in ASpace 1.4.2? I have AppConfigs set to true in Reports stanzas. I am running against a MySql database. It looks
like the areports jar file is included with the distribution. I am testing this locally on a Mac. Am I missing something? </span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
</div>
<div>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black"> </span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
</div>
<div>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">Thanks, </span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
</div>
<div>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black"> </span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
</div>
<div>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">Phil </span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
</div>
<div>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black"> </span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
</div>
<div>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">Phillip Suda</span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
</div>
<div>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">Systems Librarian</span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
</div>
<div>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">Howard-Tilton Memorial Library</span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
</div>
<div>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">Tulane University</span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
</div>
<div>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black"><a href="mailto:psuda1@tulane.edu"><span style="color:#954F72">psuda1@tulane.edu</span></a></span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
</div>
<div>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">504-865-5607</span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
</div>
<div>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black"> </span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
</div>
</div>
<p style="background:white"><span style="font-size:10.5pt;font-family:"Menlo-Regular",serif;color:black">_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
</span><span style="font-family:"Calibri",sans-serif;color:black"><a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org"><span style="font-size:10.5pt;font-family:"Menlo-Regular",serif;color:#954F72">Archivesspace_Users_Group@lyralists.lyrasis.org</span></a></span><span style="font-size:10.5pt;font-family:"Menlo-Regular",serif;color:black"><br>
</span><span style="font-family:"Calibri",sans-serif;color:black"><a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group"><span style="font-size:10.5pt;font-family:"Menlo-Regular",serif;color:#954F72">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</span></a><o:p></o:p></span></p>
</div>
</blockquote>
</div>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"> <o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>