[Archivesspace_Users_Group] Strange indexing issue v2.81

2020-11-19 Thread Zachary L Pelli
Hey all, After installing v2.81 we're having a strange issue, seemingly related to the index. Some collections cannot be found via search as they were before. I deleted the index in order to force a reindex and the collections were then searchable for a time. But coming back later, the issue ha

Re: [Archivesspace_Users_Group] Strange indexing issue v2.81

2020-11-19 Thread Brian Harrington
Hi Zach, Try truncating the deleted_records table and reindexing. That usually seems to solve issues with resources disappearing from the search. Brian -- Brian Harrington (he/him) Data Migration Specialist LYRASIS brian.harring...@lyrasis.org From: on behalf of Zachary L Pelli Reply-To: A

Re: [Archivesspace_Users_Group] Strange indexing issue v2.81

2020-11-19 Thread Donald Mennerich
Zach, Is your index roughly the same size as it was before you upgraded? How long has it been running since you restarted Aspace after upgrading? I might advise anyone rebuilding the index that it's advantageous to make a backup of the index before deleting your data (I keep a tar file that I can

Re: [Archivesspace_Users_Group] Strange indexing issue v2.81

2020-11-19 Thread Shedd, Julie
We are experiencing this issue now, but with accession and resource records. I think it may have something to do – at least in our case – with having certain metadata fields empty. When I filled those fields, the items stayed. However, transferring between repositories, they vanished again. So I

Re: [Archivesspace_Users_Group] Appraisal information database location

2020-11-19 Thread Brian Harrington
Hi Bryan, Appraisal is just a note, so it should be in the “note” table. The JSON for each note is stored in the notes field. You’ll need to use the MySQL JSON functions to extract the information you want https://dev.mysql.com/doc/refman/5.7/en/json-search-functions.html . I hope this helps

[Archivesspace_Users_Group] Appraisal information database location

2020-11-19 Thread Bryan W Sutherland
Hello, I'm trying to locate where in the ASpace database the information within the item-level appraisal tag is located. There is date information within this tag that I would like to extract. My colleagues in technical support and I have been unable to find it and there doesn't seems to be a r