[Archivesspace_Users_Group] Our Solution to Running Reports

[Daniel L Thacker]

We were asked to post our solution once we talked to the LYRASIS Support Desk and resolved our issue.  Here it is:


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.



Here is the part of the conversation to hopefully make it more clear if it isn't already:


LYRASIS Support Desk:

Hi Daniel,
There is something up with the stored functions on your database.
Seeing this:
Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: FUNCTION archivesspace.GetAccessionProcessed does not exist
Makes me think your missing at least that one function. You can see it in the code here:
https://github.com/archivesspace/archivesspace/blob/5e1ca66f1f04f142f2695024efb7200825046325/common/db/migrations/055_add_reports_stored_functions.rb#L261<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=>
Was your database maybe restored from a backup? You'll need to get those functions restored.
US- TAMUK


Yes, they were restored from the backup. How do we restore the functions?


LYRASIS Support Desk:


Aha, thank makes sense. If you have the original DB you can pull out the functions, something like:
mysqldump --routines --no-create-info --no-data --no-create-db --skip-opt archivesspace > as-functions.sql
Then you can put those back into your real database:
mysql archivesspace < as-functions.sql
Be sure to back things up before doing that, just in case.
I can pull the functions out from a DB here if you don't have one there you can use, just let me know.
END
Hope this helps and thank you to everyone who helped and inquired!




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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20170428/2f2b5e16/attachment.html>