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

Description:
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

Resolution:
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