Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. On-shelf Item shows as unavailable; z37_end_hold_date

    On-shelf Item shows as unavailable; z37_end_hold_date

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Description:  
    2. Resolution:  
    • Article Type: General
    • Product: Aleph
    • Product Version: 20 and up

    Description:  


    A specific item is on the shelf. There is no loan and the process status appears to be clear, but the system is treating it as if it is unavailable.
    The Aleph OPAC is presenting the user with a request link, which should not be there in such a case. Also, the record published out to Primo lists the item as unavailable in the AVA field. What is causing the problem and how to fix it?

     

    Resolution:  

    There is a hold request (z37) for this item with z37_status of "S", indicating that it has been placed on the hold shelf and the patron has been notified of its availability.
    It has a z37_end_hold_date of 20090921. This hold, when not picked up, should have either been deleted manually or by the cir-06 service. cir-60 deletes expired hold-shelf requests.
    Checking the p_cir_06 runs in $alephe_scratch, I find that they are all for a special pick-up location. But the relevant z37 has another z37_pickup_location, therefore, it has continued to exist.
    The following SQL can be used to check if there are similar cases:
    xxx50@MALC20> select count(*) from z37 where z37_status = 'S' and z37_end_hold_date < '20120223';

    And the following that these are for a variety of locations:
    xxx50@MALC20> select z37_rec_key, z37_end_hold_date, z37_pickup_location from z37 where z37_status = 'S' and z37_end_hold_date < '20120223' order by z37_end_hold_date;

    You need to either change the Pickup Location parameter in your cir-06 submission to "All" or run the job multiple times for each location.


    • Article last edited: 25-May-2017
    View article in the Exlibris Knowledge Center
    1. Back to top
      • On certain PCs, after 10 GUI emails, user gets: Cannot communicate to the server
      • Once documents for a course go to "NA", is there a way to reactivate them?
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. contype:kba
      3. hold request
      4. Prod:Aleph
      5. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved