[Archivesspace_Users_Group] Records listed under Resources, but can not view and not found in DB

[Boggio, Jerry]

Hello ASpace Users Group;

We are experiencing an issue where 2 records are displayed under Resources, but when you click "View" or "Edit" get a message "Record Not Found. The record you've tried to access may no longer exist or you may not have permission to view it". Running a MySQL query against the Resource table does not find the these 2 records. Have deleted the directories of the following indexes so that they would be rebuild, but that has not helped.

[/apps/archivesspace/data]$ ll
total 32
drwxr-xr-x  2 aspc   users   42 Feb 17 16:34 indexer_pui_state
drwxr-xr-x  2 aspc   users 4096 Feb 17 17:03 indexer_state
drwxr-xr-x  3 aspc   users   18 Feb 18 09:03 solr_index

This leads to a few questions:

  *   What is the query to collect the records to display with Browse > Resources? In other words, in which table(s) is the data stored to produce the list of records Browse > Resources stored?
  *   Short of deleting and recreating the "broken" records, how can we "reconnect" the underlying data to these 2 items?

Please let us know if you need more information.

Thank you!
Gerard (Jerry) Boggio | MITRE Corporation | R504 - Collaboration & Info Management | 781-271-2719 | Bedford, MA | 2K132

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20200218/db5016ec/attachment.html>