<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Hi,<div class=""><br class=""></div><div class="">Thanks for any assistance you can provide.</div><div class=""><br class=""></div><div class="">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?</div><div class=""><br class=""></div><div class="">--</div><div class=""><br class=""><div class="">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.</div><div class=""><br class=""></div><div class="">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.</div><div class=""><br class=""></div><div class="">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:</div><div class=""><br class=""></div><div class=""> <a href="https://docs.evergreen-ils.org/eg/docs/3.6/admin_initial_setup/migrating_your_data.html" class="">https://docs.evergreen-ils.org/eg/docs/3.6/admin_initial_setup/migrating_your_data.html</a></div><div class=""><br class=""></div><div class="">Here is a link to my import scripts, a sample of our records and holdings, a formatted MARC record, and the PostgreSQL query:</div><div class=""><br class=""></div><div class=""> <a href="https://gist.github.com/jdgoettsch/ac56e6ba82207c97c7de8f21ed5102a6" class="">https://gist.github.com/jdgoettsch/ac56e6ba82207c97c7de8f21ed5102a6</a></div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">➞ Specifically now I’m wondering what the metabib.record_attr_vector_list is for, and how it is populated.</div><div class="">(1) Is my import script missing a step?</div><div class="">(2) Are our MARC records missing a piece? Our previous database did not use MARC records, so we may be missing something.</div><div class=""><br class=""></div><div class="">Thanks again.</div><div class=""><br class="webkit-block-placeholder"></div><div class="">
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Hack; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none;"><br class="Apple-interchange-newline">-- </div><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Hack; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none;">Jeff Goettsch</div><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Hack; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none;"><br class=""></div><br class="Apple-interchange-newline">
</div>
<br class=""></div></body></html>