Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Title column blank in Browse of number index -- where does it come from?

    • Article Type: General
    • Product: Aleph
    • Product Version: 16.02

    Description:
    Following KB 8192-4648, we have made our SuDoc and call number indexes on our Test server display in the Browse with a Title column (by making them Direct indexes).

    We find, however that, though most of the the call number entries have a title, for some of them, the title column is blank.

    Resolution:
    The Browse on Direct index gets the Title info from the z13_title field in the bib record z13.

    util f/4 in abc01 shows that these doc records do not have z13 records:

    enter start Z13 key (999999999) or q to quit
    000737200

    01 z13_short_doc \
    02 z13_rec_key \
    03 doc_number ..............000813971 <-- skips to 813971


    enter start Z13 key (999999999) or q to quit
    004011773

    01 z13_short_doc \
    02 z13_rec_key \
    03 doc_number ..............006000001 <-- skips to 6000001

    The following SQL shows that, while the Production server abc01 has exactly the same number of z13's as z00's (correct):

    SQL-ABC01> select count(*) from z00;

    **** Hit return to continue ****
    COUNT(*)
    ----------
    3568787


    SQL-ABC01> select count(*) from z13;

    **** Hit return to continue ****
    COUNT(*)
    ----------
    3568787

    The Test abc01 has 546,009 fewer z13's (3500300 - 2954291):


    abc01@ALEPH0> select count(*) from z00;

    **** Hit return to continue ****
    COUNT(*)
    ----------
    3500300


    abc01@ALEPH0> select count(*) from z13;

    **** Hit return to continue ****
    COUNT(*)
    ----------
    2954291

    This indicates a need to run p_manage_07 on the Test server.

    Additional Information

    faq


    • Article last edited: 10/8/2013