Wishlist: Tech specs for Authority Browse development

Related bug 1662541

The working branch for this is collab/gmcharlt/lp1638299_authority_indexing_infrastructure

The branch needs to be cleaned up prior to my making a pullrequest, but is functionally complete and is ready for feedback.

A branch is available for review as

user/gmcharlt/lp1638299_authority_infrastructure_improvements

http://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/gmcharlt/lp1638299_authority_infrastructure_improvements

It looks like we have a merge conflict in the 030 schema file. Would you be able resolve it Galen? Thanks!

I'm working on a rebase now.

I've forced-pushed an update to user/gmcharlt/lp1638299_authority_infrastructure_improvements that rebases it and adds some improvements.

Hi Galen,
I tested this on an upgraded database, and everything is working very well there.

However, when I tried it with a fresh database, I had some trouble. Whenever I tried to perform a browse search, I received a message saying "An error occurred browsing records. Please try again in a moment or report the issue to library staff."

I see the following in the osrfsys.log

open-ils.cstore 2017-09-01 14:17:54 [INFO:22044:osrf_app_session.c:1177:15042898572203216] [open-ils.cstore] sent 227 bytes of data to <email address hidden>/client_at_mlnc1.noblenet.org_22032
open-ils.cstore 2017-09-01 14:17:54 [WARN:22044:osrf_application.c:850:15042898572203216] Returning method exception with message: An unknown server error occurred
open-ils.cstore 2017-09-01 14:17:54 [INFO:22044:osrf_app_session.c:1177:15042898572203216] [open-ils.cstore] sent 207 bytes of data to <email address hidden>/client_at_mlnc1.noblenet.org_22032
open-ils.cstore 2017-09-01 14:17:54 [INFO:22044:osrf_stack.c:163:15042898572203216] Message processing duration 0.001416
[2017-09-01 14:17:54] /usr/sbin/apache2 [ERR :22032:CStoreEditor.pm:139:15042898572203216] editor[0|0] request error open-ils.cstore.json_query.atomic : {"from":["metabib.browse","subject","violins",1,null,"f",null,10]} : Exception: OpenSRF::DomainObject::oilsMethodException 2017-09-01T14:17:54 OpenILS::Utils::CStoreEditor /usr/local/share/perl/5.18.2/OpenILS/Utils/CStoreEditor.pm:465 <500> Severe query error -- see error log for more details

[2017-09-01 14:17:54] /usr/sbin/apache2 [ERR :22032:EX.pm:66:15042898572203216] Exception: OpenSRF::DomainObject::oilsMethodException 2017-09-01T14:17:54 OpenILS::Utils::CStoreEditor /usr/local/share/perl/5.18.2/OpenILS/Utils/CStoreEditor.pm:478 <500> Severe query error -- see error log for more details

[2017-09-01 14:17:54] /usr/sbin/apache2 [WARN:22032:Browse.pm:290:15042898572203216] error in browse (direct): DATABASE_QUERY_FAILED

I see the following in the postgres log:

2017-09-01 14:28:25.790 EDT [22050] evergreen@evergreen ERROR: function metabib.browse(unknown, unknown, unknown, unknown, unknown, unknown, unknown) does not exist at character 15
2017-09-01 14:28:25.790 EDT [22050] evergreen@evergreen HINT: No function matches the given name and argument types. You might need to add explicit type casts.
2017-09-01 14:28:25.790 EDT [22050] evergreen@evergreen STATEMENT: SELECT * FROM metabib.browse( 'subject', 'v', '1', NULL, 'f', NULL, '10' ) AS "metabib.browse" ;

OK, with a typo fix in a file, this is now working for me.

I resolved a conflict in the 950 seed data file and made a tweak to browse.tt2 to fix the label for narrower terms. Merged to master.

This is a huge improvement to the way cross-references are displaying in the browse screen, and our users are going to be thrilled to see it in action!

Thank you Galen!