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

[Blake Henderson]

Jeffrey,

You will likely need to perform what's known as a "reingest" - there is 
a perl tool included in the Evergreen repo to aid this process.

https://docs.evergreen-ils.org/eg/docs/latest/development/support_scripts.html#pingest_pl 
<https://docs.evergreen-ils.org/eg/docs/latest/development/support_scripts.html#pingest_pl>

-Blake-
Conducting Magic
Can consume data in any format
MOBIUS

On 11/2/2020 12:47 PM, Jeffrey Goettsch wrote:
> 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
>
>
>
>
> _______________________________________________
> Evergreen-dev mailing list
> Evergreen-dev at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev

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