Hi Daniel, You still need to have a MySQL backend, not the embedded database, to run reports. This message looks like maybe your test machine isn't using MySQL. Which platform are you on? The basic instructions are available at http://archivesspace.github.io/archivesspace/user/running-archivesspace-against-mysql/ that should get you through a Linux installation and some people in the community have also prepared some really great instructions for Windows, if you need them.
Christine From: [email protected] [mailto:[email protected]] On Behalf Of Daniel L Thacker Sent: Thursday, April 27, 2017 12:08 PM To: Archivesspace Users Group <[email protected]> Subject: Re: [Archivesspace_Users_Group] Keep getting Failed status on generating reports We set up a test machine with V2.0 and followed the Manuel, the software works but still having problems with the reports. This was the failed status log: Follow Log Generating report Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: FUNCTION archivesspace.GetAccessionProcessed does not exist java.lang.reflect.Constructor.newInstance(java/lang/reflect/Constructor.java:423) com.mysql.jdbc.Util.handleNewInstance(com/mysql/jdbc/Util.java:425) com.mysql.jdbc.Util.getInstance(com/mysql/jdbc/Util.java:408) com.mysql.jdbc.SQLError.createSQLException(com/mysql/jdbc/SQLError.java:943) com.mysql.jdbc.MysqlIO.checkErrorPacket(com/mysql/jdbc/MysqlIO.java:3973) com.mysql.jdbc.MysqlIO.checkErrorPacket(com/mysql/jdbc/MysqlIO.java:3909) com.mysql.jdbc.MysqlIO.sendCommand(com/mysql/jdbc/MysqlIO.java:2527) com.mysql.jdbc.MysqlIO.sqlQueryDirect(com/mysql/jdbc/MysqlIO.java:2680) com.mysql.jdbc.ConnectionImpl.execSQL(com/mysql/jdbc/ConnectionImpl.java:2497) com.mysql.jdbc.ConnectionImpl.execSQL(com/mysql/jdbc/ConnectionImpl.java:2455) com.mysql.jdbc.StatementImpl.executeQuery(com/mysql/jdbc/StatementImpl.java:1369) java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:498) org.jruby.javasupport.JavaMethod.invokeDirectWithExceptionHandling(org/jruby/javasupport/JavaMethod.java:453) org.jruby.javasupport.JavaMethod.invokeDirect(org/jruby/javasupport/JavaMethod.java:314) home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.adapters.jdbc.invokeOther1:executeQuery(home/administrator/archivesspace/gems/gems/sequel_minus_4_dot_20_dot_0/lib/sequel/adapters//home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:250)<http://home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.adapters.jdbc.invokeOther1:executeQuery(home/administrator/archivesspace/gems/gems/sequel_minus_4_dot_20_dot_0/lib/sequel/adapters/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:250)> home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.adapters.jdbc.block<http://home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.adapters.jdbc.block> in execute(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:250) home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.database.logging.log_yield(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/logging.rb:33)<http://home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.database.logging.log_yield(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/logging.rb:33)> home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.adapters.jdbc.invokeOther8:log_yield(home/administrator/archivesspace/gems/gems/sequel_minus_4_dot_20_dot_0/lib/sequel/adapters//home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:250)<http://home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.adapters.jdbc.invokeOther8:log_yield(home/administrator/archivesspace/gems/gems/sequel_minus_4_dot_20_dot_0/lib/sequel/adapters/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:250)> home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.adapters.jdbc.block<http://home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.adapters.jdbc.block> in execute(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:250) home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.adapters.jdbc.statement(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:646)<http://home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.adapters.jdbc.statement(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:646)> home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.adapters.jdbc.invokeOther25:statement(home/administrator/archivesspace/gems/gems/sequel_minus_4_dot_20_dot_0/lib/sequel/adapters//home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:245)<http://home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.adapters.jdbc.invokeOther25:statement(home/administrator/archivesspace/gems/gems/sequel_minus_4_dot_20_dot_0/lib/sequel/adapters/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:245)> home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.adapters.jdbc.block<http://home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.adapters.jdbc.block> in execute(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:245) home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.connection_pool.threaded.hold(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:85)<http://home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.connection_pool.threaded.hold(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:85)> home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.database.connecting.invokeOther2:hold(home/administrator/archivesspace/gems/gems/sequel_minus_4_dot_20_dot_0/lib/sequel/database//home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255)<http://home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.database.connecting.invokeOther2:hold(home/administrator/archivesspace/gems/gems/sequel_minus_4_dot_20_dot_0/lib/sequel/database/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255)> home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.database.connecting.synchronize(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255)<http://home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.database.connecting.synchronize(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255)> home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.adapters.jdbc.invokeOther35:synchronize(home/administrator/archivesspace/gems/gems/sequel_minus_4_dot_20_dot_0/lib/sequel/adapters//home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:244)<http://home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.adapters.jdbc.invokeOther35:synchronize(home/administrator/archivesspace/gems/gems/sequel_minus_4_dot_20_dot_0/lib/sequel/adapters/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:244)> home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.adapters.jdbc.execute(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:244)<http://home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.adapters.jdbc.execute(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:244)> home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.dataset.actions.invokeOther7:execute(home/administrator/archivesspace/gems/gems/sequel_minus_4_dot_20_dot_0/lib/sequel/dataset//home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:911)<http://home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.dataset.actions.invokeOther7:execute(home/administrator/archivesspace/gems/gems/sequel_minus_4_dot_20_dot_0/lib/sequel/dataset/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:911)> home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.dataset.actions.execute(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:911)<http://home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.dataset.actions.execute(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:911)> home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.adapters.jdbc.invokeOther2:execute(home/administrator/archivesspace/gems/gems/sequel_minus_4_dot_20_dot_0/lib/sequel/adapters//home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:725)<http://home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.adapters.jdbc.invokeOther2:execute(home/administrator/archivesspace/gems/gems/sequel_minus_4_dot_20_dot_0/lib/sequel/adapters/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:725)> home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.adapters.jdbc.fetch_rows(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:725)<http://home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.adapters.jdbc.fetch_rows(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:725)> home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.dataset.actions.invokeOther7:fetch_rows(home/administrator/archivesspace/gems/gems/sequel_minus_4_dot_20_dot_0/lib/sequel/dataset//home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:139)<http://home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.dataset.actions.invokeOther7:fetch_rows(home/administrator/archivesspace/gems/gems/sequel_minus_4_dot_20_dot_0/lib/sequel/dataset/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:139)> home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.dataset.actions.each(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:139)<http://home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.dataset.actions.each(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:139)> home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.dataset.actions.invokeOther11:each(home/administrator/archivesspace/gems/gems/sequel_minus_4_dot_20_dot_0/lib/sequel/dataset//home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:71)<http://home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.dataset.actions.invokeOther11:each(home/administrator/archivesspace/gems/gems/sequel_minus_4_dot_20_dot_0/lib/sequel/dataset/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:71)> home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.dataset.actions.columns(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:71)<http://home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.dataset.actions.columns(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:71)> RUBY.headers(/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/reports/abstract_report.rb:40) RUBY.each(/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/reports/csv_response.rb:10) RUBY.generate(/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/reports/csv_response.rb:20) 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:27) RUBY.block in run(/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/job_runners/reports_runner.rb:37) home.administrator.archivesspace.data.tmp.jetty_minus_0_dot_0_dot_0_dot_0_minus_8089_minus_backend_dot_war_minus___minus_any_minus_.webapp.WEB_minus_INF.app.model.db.block<http://home.administrator.archivesspace.data.tmp.jetty_minus_0_dot_0_dot_0_dot_0_minus_8089_minus_backend_dot_war_minus___minus_any_minus_.webapp.WEB_minus_INF.app.model.db.block> in open(/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:111) home.administrator.archivesspace.data.tmp.jetty_minus_0_dot_0_dot_0_dot_0_minus_8089_minus_backend_dot_war_minus___minus_any_minus_.webapp.WEB_minus_INF.app.model.db.block<http://home.administrator.archivesspace.data.tmp.jetty_minus_0_dot_0_dot_0_dot_0_minus_8089_minus_backend_dot_war_minus___minus_any_minus_.webapp.WEB_minus_INF.app.model.db.block> in transaction(/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:75) home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.database.transactions._transaction(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:134)<http://home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.database.transactions._transaction(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:134)> home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.database.transactions.invokeOther14:_transaction(home/administrator/archivesspace/gems/gems/sequel_minus_4_dot_20_dot_0/lib/sequel/database//home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:108)<http://home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.database.transactions.invokeOther14:_transaction(home/administrator/archivesspace/gems/gems/sequel_minus_4_dot_20_dot_0/lib/sequel/database/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:108)> home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.database.transactions.block<http://home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.database.transactions.block> in transaction(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:108) home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.connection_pool.threaded.hold(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:98)<http://home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.connection_pool.threaded.hold(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:98)> home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.database.connecting.invokeOther2:hold(home/administrator/archivesspace/gems/gems/sequel_minus_4_dot_20_dot_0/lib/sequel/database//home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255)<http://home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.database.connecting.invokeOther2:hold(home/administrator/archivesspace/gems/gems/sequel_minus_4_dot_20_dot_0/lib/sequel/database/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255)> home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.database.connecting.synchronize(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255)<http://home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.database.connecting.synchronize(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255)> home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.database.transactions.invokeOther35:synchronize(home/administrator/archivesspace/gems/gems/sequel_minus_4_dot_20_dot_0/lib/sequel/database//home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:97)<http://home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.database.transactions.invokeOther35:synchronize(home/administrator/archivesspace/gems/gems/sequel_minus_4_dot_20_dot_0/lib/sequel/database/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:97)> home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.database.transactions.transaction(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:97)<http://home.administrator.archivesspace.gems.gems.sequel_minus_4_dot_20_dot_0.lib.sequel.database.transactions.transaction(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:97)> home.administrator.archivesspace.data.tmp.jetty_minus_0_dot_0_dot_0_dot_0_minus_8089_minus_backend_dot_war_minus___minus_any_minus_.webapp.WEB_minus_INF.app.model.db.invokeOther2:transaction(home/administrator/archivesspace/data/tmp/jetty_minus_0_dot_0_dot_0_dot_0_minus_8089_minus_backend_dot_war_minus___minus_any_minus_/webapp/WEB_minus_INF/app/model//home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:74)<http://home.administrator.archivesspace.data.tmp.jetty_minus_0_dot_0_dot_0_dot_0_minus_8089_minus_backend_dot_war_minus___minus_any_minus_.webapp.WEB_minus_INF.app.model.db.invokeOther2:transaction(home/administrator/archivesspace/data/tmp/jetty_minus_0_dot_0_dot_0_dot_0_minus_8089_minus_backend_dot_war_minus___minus_any_minus_/webapp/WEB_minus_INF/app/model/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:74)> home.administrator.archivesspace.data.tmp.jetty_minus_0_dot_0_dot_0_dot_0_minus_8089_minus_backend_dot_war_minus___minus_any_minus_.webapp.WEB_minus_INF.app.model.db.transaction(/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:74)<http://home.administrator.archivesspace.data.tmp.jetty_minus_0_dot_0_dot_0_dot_0_minus_8089_minus_backend_dot_war_minus___minus_any_minus_.webapp.WEB_minus_INF.app.model.db.transaction(/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:74)> home.administrator.archivesspace.data.tmp.jetty_minus_0_dot_0_dot_0_dot_0_minus_8089_minus_backend_dot_war_minus___minus_any_minus_.webapp.WEB_minus_INF.app.model.db.invokeOther6:transaction(home/administrator/archivesspace/data/tmp/jetty_minus_0_dot_0_dot_0_dot_0_minus_8089_minus_backend_dot_war_minus___minus_any_minus_/webapp/WEB_minus_INF/app/model//home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:110)<http://home.administrator.archivesspace.data.tmp.jetty_minus_0_dot_0_dot_0_dot_0_minus_8089_minus_backend_dot_war_minus___minus_any_minus_.webapp.WEB_minus_INF.app.model.db.invokeOther6:transaction(home/administrator/archivesspace/data/tmp/jetty_minus_0_dot_0_dot_0_dot_0_minus_8089_minus_backend_dot_war_minus___minus_any_minus_/webapp/WEB_minus_INF/app/model/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:110)> home.administrator.archivesspace.data.tmp.jetty_minus_0_dot_0_dot_0_dot_0_minus_8089_minus_backend_dot_war_minus___minus_any_minus_.webapp.WEB_minus_INF.app.model.db.block<http://home.administrator.archivesspace.data.tmp.jetty_minus_0_dot_0_dot_0_dot_0_minus_8089_minus_backend_dot_war_minus___minus_any_minus_.webapp.WEB_minus_INF.app.model.db.block> in open(/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:110) org.jruby.RubyFixnum.times(org/jruby/RubyFixnum.java:305) org.jruby.RubyFixnum$INVOKER$i$0$0$times.call(org/jruby/RubyFixnum$INVOKER$i$0$0$times.gen) home.administrator.archivesspace.data.tmp.jetty_minus_0_dot_0_dot_0_dot_0_minus_8089_minus_backend_dot_war_minus___minus_any_minus_.webapp.WEB_minus_INF.app.model.db.invokeOther50:times(home/administrator/archivesspace/data/tmp/jetty_minus_0_dot_0_dot_0_dot_0_minus_8089_minus_backend_dot_war_minus___minus_any_minus_/webapp/WEB_minus_INF/app/model//home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:107)<http://home.administrator.archivesspace.data.tmp.jetty_minus_0_dot_0_dot_0_dot_0_minus_8089_minus_backend_dot_war_minus___minus_any_minus_.webapp.WEB_minus_INF.app.model.db.invokeOther50:times(home/administrator/archivesspace/data/tmp/jetty_minus_0_dot_0_dot_0_dot_0_minus_8089_minus_backend_dot_war_minus___minus_any_minus_/webapp/WEB_minus_INF/app/model/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:107)> home.administrator.archivesspace.data.tmp.jetty_minus_0_dot_0_dot_0_dot_0_minus_8089_minus_backend_dot_war_minus___minus_any_minus_.webapp.WEB_minus_INF.app.model.db.open(/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:107)<http://home.administrator.archivesspace.data.tmp.jetty_minus_0_dot_0_dot_0_dot_0_minus_8089_minus_backend_dot_war_minus___minus_any_minus_.webapp.WEB_minus_INF.app.model.db.open(/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:107)> org.jruby.RubyClass.finvoke(org/jruby/RubyClass.java:522) org.jruby.RubyBasicObject.send19(org/jruby/RubyBasicObject.java:1680) org.jruby.RubyKernel.send19(org/jruby/RubyKernel.java:1998) org.jruby.RubyKernel$INVOKER$s$send19.call(org/jruby/RubyKernel$INVOKER$s$send19.gen) home.administrator.archivesspace.data.tmp.jetty_minus_0_dot_0_dot_0_dot_0_minus_8089_minus_backend_dot_war_minus___minus_any_minus_.webapp.WEB_minus_INF.app.model.db.invokeOther1:send(home/administrator/archivesspace/data/tmp/jetty_minus_0_dot_0_dot_0_dot_0_minus_8089_minus_backend_dot_war_minus___minus_any_minus_/webapp/WEB_minus_INF/app/model//home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:432)<http://home.administrator.archivesspace.data.tmp.jetty_minus_0_dot_0_dot_0_dot_0_minus_8089_minus_backend_dot_war_minus___minus_any_minus_.webapp.WEB_minus_INF.app.model.db.invokeOther1:send(home/administrator/archivesspace/data/tmp/jetty_minus_0_dot_0_dot_0_dot_0_minus_8089_minus_backend_dot_war_minus___minus_any_minus_/webapp/WEB_minus_INF/app/model/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:432)> home.administrator.archivesspace.data.tmp.jetty_minus_0_dot_0_dot_0_dot_0_minus_8089_minus_backend_dot_war_minus___minus_any_minus_.webapp.WEB_minus_INF.app.model.db.block<http://home.administrator.archivesspace.data.tmp.jetty_minus_0_dot_0_dot_0_dot_0_minus_8089_minus_backend_dot_war_minus___minus_any_minus_.webapp.WEB_minus_INF.app.model.db.block> in DB(/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:432) org.jruby.RubyProc.call(org/jruby/RubyProc.java:289) RUBY.run(/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/job_runners/reports_runner.rb:36) home.administrator.archivesspace.data.tmp.jetty_minus_0_dot_0_dot_0_dot_0_minus_8089_minus_backend_dot_war_minus___minus_any_minus_.webapp.WEB_minus_INF.app.lib.background_job_queue.invokeOther43:run(home/administrator/archivesspace/data/tmp/jetty_minus_0_dot_0_dot_0_dot_0_minus_8089_minus_backend_dot_war_minus___minus_any_minus_/webapp/WEB_minus_INF/app/lib//home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/background_job_queue.rb:126)<http://home.administrator.archivesspace.data.tmp.jetty_minus_0_dot_0_dot_0_dot_0_minus_8089_minus_backend_dot_war_minus___minus_any_minus_.webapp.WEB_minus_INF.app.lib.background_job_queue.invokeOther43:run(home/administrator/archivesspace/data/tmp/jetty_minus_0_dot_0_dot_0_dot_0_minus_8089_minus_backend_dot_war_minus___minus_any_minus_/webapp/WEB_minus_INF/app/lib/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/background_job_queue.rb:126)> home.administrator.archivesspace.data.tmp.jetty_minus_0_dot_0_dot_0_dot_0_minus_8089_minus_backend_dot_war_minus___minus_any_minus_.webapp.WEB_minus_INF.app.lib.background_job_queue.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:126)<http://home.administrator.archivesspace.data.tmp.jetty_minus_0_dot_0_dot_0_dot_0_minus_8089_minus_backend_dot_war_minus___minus_any_minus_.webapp.WEB_minus_INF.app.lib.background_job_queue.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:126)> RUBY.block in 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:169) org.jruby.RubyProc.call(org/jruby/RubyProc.java:289) org.jruby.RubyProc.call(org/jruby/RubyProc.java:246) java.lang.Thread.run(java/lang/Thread.java:748) Done. Thanks, 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: [email protected]<mailto:[email protected]> <[email protected]<mailto:[email protected]>> on behalf of Christine Di Bella <[email protected]<mailto:[email protected]>> Sent: Wednesday, April 26, 2017 11:55:48 AM To: Archivesspace Users Group Subject: Re: [Archivesspace_Users_Group] Keep getting Failed status on generating reports Hi Daniel, I'm not familiar with that being a reason for having problems with reports, but others may be able to help with that. What I can point you to is the information about enabling reports for versions through 1.5.4 in the user manual at https://docs.archivesspace.org/Default.htm#ReportsEnabling.htm<https://urldefense.proofpoint.com/v2/url?u=https-3A__docs.archivesspace.org_Default.htm-23ReportsEnabling.htm-253FTocPath-253DUsing-252520Reports-252520in-252520ArchivesSpace-257C-5F-5F-5F-5F-5F2&d=DwMFAg&c=URKFmO0h1-PpCttSQ3v_bEhalPi_sNmh-_LG0Bso5YA&r=b3souzMEzT-OJXsXOvK9YInkZPMZDws8WozdGpuzrcA&m=oDgyVed-St5znTk-xl6Dacjpg_0TbT8PYPN450kj254&s=0mHDZoFl7njKgRfGnWUuu-EDR_NZ_mEI40hY9fHFGaM&e=>. Jasper reports has been removed from the application starting with 2.0.0, so these steps will no longer be necessary in future upgrades. Reports are an area of the application that is under active development at this time and we hope to have more updates available soon. An alternate that some people are using with success is setting up an ODBC connection or otherwise hooking ArchivesSpace up to output data to an external program. As one example, Nancy Enneking of the Getty presented a lightning talk titled DIY Reports in ArchivesSpace at a session called Making ArchivesSpace Work for You at SAA last summer. Nancy's talk is in the file posted at http://schd.ws/hosted_files/archives2016/3e/Session501-All_presenters.pptx<https://urldefense.proofpoint.com/v2/url?u=http-3A__schd.ws_hosted-5Ffiles_archives2016_3e_Session501-2DAll-5Fpresenters.pptx&d=DwMFAg&c=URKFmO0h1-PpCttSQ3v_bEhalPi_sNmh-_LG0Bso5YA&r=b3souzMEzT-OJXsXOvK9YInkZPMZDws8WozdGpuzrcA&m=oDgyVed-St5znTk-xl6Dacjpg_0TbT8PYPN450kj254&s=ilP1J-cliJSShrshVZDrabzWAJ46ntg-woX-TP4UWSQ&e=>; Nancy's starts on page 40. Christine From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Daniel L Thacker Sent: Wednesday, April 26, 2017 11:37 AM To: Archivesspace Users Group <[email protected]<mailto:[email protected]>> Subject: Re: [Archivesspace_Users_Group] Keep getting Failed status on generating reports 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: [email protected]<mailto:[email protected]> <[email protected]<mailto:[email protected]>> on behalf of Christine Di Bella <[email protected]<mailto:[email protected]>> 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 [email protected]<mailto:[email protected]> 800.999.8558 x2905 678-235-2905 cdibella13 (Skype) [ASpaceOrgHomeMedium] From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Daniel L Thacker Sent: Tuesday, April 25, 2017 3:17 PM To: [email protected]<mailto:[email protected]> 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 [email protected] http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
