"Unable to find Global Patron Information" -- missing z308 type 00 or type 01
- Product: Aleph
- Product Version: 20, 21, 22, 23
- Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care
Description
The message "Unable to find Global Patron Information" appears in trying to access a particular patron in the GUI.
The z308 type 00 (patron ID) and/or type 01 (patron barcode) records are missing for the patron. The following SQL checks for this condition.....
xxx00@ALEPH22> select z308_rec_key from z308 where z308_id = 'ID123456';
no rows selected
xxx00@ALEPH22> select z303_rec_key from z303 where z303_rec_key like 'ID123456%';
Z303_REC_KEY
------------
ID123456
xxx50@ALEPH22> select z305_rec_key from xxx50.z305 where z305_rec_key like 'ID123456%';
Z305_REC_KEY
-----------------
ID123456 XXX50
Thus, though the z303 and z305 exist, the z308's are missing.
[Note: If the z308's are present, the Article "Unable to find Global Patron information - COMPREHENSIVE ANSWER" discusses other possible causes.]
Resolution:
The Aleph GUI has no ability to handle the lack of the z308 type 00 or type 01. Nor can they be created by the file-20 service; it gets errors when it finds these missing.
If the patron has no loans or cash records, the patron might be deleted -- but that is not usually the case. The best course is usually to create the missing z308's and insert them: either using the SQL insert command or taking an "expendible" existing z308 and modifying it to have the necessary z308_rec_key and z308_id. If you encounter this situation and need assistance, please contact jerry.specht@exlibrisgroup.com.
NOTE: The following SQL's can be used to check for missing z308's for all patrons:
xxx50@ALEPH22> select z303_rec_key from z303 minus (select substr (z308_rec_key,3,12) from z308 where z308_rec_key like '00%');
xxx50@ALEPH22> select substr (z305_rec_key,1,12) from z305 minus (select substr (z308_rec_key,3,12) from z308 where z308_rec_key like '00%');
xxx50@ALEPH22> select /*+ DYNAMIC_SAMPLING(2) ALL_ROWS */ z303_rec_key from z303 where z303_rec_key not in (select z308_id from z308 where z308_rec_key like '01%');
- Article last edited: 28-Feb-2016