[OPEN-ILS-GENERAL] Opac Visibility Issues - asset.opac_visible_copies was: 856 9 - for suppression - timing

[Josh Stompro]

Hello, I figured out what our problem was.  We had bad data in asset.opac_visible_copies, I think it was from our test load maybe.  So we had some records that had no visible copies (only one copy that was marked not visibible) that had 6 entries in the asset.opac_visible_copies table.  So no matter what I did, I couldn't get it to not show up in the catalog search results.

To fix it I followed the notes from commit c1155bee5400 [1], which say to run "SELECT asset.refresh_opac_visible_copies_mat_view();" to clear and rebuild the table.

After fixing this we don't need to even bother with the 856 hiding trick, it just works like we would expect now.  If there are no visible copies, the bib is hidden also.

If there are any migration checklists out there, this should get added to them.

1 - http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=c1155bee540027de270580a6a6c1d6078bbd478f


Josh Stompro - LARL IT Director

From: Open-ils-general [mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of Josh Stompro
Sent: Thursday, May 19, 2016 4:32 PM
To: open-ils-general at list.georgialibraries.org
Subject: [OPEN-ILS-GENERAL] 856 9 - for suppression - timing

Hello, we have been using the trick of using 856 subfield 9 set to a non visible org unit to try to suppress certain records from the catalog and z39.50 results.  I think it works, but whenever I try and test it I cannot get it to work immediately.  I'm assuming that the visibility of the record is cached somehow?  Is the cached data that causes the delay located in the memcached server?  Can anyone give me pointers of what to look for if I want to try and clear it out manually by querying the memcache server?

Thanks
Josh

Lake Agassiz Regional Library - Moorhead MN larl.org
Josh Stompro     | Office 218.233.3757 EXT-139
LARL IT Director | Cell 218.790.2110

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20160520/a8404bda/attachment-0001.html>