CIRC:db error if hold shelf expiration date not in calendar
- Product: Voyager
- Product Version: 7.0.1
- Relevant for Installation Type: Total Care; Dedicated-Direct; Direct; Local
Symptoms
- Item fulfills a request discharged to the hold shelf at pickup location and calculated hold shelf life falls on a date that isn’t included in any calendars selected in the Circ Policy Definition
- Circulation gives message: “An error occurred while attempting to process discharge request" rather than message indicating calendar issue
Defect Status
Issue 16384-9473 / VYG-1438 is resolved for Voyager 8.2.1 and higher.
Replication Steps
- System Administration > Circulation > Calendars > create 2 calendars with gap between effective dates.
- System Administration > Circulation > Policy Definitions > {policy for discharge location > Edit > Calendars > use calendars from step 1
- In Matrix tab, check that hold shelf life will fall into gap for patron group and item type for request.
- Place hold for patron from patron group on item with item type from step 3.
- Discharge the item to hold shelf.
Error in client: “An error occurred while attempting to process discharge request.”
Errors in log.voyager:
circsvr[10652] - ERROR - Tue Jan 19 16:30:52 2010
- calcHoldShelfLifeExpireDate - req_sql__ppc.cxx[12688]
IgnoreClosedDaysforLoan() failed for
currDate :
expDate : 2010-01-24 23:59:00
circsvr[10652] - ERROR - Tue Jan 19 16:30:52 2010
- SQL_FulfillHRRequest - req_sql__ppc.cxx[1707]
calcHoldShelfLifeExpireDate() failed
circsvr[10652] - ERROR - Tue Jan 19 16:30:52 2010
- FulfillHoldRecallRequest - req_sql__ppc.cxx[1624]
SQL_FulfillHRRequest() failed
circsvr[10652] - ERROR - Tue Jan 19 16:30:52 2010
- itemArrivedEndRouting - trns_sql__ppc.cxx[6435]
FulfillHoldRecallRequest() failed
Workaround
Update calendar start and end dates to cover gap and date of calculated hold shelf expiration.
- Article last edited: 11-Jun-2015