Patron has exceeded number of hold requests allowed" placing hold on new item

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

Description:
After our v20 upgrade, we found when attempting to place holds on items with item process statuses "on order" (OA) or "order initiated" (OI), we would get the following error in the browser: "Patron has exceeded number of hold requests allowed." Even though it is our intention that holds on items with these statuses should be permitted and tab16 is set properly for this. It is only new items, generated from the order record, which have this problem.

Resolution:
Looking at item 001767233-10, I see that the item status and material type are both blank:

02 z30_sub_library .............TML
02 z30_material ................
02 z30_item_status .............

These are required fields; they can not be blank.

This SQL shows that there are 3,800 such cases:

SQL> select z30_sub_library, count(*) from z30 where z30_item_status is null and z30_material is null group by z30_sub_library;

Z30_S COUNT(*)
----- ----------
CHEC 31
INET 8
JBCL 2853
MRS 500
TML 411


I suggest that you check these. Ideally, you will be able to decide on appropriate values for these fields. Presumably, in the case of TML, 02 and BOOKP, and then use SQL to update the records.

As to why this is happening.... This is the vcu50 tab36:

! 1 2 3 4 5 6 7
!!!!!-!!-!!-!!!!!-!!!!!-!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!-!
JBCL 02 BOOKP GEN
TML 02 BOOKP GEN
CHEC 01 BOOKP GEN
ABCL 11 BOOKP ADMN
MRS 10 FIVI CDDVD
INET 03 BOOKE GEN
MCRC 01 BOOKP GEN
WHRC 01 BOOKP GEN

As you can see, column 2 (the order material filter) is blank. This is incorrect. If you look at the distributed usm50 tab36, you will see that column 2 is *always* populated.

The current value of blank says that, if the z68_material_type is blank, then use these item status, material, and collection values. But z68_material_type is *never* blank, thus, the fields are left blank in the resulting z30 record.

What you need to do is put "##" in column 2 on each of the lines. (And then restart the pc_server.)

• Article last edited: 5/27/2014