p_item_05: zero results; no items listed

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

Description:
I am trying to get a p_item_05 report for the call numbers in the TL range. All I get is the headers in the resulting file. I do not get any items listed. It does not matter what call number range or collection code I use. I get the same result. (Or there may be some, but they are in the wrong order.)

Resolution:
The p_item_05 reads the z30_call_no_key fields in the item records. The first step in diagnosing this problem is to see what the z30_call_no_key fields look like. Do this SQL:

SQL-xxx50>> select count(*) from z30 where Z30_CALL_NO_KEY is null;

[Note: If you don't do SQL, you could look at the xxx50 z30 records using UTIL-F-4] The result should be zero. If it's not, that indicates the need to run p_item_06 to populate the z30_call_no_key fields.

If they are populated, then check the $alephe_scratch job log to make sure it doesn't have the message "can not be created for more than 5000 items". If it does, then consult KB 16384-23778.

If it doesn't, then do this SQL to look at the call numbers: SQL-xxx50: select Z30_CALL_NO_KEY from z30;

In this case we see LC call numbers like this: 0h!83 f56 0r"730 y68 The "0" in front of the number is there because add_call_no_type has been specified in the ./xxx50/tab/tab_filing_call_no .

You can remove the add_call_no_type --or leave it in. In any case, p_item_06 will need to be rerun if tab_filing_call_no is changed.

*In general:*

If you make a change to the tab_filing_call_no table, you need to re-run p_item_06. Failure to do so can result in p_item_05 not finding any call numbers. This is because p_item_05 also reads this table and if it is different (in any significant way) from what it was when p_item_06 was run, then the z30_call_no_key's won't match.