<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Arial,Helvetica,sans-serif;" dir="ltr">
<p>We were asked to post our solution once we talked to the LYRASIS Support Desk and resolved our issue. Here it is:</p>
<p><br>
</p>
<p>Our problem was that we couldn't run reports on V1.5.4 and V2.0.0. The problem, as explained to me by our tech guy, was that when we backed up ArchivesSpace V1.52 to go to V1.5.4 we did a short back-up instead of a long back-up. The short back-up got all
of our data but not the functions from the DB. We put those functions back and we are now able to run reports. </p>
<p><br>
</p>
<p><br>
</p>
<p>Here is the part of the conversation to hopefully make it more clear if it isn't already:</p>
<p><br>
</p>
<p><b>LYRASIS Support Desk:</b></p>
<p></p>
<div style="color: rgb(43, 46, 47); font-family: "Lucida Sans Unicode", "Lucida Grande", Tahoma, Verdana, sans-serif; font-size: 14px; margin: 15px 0px;">
<font face="Lucida Sans Unicode,Lucida Grande,Tahoma,Verdana,sans-serif">Hi Daniel,<br>
There is something up with the stored functions on your database.<br>
Seeing this:<br>
Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: FUNCTION archivesspace.GetAccessionProcessed does not exist<br>
Makes me think your missing at least that one function. You can see it in the code here:<br>
<a href="https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_archivesspace_archivesspace_blob_5e1ca66f1f04f142f2695024efb7200825046325_common_db_migrations_055-5Fadd-5Freports-5Fstored-5Ffunctions.rb-23L261&d=DwMFaQ&c=URKFmO0h1-PpCttSQ3v_bEhalPi_sNmh-_LG0Bso5YA&r=b3souzMEzT-OJXsXOvK9YInkZPMZDws8WozdGpuzrcA&m=TAEJy6qxlvWT9u55AJ0CinFmP4h7ZeTmaEMNMjRmH98&s=gkBxxYSKrj6sezSw18krc3FJnPz0xG30uPd3mddlsIM&e=" target="_blank" rel="noopener noreferrer">https://github.com/archivesspace/archivesspace/blob/5e1ca66f1f04f142f2695024efb7200825046325/common/db/migrations/055_add_reports_stored_functions.rb#L261</a></font></div>
<div style="color: rgb(43, 46, 47); font-family: "Lucida Sans Unicode", "Lucida Grande", Tahoma, Verdana, sans-serif; font-size: 14px; margin: 15px 0px;">
<font face="Lucida Sans Unicode,Lucida Grande,Tahoma,Verdana,sans-serif">Was your database maybe restored from a backup? You'll need to get those functions restored.</font></div>
<b>US- TAMUK</b>
<p></p>
<p><br>
</p>
<p><span style="color: rgb(43, 46, 47); font-family: "Lucida Sans Unicode", "Lucida Grande", Tahoma, Verdana, sans-serif; font-size: 14px;">Yes, they were restored from the backup. How do we restore the functions?</span><br>
</p>
<p><span style="color: rgb(43, 46, 47); font-family: "Lucida Sans Unicode", "Lucida Grande", Tahoma, Verdana, sans-serif; font-size: 14px;"><br>
</span></p>
<p><span style="color: rgb(43, 46, 47); font-family: "Lucida Sans Unicode", "Lucida Grande", Tahoma, Verdana, sans-serif; font-size: 14px;">LYRASIS Support Desk:</span></p>
<p><span style="color: rgb(43, 46, 47); font-family: "Lucida Sans Unicode", "Lucida Grande", Tahoma, Verdana, sans-serif; font-size: 14px;"><br>
</span></p>
<p><span style="color: rgb(43, 46, 47); font-family: "Lucida Sans Unicode", "Lucida Grande", Tahoma, Verdana, sans-serif; font-size: 14px;"></p>
<div style="color: rgb(43, 46, 47); font-family: "Lucida Sans Unicode", "Lucida Grande", Tahoma, Verdana, sans-serif; font-size: 14px; margin: 15px 0px;">
<font face="Lucida Sans Unicode,Lucida Grande,Tahoma,Verdana,sans-serif">Aha, thank makes sense. If you have the original DB you can pull out the functions, something like:<br>
mysqldump --routines --no-create-info --no-data --no-create-db --skip-opt archivesspace > as-functions.sql<br>
Then you can put those back into your real database:<br>
mysql archivesspace < as-functions.sql<br>
Be sure to back things up before doing that, just in case.</font></div>
<div style="color: rgb(43, 46, 47); font-family: "Lucida Sans Unicode", "Lucida Grande", Tahoma, Verdana, sans-serif; font-size: 14px; margin: 15px 0px;">
<font face="Lucida Sans Unicode,Lucida Grande,Tahoma,Verdana,sans-serif">I can pull the functions out from a DB here if you don't have one there you can use, just let me know.</font></div>
<div style="color: rgb(43, 46, 47); font-family: "Lucida Sans Unicode", "Lucida Grande", Tahoma, Verdana, sans-serif; font-size: 14px; margin: 15px 0px;">
<font face="Lucida Sans Unicode,Lucida Grande,Tahoma,Verdana,sans-serif"><b>END</b></font></div>
<div style="color: rgb(43, 46, 47); font-family: "Lucida Sans Unicode", "Lucida Grande", Tahoma, Verdana, sans-serif; font-size: 14px; margin: 15px 0px;">
Hope this helps and thank you to everyone who helped and inquired!</div>
<b></b><br>
</span>
<p></p>
<p><br>
</p>
<p><br>
</p>
<div id="Signature">
<div id="divtagdefaultwrapper" style="font-size:12pt; color:#000000; background-color:#FFFFFF; font-family:Calibri,Arial,Helvetica,sans-serif">
<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>
</body>
</html>