<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Daniel,<br>
What do you find with the said SQL command ?<br>
<br>
Mang <br>
<div class="moz-cite-prefix">On 4/26/2017 10:37 AM, Daniel L Thacker
wrote:<br>
</div>
<blockquote
cite="mid:MWHPR08MB348575C7C9B3A34017611FF381110@MWHPR08MB3485.namprd08.prod.outlook.com"
type="cite">
<meta http-equiv="Context-Type" content="text/html;
charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<div id="divtagdefaultwrapper" dir="ltr">
<p>Hi Christine,</p>
<p><br>
</p>
<p>We are running <span>v1.5.4. I also got some advice to do: </span></p>
<p><span><br>
</span></p>
<p><span>"<span>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."</span></span></p>
<p><span><span><br>
</span></span></p>
<p><span><span>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? </span></span></p>
<p><span><span><br>
</span></span></p>
<p><span><span>Thank you,</span></span></p>
<p><br>
</p>
<div id="Signature">
<div id="divtagdefaultwrapper">
<p>Daniel Thacker</p>
<p>Digital Archivist </p>
<p>James C. Jernigan Library</p>
<p>Texas A&M University-Kingsville</p>
<p>MSC 197 </p>
<p>700 University Blvd</p>
<p>Kingsville, TX 78363-8202</p>
<p>361-593-4154</p>
</div>
</div>
</div>
<hr tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><b>From:</b>
<a class="moz-txt-link-abbreviated" href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>
<a class="moz-txt-link-rfc2396E" href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org"><archivesspace_users_group-bounces@lyralists.lyrasis.org></a>
on behalf of Christine Di Bella
<a class="moz-txt-link-rfc2396E" href="mailto:christine.dibella@lyrasis.org"><christine.dibella@lyrasis.org></a><br>
<b>Sent:</b> Wednesday, April 26, 2017 10:18:09 AM<br>
<b>To:</b> Archivesspace Users Group<br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Keep getting
Failed status on generating reports
<div> </div>
</div>
<div>
<div class="WordSection1">
<p class="MsoNormal"><span>Dear Daniel,</span></p>
<p class="MsoNormal"><span> </span></p>
<p class="MsoNormal"><span>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.</span></p>
<p class="MsoNormal"><span> </span></p>
<p class="MsoNormal"><span>Christine</span></p>
<p class="MsoNormal"><span> </span></p>
<p class="MsoNormal"><span>Christine Di Bella</span></p>
<p class="MsoNormal"><span>ArchivesSpace Program Manager</span></p>
<p class="MsoNormal"><span><a moz-do-not-send="true"
href="mailto:christine.dibella@lyrasis.org"><span>christine.dibella@lyrasis.org</span></a></span></p>
<p class="MsoNormal"><span>800.999.8558 x2905</span></p>
<p class="MsoNormal"><span>678-235-2905</span></p>
<p class="MsoNormal"><span>cdibella13 (Skype)</span><span></span></p>
<p class="MsoNormal"><span> </span></p>
<p class="MsoNormal"><span><img id="Picture_x0020_1"
alt="ASpaceOrgHomeMedium"
src="cid:part2.7C11F40F.9F7E2843@rice.edu" height="61"
width="267"></span></p>
<p class="MsoNormal"><span> </span></p>
<p class="MsoNormal"><span> </span></p>
<p class="MsoNormal"><span> </span></p>
<div>
<div>
<p class="MsoNormal"><b><span>From:</span></b><span>
<a class="moz-txt-link-abbreviated" href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>
[<a class="moz-txt-link-freetext" href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org</a>]
<b>On Behalf Of </b>Daniel L Thacker<br>
<b>Sent:</b> Tuesday, April 25, 2017 3:17 PM<br>
<b>To:</b>
<a class="moz-txt-link-abbreviated" href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a><br>
<b>Subject:</b> [Archivesspace_Users_Group] Keep
getting Failed status on generating reports</span></p>
</div>
</div>
<p class="MsoNormal"> </p>
<div id="divtagdefaultwrapper">
<p><span>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 </span><span>accessions record reports.
Here is the log: Thank you.</span><span></span></p>
<p><span> </span></p>
<p><span> </span></p>
<p><span> </span></p>
<div>
<p class="MsoNormal"><span>Generating report</span></p>
</div>
<div>
<p class="MsoNormal"><span>Error executing SQL statement
for : accessionsRecord</span></p>
</div>
<div>
<p class="MsoNormal"><span>net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(net/sf/jasperreports/engine/query/JRJdbcQueryExecuter.java:240)</span></p>
</div>
<div>
<p class="MsoNormal"><span>net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(net/sf/jasperreports/engine/fill/JRFillDataset.java:1114)</span></p>
</div>
<div>
<p class="MsoNormal"><span>net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(net/sf/jasperreports/engine/fill/JRFillDataset.java:691)</span></p>
</div>
<div>
<p class="MsoNormal"><span>net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(net/sf/jasperreports/engine/fill/JRBaseFiller.java:1314)</span></p>
</div>
<div>
<p class="MsoNormal"><span>net.sf.jasperreports.engine.fill.JRBaseFiller.fill(net/sf/jasperreports/engine/fill/JRBaseFiller.java:931)</span></p>
</div>
<div>
<p class="MsoNormal"><span>net.sf.jasperreports.engine.fill.JRBaseFiller.fill(net/sf/jasperreports/engine/fill/JRBaseFiller.java:873)</span></p>
</div>
<div>
<p class="MsoNormal"><span>net.sf.jasperreports.engine.fill.JRFiller.fill(net/sf/jasperreports/engine/fill/JRFiller.java:87)</span></p>
</div>
<div>
<p class="MsoNormal"><span>net.sf.jasperreports.engine.JasperFillManager.fill(net/sf/jasperreports/engine/JasperFillManager.java:287)</span></p>
</div>
<div>
<p class="MsoNormal"><span>net.sf.jasperreports.engine.JasperFillManager.fillReport(net/sf/jasperreports/engine/JasperFillManager.java:760)</span></p>
</div>
<div>
<p class="MsoNormal"><span>java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:498)</span></p>
</div>
<div>
<p class="MsoNormal"><span>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)</span></p>
</div>
<div>
<p class="MsoNormal"><span>Sequel::ThreadedConnectionPool.hold(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:98)</span></p>
</div>
<div>
<p class="MsoNormal"><span>Sequel::ThreadedConnectionPool.hold(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:98)</span></p>
</div>
<div>
<p class="MsoNormal"><span>Sequel::ThreadedConnectionPool.hold(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:87)</span></p>
</div>
<div>
<p class="MsoNormal"><span>Sequel::ThreadedConnectionPool.hold(/home/administrator/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:87)</span></p>
</div>
<div>
<p class="MsoNormal"><span>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)</span></p>
</div>
<div>
<p class="MsoNormal"><span>DB.open(/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:143)</span></p>
</div>
<div>
<p class="MsoNormal"><span>DB.open(/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:143)</span></p>
</div>
<div>
<p class="MsoNormal"><span>org.jruby.RubyFixnum.times(org/jruby/RubyFixnum.java:280)</span></p>
</div>
<div>
<p class="MsoNormal"><span>DB.open(/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:131)</span></p>
</div>
<div>
<p class="MsoNormal"><span>DB.open(/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:131)</span></p>
</div>
<div>
<p class="MsoNormal"><span>DB.open(/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:127)</span></p>
</div>
<div>
<p class="MsoNormal"><span>DB.open(/home/administrator/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:127)</span></p>
</div>
<div>
<p class="MsoNormal"><span>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)</span></p>
</div>
<div>
<p class="MsoNormal"><span>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)</span></p>
</div>
<div>
<p class="MsoNormal"><span>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)</span></p>
</div>
<div>
<p class="MsoNormal"><span>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)</span></p>
</div>
<div>
<p class="MsoNormal"><span>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)</span></p>
</div>
<div>
<p class="MsoNormal"><span>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)</span></p>
</div>
<div>
<p class="MsoNormal"><span>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)</span></p>
</div>
<div>
<p class="MsoNormal"><span>java.lang.Thread.run(java/lang/Thread.java:745)</span></p>
</div>
<div>
<p class="MsoNormal"><span>Done.</span></p>
</div>
<p class="MsoNormal"><span> </span></p>
<p><span> </span></p>
<div id="Signature">
<div id="divtagdefaultwrapper">
<p><span>Daniel Thacker</span></p>
<p><span>Digital Archivist </span></p>
<p><span>James C. Jernigan Library</span></p>
<p><span>Texas A&M University-Kingsville</span></p>
<p><span>MSC 197 </span></p>
<p><span>700 University Blvd</span></p>
<p><span>Kingsville, TX 78363-8202</span></p>
<p><span>361-593-4154</span></p>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Archivesspace_Users_Group mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org">Archivesspace_Users_Group@lyralists.lyrasis.org</a>
<a class="moz-txt-link-freetext" href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a>
</pre>
</blockquote>
<br>
</body>
</html>