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

Description:
When we try and do a browse search, like title or author, in some of our smaller search bases we get an error "Request is beyond heading in ACCess file". The search also fails in the OPAC. This only seems to be happening for some of the smaller search bases like abcl01film or abc01music. It works fine for the larger bases like abc01qrs.

Resolution:
Looking at the $alephe_tab/tab_base.eng, I see that ABC01FILM and ABC01MUSIC have "Y" in column 8 (meaning that the system is expecting to find entries for these bases in the z0102 table), while ABC01QRS has "N" in column 8 (meaning that the system does not look at z0102 for this base).

I find that the z0102 does have many entries for these bases:

abc01@ALEPH20> select count(*) from z0102 where Z0102_REC_KEY_1 like 'ABC01FILM%';
**** Hit return to continue ****

COUNT(*)
----------
861799


abc01@ALEPH20> select count(*) from z0102 where Z0102_REC_KEY_1 like 'ABC01MUSIC%';
**** Hit return to continue ****

COUNT(*)
----------
1339695

util h/1/10 ("Run Report Online / Z0102 Setup") shows the same results.

You can check what z0102 entries exist for a particular bib record by doing util f/4 in fcl01 for z0102 and entering the bib record number as the key. You can do this for a bib record which *should* be displaying in this base.

If you find there is no z0102 for this record for this base, then resend the record to the server via the GUI Cataloging or util f/1/13, check to confirm that there *is* now a z102 for this base, and then see if the record displays in the OPAC.

[From site:] Running p_manage_32 to rebuild the Z0102 seems to have fixed the problem.

• Article last edited: 10/8/2013