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