[Archivesspace_Users_Group] Keep getting Failed status on generating reports

[Mang Sun]

Make sure you have AS created User Defined functions (about 63 
functions) present  in the underlying MYSQL by running "show function 
status" under MySQL prompt.

Mang Sun
Rice U.

On 4/25/2017 2:17 PM, Daniel L Thacker wrote:
>
> I keep on getting a failed status on any kind of report I run.  I've 
> tried generating all the different types of reports you can export and 
> our different repositories.  One repository are records we hand typed 
> in the other is a repository we successful migrated into.   This 
> particular report was for accessions record reports.  Here is the log: 
>  Thank you.
>
>
>
> Generating report
> Error executing SQL statement for : accessionsRecord
> 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:498)
> RUBY.fill(/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/reports/jdbc_report.rb:22)
> Sequel::ThreadedConnectionPool.hold(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:98)
> Sequel::ThreadedConnectionPool.hold(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:98)
> Sequel::ThreadedConnectionPool.hold(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:87)
> Sequel::ThreadedConnectionPool.hold(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:87)
> RUBY.fill(/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/reports/jdbc_report.rb:21)
> DB.open(/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:143)
> DB.open(/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:143)
> org.jruby.RubyFixnum.times(org/jruby/RubyFixnum.java:280)
> DB.open(/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:131)
> DB.open(/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:131)
> DB.open(/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:127)
> DB.open(/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:127)
> RUBY.fill(/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/reports/jdbc_report.rb:20)
> RUBY.render(/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/reports/jdbc_report.rb:75)
> RUBY.generate(/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/reports/report_response.rb:25)
> RUBY.run(/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/reports_runner.rb:43)
> BackgroundJobQueue.run_pending_job(/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/background_job_queue.rb:113)
> BackgroundJobQueue.run_pending_job(/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/background_job_queue.rb:113)
> RUBY.start_background_thread(/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/background_job_queue.rb:153)
> java.lang.Thread.run(java/lang/Thread.java:745)
> Done.
>
>
> Daniel Thacker
>
> Digital Archivist
>
> James C. Jernigan Library
>
> Texas A&M University-Kingsville
>
> MSC 197
>
> 700 University Blvd
>
> Kingsville, TX  78363-8202
>
> 361-593-4154
>
>
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> 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/20170425/a43b9a1a/attachment.html>