[Archivesspace_Users_Group] Keep getting Failed status on generating reports

Thu Apr 27 11:10:27 EDT 2017

Daniel,
What do you find with the said SQL command ?

Mang
On 4/26/2017 10:37 AM, Daniel L Thacker wrote:
>
> Hi Christine,
>
>
> We are running v1.5.4.  I also got some advice to do:
>
>
> "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."
>
>
> So right now, I am heading over to our IT guys and see if they can 
> "show function status" under MYSQL.  Would you agree with this 
> assessment?
>
>
> Thank you,
>
>
> 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
>
> ------------------------------------------------------------------------
> *From:* archivesspace_users_group-bounces at lyralists.lyrasis.org 
> <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of 
> Christine Di Bella <christine.dibella at lyrasis.org>
> *Sent:* Wednesday, April 26, 2017 10:18:09 AM
> *To:* Archivesspace Users Group
> *Subject:* Re: [Archivesspace_Users_Group] Keep getting Failed status 
> on generating reports
>
> Dear Daniel,
>
> What version of ArchivesSpace are you running? There are some 
> differences between different versions for what you need to do to run 
> reports, and also which reports run successfully.
>
> Christine
>
> Christine Di Bella
>
> ArchivesSpace Program Manager
>
> christine.dibella at lyrasis.org <mailto:christine.dibella at lyrasis.org>
>
> 800.999.8558 x2905
>
> 678-235-2905
>
> cdibella13 (Skype)
>
> ASpaceOrgHomeMedium
>
> *From:*archivesspace_users_group-bounces at lyralists.lyrasis.org 
> [mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org] *On 
> Behalf Of *Daniel L Thacker
> *Sent:* Tuesday, April 25, 2017 3:17 PM
> *To:* archivesspace_users_group at lyralists.lyrasis.org
> *Subject:* [Archivesspace_Users_Group] Keep getting Failed status on 
> generating reports
>
> 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/20170427/7e670e5c/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 4144 bytes
Desc: not available
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20170427/7e670e5c/attachment.jpe>