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

Description:
hold requests not printing notice or slip or putting item on hold shelf

Resolution:
I checked your z37 table of ABC50 library and I found the following related to the Send Action field:

abc50@ALEPH18> select count(*),z37_send_action from z37 group by z37_send_action;
COUNT(*) Z37_SEND_ACTION
---------- ---------------
133 1
21 6
17 0

As you can see, there are 17 hold request records with send action = 00 (which is not a valid one). You could fix these 17 records via SQL as following:
update z37 set Z37_SEND_ACTION = 01 where Z37_SEND_ACTION = 00;

[Later:]
It looks to me that the problem is solved. I checked your z37 table and there is no more z37_send_action = 00. Here is the query that I just run:

abc50@ALEPH18> select count(*),z37_send_action from z37 group by z37_send_action;
COUNT(*) Z37_SEND_ACTION
---------- ---------------
144 1
18 6

• Article last edited: 10/8/2013