[Archivesspace_Users_Group] Jasper Reports in 1.4.2

Suda, Phillip J psuda1 at tulane.edu
Thu Feb 25 16:25:04 EST 2016


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.

Thanks,

Phil

From: archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of Suda, Phillip J
Sent: Thursday, February 25, 2016 3:16 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] Jasper Reports in 1.4.2

The query gives an error: Function aspace.GetAccessioinContainerSummary does not exist.

From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of Suda, Phillip J
Sent: Thursday, February 25, 2016 3:10 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at lyralists.lyrasis.org>>
Subject: Re: [Archivesspace_Users_Group] Jasper Reports in 1.4.2

Ok, so test in mysql session and then alter the jasper report so that it works in the ASpace staff interface?

Do I still need to run the stored procedure sql scripts or are those baked in?

Thanks Chris, I appreciate it.

Thanks,

Phil


Phillip Suda
Systems Librarian
Howard-Tilton Memorial Library
Tulane University
psuda1 at tulane.edu<mailto:psuda1 at tulane.edu>
504-865-5607

From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of Chris Fitzpatrick
Sent: Thursday, February 25, 2016 3:07 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at lyralists.lyrasis.org>>
Subject: Re: [Archivesspace_Users_Group] Jasper Reports in 1.4.2




Hi,



Yeah, reports can be written with Sequel ( the ORM the backend uses ) or Jasper ( with something like Jasper studio ).



You can pull out the SQL in the Jasper report and see

In a MySQL session, can you try :



SELECT
     accession.`id` AS accessionId,
     accession.`repo_id` AS repo_id,
     accession.`identifier` AS accessionNumber,
     accession.`title` AS title,
     accession.`accession_date` AS accessionDate,
     GetAccessionContainerSummary(accession.`id`) AS containerSummary,
     GetAccessionProcessed(accession.`id`) AS accessionProcessed,
     GetAccessionProcessedDate(accession.`id`) AS accessionProcessedDate,
     GetAccessionCataloged(accession.`id`) AS cataloged,
     GetAccessionExtent(accession.`id`) AS extentNumber,
     GetAccessionExtentType(accession.`id`) AS extentType,
     GetAccessionRightsTransferred(accession.`id`) AS rightsTransferred
FROM
     `accession` accession
WHERE
     (accession.`repo_id` = 2 );



( ^^^ that's the SQL the AccessionAquired report. There might be an issue with on of the stored procedures...does the query give an error? )



b,chris.






Chris Fitzpatrick | Developer, ArchivesSpace
Skype: chrisfitzpat  | Phone: 918.236.6048
http://archivesspace.org/

________________________________
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<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org>> on behalf of Suda, Phillip J <psuda1 at tulane.edu<mailto:psuda1 at tulane.edu>>
Sent: Thursday, February 25, 2016 9:59 PM
To: Archivesspace Users Group
Subject: Re: [Archivesspace_Users_Group] Jasper Reports in 1.4.2


MySQL.



Sorry if I misunderstood your last email. Will there be another non-jasper option in the next release?



From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of Chris Fitzpatrick
Sent: Thursday, February 25, 2016 2:57 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at lyralists.lyrasis.org>>
Subject: Re: [Archivesspace_Users_Group] Jasper Reports in 1.4.2



Hi,



Yeah, Jasper is a rather complicated...are you using a MySQL or Derby?



b,chris.



Chris Fitzpatrick | Developer, ArchivesSpace
Skype: chrisfitzpat  | Phone: 918.236.6048
http://archivesspace.org/
[http://www.archivesspace.org/sites/default/files/ArchivesSpace%20Logo5.png]<http://archivesspace.org/>

ArchivesSpace a community building an open-source web ...<http://archivesspace.org/>
archivesspace.org
Built for archives by archivists, ArchivesSpace is the open source archives information management application for managing and providing web access to archives ...




________________________________

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<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org>> on behalf of Suda, Phillip J <psuda1 at tulane.edu<mailto:psuda1 at tulane.edu>>
Sent: Thursday, February 25, 2016 9:32 PM
To: Archivesspace Users Group
Subject: Re: [Archivesspace_Users_Group] Jasper Reports in 1.4.2



Running 1.4.2 on a Mac with this in the reports stanza:



# Jasper Reports

# (https://community.jaspersoft.com/project/jasperreports-library)

# require compilation. This can be done at startup. Please note, if you are

# using Java 8 and you want to compile at startup, keep this setting at false,

# but be sure to use the JDK version.

AppConfig[:enable_jasper] = true

AppConfig[:compile_jasper] = true



Here is an error I am getting:



AccessionsAcquiredReport - net.sf.jasperreports.engine.JRException: Error executing SQL statement for : accessionsAcquired

message - Error executing SQL statement for : accessionsAcquired

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)





From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org> [mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of Chris Fitzpatrick
Sent: Thursday, February 25, 2016 8:41 AM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at lyralists.lyrasis.org>>
Subject: Re: [Archivesspace_Users_Group] Jasper Reports in 1.4.2



Hi,



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.



You can see the folder here:

https://github.com/archivesspace/archivesspace/tree/v1.2.0/reports/static



But I'll add these back as well for the next release.

b,chris.





Chris Fitzpatrick | Developer, ArchivesSpace
Skype: chrisfitzpat  | Phone: 918.236.6048
http://archivesspace.org/



________________________________

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<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org>> on behalf of Majewski, Steven Dennis (sdm7g) <sdm7g at eservices.virginia.edu<mailto:sdm7g at eservices.virginia.edu>>
Sent: Wednesday, February 24, 2016 11:50 PM
To: Archivesspace Users Group
Subject: Re: [Archivesspace_Users_Group] Jasper Reports in 1.4.2





Most of the reports work for me in 1.4.2. on Mac but some of them, like RepositoryReport,  always fail.



I did not seem to have to do any font installation on Mac as I did on Linux, but maybe there

are some remaining font issues on Mac as well, since the failing stacktrace is in in ITextFontResolver.java







RepositoryReport - java.lang.NullPointerException

message -

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)







NamesListReport and ResourcesListReport though, for two examples, work without errors.







- Steve M.







On Feb 24, 2016, at 5:24 PM, Suda, Phillip J <psuda1 at TULANE.EDU<mailto:psuda1 at TULANE.EDU>> wrote:



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?



Thanks,



Phil



Phillip Suda

Systems Librarian

Howard-Tilton Memorial Library

Tulane University

psuda1 at tulane.edu<mailto:psuda1 at tulane.edu>

504-865-5607



_______________________________________________
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group at lyralists.lyrasis.org<mailto:Archivesspace_Users_Group at lyralists.lyrasis.org>
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20160225/f8ca50af/attachment.html>


More information about the Archivesspace_Users_Group mailing list