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. cir-17 Does Not Delete Certain Hold Requests

    cir-17 Does Not Delete Certain Hold Requests

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Aleph
    • Product Version: 21

    Problem Symptoms:
    * Report / Delete Expired Hold Requests (cir-17) doesn't delete certain hold requests
    * There are no entries in the Z370 (Title Requests) table.
    * There are more than 800 entries with past end dates in the Z37 (Requests).

    Cause:
    The required jobs were not being run in some of the customer sublibraries.

    Resolution:
    Analysis of this situation showed

    1. This SQL showed that only 504 of the more than 800 expired requests had Z37_END_REQUEST_DATE's:
    SQL> select count(*) from z37 where Z37_END_REQUEST_DATE < '20091022' and Z37_END_REQUEST_DATE ^= 0;

    2. This SQL showed that there were not any type "B" or "T" requests, but that there were 341 z37's with z37_status "S":
    SQL> select z37_request_type, z37_status, count(*) from z37 where Z37_END_REQUEST_DATE < '20091022' and Z37_END_REQUEST_DATE ^= 0 group by z37_request_type, z37_status;
    Z Z COUNT(*)
    H A 141
    H S 341
    H W 22
    That left 141 status "A" and 22 status "W" requests which should have been deleted.

    3. This SQL showed the sublibraries connected to the requests for these items:
    SQL> select z30_sub_library, count(*) from z30, z37 where z37_status ^= 'S' and Z37_END_REQUEST_DATE < '20091022' and Z37_END_REQUEST_DATE ^= 0 and substr (z37_rec_key,1,15) = z30_rec_key group by z30_sub_library;
    Z30_S COUNT(*)
    BAFC 17
    BRES 15
    NIFA 109

    4. grep's for "p_sub_library" in the $alephe_scratch p_cir_17 logs showed that cir-17 was not being run for these sublibraries.
    >> grep p_sub_library *p_cir_17.*

    5. Required action: run these jobs for the sublibraries found by the grep
    a. Hold Shelf Report (cir-06)
    b. cir-17

    Additional Information

    * For non-Title hold, when the z37 hold request for an item by a patron is deleted, it should no longer appear under either the item or the patron.
    * cir-17 ignores requests with Z37_END_REQUEST_DATE = 0.
    * cir-17 does not process type "B" (Booking) requests. It processes H (regular Hold) and T (Title hold) requests. Also, it does not delete expired status "S" requests; as noted in KCS article 8192-2165 (Deletion of Hold Requests); they are deleted by the cir-06 job.

    Category: Circulation (500)

    Subject: Hold requests (500)


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • cir-16 job is slow
      • cir-20: Pickup location of request not valid for transit
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 21
      2. Circulation (500)
      3. contype:kba
      4. Hold requests (500)
      5. Prod:Aleph
      6. 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