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

    "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