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

    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

    1. System Administration > Circulation > Calendars > create 2 calendars with gap between effective dates.
    2. System Administration > Circulation > Policy Definitions > {policy for discharge location > Edit > Calendars > use calendars from step 1
    3. In Matrix tab, check that hold shelf life will fall into gap for patron group and item type for request.
    4. Place hold for patron from patron group on item with item type from step 3.
    5. 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