[Evergreen-dev] Why are our catalog searches always empty?

[Jeffrey Goettsch]

Hi,

Thanks for any assistance you can provide.

TL;DR: All our catalog searches give no results. The search query joins on the metabib.record_attr_vector_list table, which is empty. How do we populate this table?

--

We are migrating to Evergreen 3.6 from a much more primitive, homegrown database. Everything is working well, except all catalog searches turn up empty, whether through the patron view or the admin view. Searching by barcode works fine.

I captured the search query in PostgreSQL. It performs a join on the metabib.record_attr_vector_list table, which is empty, and thus returns no results. If I modify the query to remove the join, or if I insert some dummy records into the metabib.record_attr_vector_list table, then the query returns some results. And if I insert dummy records into the table, then searches in the web interface work as expected.

I have tried to import our MARC records with the batch import tool through the web and also directly through the database, but both give the same results. I have modeled our import code on the samples provided here:

  https://docs.evergreen-ils.org/eg/docs/3.6/admin_initial_setup/migrating_your_data.html <https://docs.evergreen-ils.org/eg/docs/3.6/admin_initial_setup/migrating_your_data.html>

Here is a link to my import scripts, a sample of our records and holdings, a formatted MARC record, and the PostgreSQL query:

  https://gist.github.com/jdgoettsch/ac56e6ba82207c97c7de8f21ed5102a6 <https://gist.github.com/jdgoettsch/ac56e6ba82207c97c7de8f21ed5102a6>


➞ Specifically now I’m wondering what the metabib.record_attr_vector_list is for, and how it is populated.
(1) Is my import script missing a step?
(2) Are our MARC records missing a piece? Our previous database did not use MARC records, so we may be missing something.

Thanks again.


-- 
Jeff Goettsch



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-dev/attachments/20201102/98e2b0d1/attachment.html>