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

    No results when "Display Local Patrons Only" box is checked

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

    Description:
    When the "Display Local Patrons Only" box is checked, we don't get any results. When the box is un-checked, we get results. Why is that?

    Resolution:
    This occurs when there are no records in the Z353 table with this ADM library in their Z353-LIBRARY field (the first 5 bytes of z353_rec_key). In addition to the blank Z353-LIBRARY entries, there should also be Z353s containing the ADM library in this position..
    Though the Z353 records reside in the $usr_library, the p_cir_25 job which produces them needs to be run in the *ADM* library. The problem described occurs when the job is run for the $usr_library rather than the ADM library. If you have multiple ADM libraries, p_cir_25 needs to be run for each of them.

    The following SQL can be used to display all the z353 records for a particular patron:

    SQL> select z353_rec_key from z353 where z353_id = 'xxxxxxxx';
    <where 'xxxxxxxx' is the patron ID (the Z303-ID) >

    See KB 16384-1442 for another cause of this problem.


    • Article last edited: 10/8/2013