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

    Hold requests disappear in large quantities

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

    Hold requests disappear in thousands at a time on our server:

    select substr(z37h_time,1,10), count(*) from z37h where Z37H_HOLD_DATE=0 and z37h_time>'200710010000000' group by substr(z37h_time,1,10) order by substr(z37h_time,1,10);

    SUBSTR(Z37H_TIME,1,12) COUNT(*)
    ------------------------------------ ----------
    200801161557 1674
    2007102914 3117

    The problem was caused by a member of staff running the delete multiple hold requests option from the menu bar --> requests --> hold requests.
    It was seen in the pc_server log by an entry for pc_cir_c0427:

    SERVICE : C0427
    MODULE : Circulation Services
    DESCRIPTION: Delete Hold Requests
    ACTION :
    PROGRAM : pc_cir_c0427

    Additional Information

    hold request disappear Delete

    • Article last edited: 10/8/2013