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

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

    • 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