[Archivesspace_Users_Group] Problems with ASpace reports
Nathan Stevens
ns96 at nyu.edu
Fri Aug 14 08:27:37 EDT 2015
Hi,
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?
On Fri, Aug 14, 2015 at 3:31 AM, Emma Jolley <EJOLLEY at nla.gov.au> wrote:
> 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?
>
>
>
> Many thanks
>
>
>
> Emma
>
> ****
>
>
>
> The log entry when running (as an example) the report mentioned in the
> email below is:
>
>
>
> D, [2015-08-10T17:58:14.599000 #3236] DEBUG -- : Thread-10076116: GET
> /repositories/2/reports/accessionsunprocessedreport?lock_version=&format=json
> [session: nil]
>
> D, [2015-08-10T17:58:14.602000 #3236] DEBUG -- : Thread-10076116:
> Post-processed params: {:format=>"json", :repo_id=>2}
>
> 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
>
> Rendered shared/_breadcrumb.html.erb (1.0ms)
>
> Rendered
> /opt/archivesspace-1.3.0/archivesspace/plugins/nla_accession_reports/frontend/views/reports/index.html.erb
> within layouts/application (82.0ms)
>
> Rendered shared/_browser_support.html.erb (0.0ms)
>
> Rendered shared/_header_user.html.erb (6.0ms)
>
> Rendered shared/_header_global.html.erb (6.0ms)
>
> Rendered site/_branding.html.erb (0.0ms)
>
> Rendered shared/_advanced_search.html.erb (5.0ms)
>
> Rendered shared/_header_repository.html.erb (18.0ms)
>
> Rendered site/_footer.html.erb (0.0ms)
>
> Rendered shared/_templates.html.erb (2.0ms)
>
> Completed 200 OK in 448.0ms (Views: 114.0ms)
>
>
>
> Which is not helpful as it essentially just says exactly what gets
> displayed on the interface.
>
>
>
> net.sf.jasperreports.engine.JRException: Error executing SQL statement for
> : accessionsUnprocessed
>
>
>
> I’ve run the query in this report directly against the database
> successfully (cut and paste from
> reports/Accessions/AccessionsUnprocessedReport/AccessionsUnprocessedReport.jrxml and
> substituting in the repo id) so I think the SQL itself is sound.
>
>
>
> Further info:
>
>
>
> The report config being used are:
>
> #AppConfig[:report_page_layout] = "letter landscape"
>
> AppConfig[:enable_jasper] = true
>
> AppConfig[:compile_jasper] = true
>
> I’ve tried with the report_page_layout both commented and uncommented.
>
>
>
> The java version is:
>
> java version "1.7.0_85"
>
> OpenJDK Runtime Environment (rhel-2.6.1.3.el6_7-x86_64 u85-b01)
>
> OpenJDK 64-Bit Server VM (build 24.85-b03, mixed mode)
>
>
>
> Could there be an issue with using the OpenJDK rather than Oracle’s JDK
> perhaps ?
>
>
>
>
>
>
>
> *From:* archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] *On Behalf Of *Brian
> Hoffman
> *Sent:* Friday, 14 August 2015 12:37 PM
> *To:* Archivesspace Users Group
>
> *Subject:* Re: [Archivesspace_Users_Group] Problems with ASpace reports
>
>
>
> 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:
>
>
>
> https://github.com/archivesspace/archivesspace/pull/244
>
>
>
> Brian
>
>
>
>
>
>
>
> On Aug 7, 2015, at 5:49 AM, Chris Fitzpatrick <
> Chris.Fitzpatrick at lyrasis.org> wrote:
>
>
>
>
>
> Hi Emma,
>
>
>
> Can you look at what's being output into the log?
>
>
>
> The easiest way to see what the report is doing is to look at the Jasper
> XML, which you can see here =>
> https://github.com/archivesspace/archivesspace/blob/master/reports/Accessions/AccessionsUnprocessedReport/AccessionsUnprocessedReport.jrxml#L20-L37
>
>
>
> 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.
>
>
>
> b,chris.
>
>
>
> Chris Fitzpatrick | Developer, ArchivesSpace
> Skype: chrisfitzpat | Phone: 918.236.6048
> http://archivesspace.org/
>
>
> ------------------------------
>
> *From:* archivesspace_users_group-bounces at lyralists.lyrasis.org <
> archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of
> Emma Jolley <EJOLLEY at nla.gov.au>
> *Sent:* Friday, August 7, 2015 7:13 AM
> *To:* Archivesspace Users Group (
> archivesspace_users_group at lyralists.lyrasis.org)
> *Subject:* Re: [Archivesspace_Users_Group] Problems with ASpace reports
>
>
>
> Hi Chris
>
>
>
> 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?
>
>
>
> 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?
>
>
>
> Many thanks
>
>
>
> Emma
>
>
>
> <image007.png>
>
>
>
>
>
> *From:* archivesspace_users_group-bounces at lyralists.lyrasis.org [
> mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org
> <archivesspace_users_group-bounces at lyralists.lyrasis.org>] *On Behalf Of *Chris
> Fitzpatrick
> *Sent:* Thursday, 6 August 2015 9:16 PM
> *To:* Archivesspace Users Group
> *Cc:* Zalduendo, Ines; Wendler, Robin King; Della Monica, Ilaria
> *Subject:* Re: [Archivesspace_Users_Group] Problems with ASpace reports
>
>
>
>
>
>
>
> Hi Robin,
>
>
>
> So, first you need to make sure you compiled your jasper reports on
> startup. To do this, edit the config.rb file to have:
>
> AppConfig[:compile_jasper] = true
>
>
>
> and restart ASpace.
>
>
>
>
>
> This will compile the jasper jxml files ( which is most likely what's
> causing the "can't convert nil to String" errors)
>
>
>
> 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.
>
>
>
> 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 Jasper studio
> <http://community.jaspersoft.com/project/jaspersoft-studio>. Just be sure
> to recompile your reports.
>
>
>
> For the parameters, yes this feature is going to be included in a future
> release. I believe those labels are artifacts from AT.
>
>
>
> best, Chris.
>
>
>
>
>
> Chris Fitzpatrick | Developer, ArchivesSpace
> Skype: chrisfitzpat | Phone: 918.236.6048
> http://archivesspace.org/
>
>
> ------------------------------
>
> *From:*archivesspace_users_group-bounces at lyralists.lyrasis.org <
> archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of
> McElheny, Robin G. <robin_mcelheny at harvard.edu>
> *Sent:* Wednesday, August 5, 2015 5:55 PM
> *To:* Archivesspace Users Group
> *Cc:* Zalduendo, Ines; Wendler, Robin King; Della Monica, Ilaria
> *Subject:* [Archivesspace_Users_Group] Problems with ASpace reports
>
>
>
> 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.
>
> 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?
>
> Record selection issues:
>
> - The Accessions Acquired and Accessions Production reports supposedly
> allow for specified time periods, but no date parameters show up in the
> report user interface.
>
> <image008.jpg>
>
>
>
> - 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?
>
>
>
> Report format issues:
>
> - 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.
>
>
>
> - 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"
>
>
>
> - 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:
>
>
>
> 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,,,,:").
>
>
>
> Here is a screen shot:
>
> <image009.jpg>
>
> - Here’s another example:
>
> <image010.jpg>
>
> - In the case of an HTML report, it displays page footers – odd for
> online display.
>
> <image011.jpg>
>
>
>
> Report failure/timeout:
>
> - We encountered many failures.
>
> Example:
>
> When we attempted to download an XLSX AccessionsAcquired report in the
> ArchivesSpace sandbox, we got the following message:
>
>
>
> Internal Server Error (500)
>
> Request Method: GET
>
> Request URL:
> http://localhost:8089/repositories/4/reports/accessionsacquiredreport?lock_version=&format=xlsx
>
>
>
> (TypeError) can't convert nil into String
>
>
>
> You're seeing this error because you use JRuby::Rack::ErrorApp::ShowStatus.
>
>
>
> Another example:
>
> <image012.jpg>
>
> - 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.
>
>
>
>
>
> Robin McElheny
>
> Associate University Archivist for Collections and Public Services
>
> Harvard University Archives
>
> Pusey Library
>
> Cambridge, MA 02138
>
> Email: robin_mcelheny at harvard.edu
>
> Phone: 617-495-2461
>
> Fax: 617-495-8011
>
>
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>
>
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>
>
--
Nathan Stevens
Programmer/Analyst
Digital Library Technology Services
New York University
1212-998-2653
ns96 at nyu.edu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150814/68c8a967/attachment.html>
More information about the Archivesspace_Users_Group
mailing list