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. Circ blocks loan of item: says there's hold for another patron, but there's not

    Circ blocks loan of item: says there's hold for another patron, but there's not

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 17.01

    Description:
    Circ blocks loan of item 001160273-000010, saying there is a hold for another patron, but no holds show for this item.

    Resolution:
    We see, using SQL, that there *is* a z37 hold record (expired) for this item:

    02 z37_rec_key \
    03 doc_number ..................001160273
    03 item_sequence ...............000010
    03 sequence ....................0001
    02 z37_id ........................AAX-5496
    02 z37_status ....................S
    02 z37_expand ....................N
    02 z37_priority ..................30
    02 z37_open_date .................20051023
    02 z37_open_hour .................1314
    02 z37_request_date ..............20051023
    02 z37_end_request_date ..........20051223
    02 z37_hold_date .................20051031
    02 z37_letter_status .............
    02 z37_letter_date ...............00000000
    02 z37_alpha .....................L
    02 z37_author ....................
    02 z37_title .....................
    02 z37_pages .....................
    02 z37_note_1 ....................
    02 z37_note_2 ....................
    02 z37_print_status ..............P
    02 z37_requester_id ..............
    02 z37_cataloger_name ............
    02 z37_cataloger_ip ..............
    02 z37_hold_sequence .............000
    02 z37_pickup_location ...........ULIB
    02 z37_send_action ...............01
    02 z37_end_hold_date .............20051107
    <etc.>

    You can either run p_cir_17 ("Delete Expired Hold Requests") or delete this z37 by key (0011602730000100001)
    using SQL.


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Circ block by item status?
      • CIRC_CREATED items not generating holds for CATALOGER patron
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 17.01
      2. contype:kba
      3. Prod:Aleph
      4. 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