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

    Remote Service Error (C0407 list 98) displaying patron loan list

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

    Description:
    When looking up one of our transfer patrons (B6 - BES Library for Transfers) We're getting the following error: Remote Service Error (C0407 list 98) when trying to look at the loan list. The node indicates that there are 193 items loaned to this patron. But the server times out after 60 seconds when trying to view the list.

    What might be causing this and how can I fix it?

    Resolution:
    Case #1: Over 100 of the loans for patron B6 are for bib record 000166271. The items for the bib rec 000166271 have 157 holds (157 z37's). This is the only ADM with more than 70 holds:

    SQL> select substr (z37_rec_key,1,9), count(*) from z37 group by substr (z37_rec_key,1,9) having count(*) > 70;

    SUBSTR(Z37_REC_KEY,1,9) COUNT(*)
    --------------------------------------------------------- ----------
    000166271 157

    I found, adding diagnostics to the program (pc_cir_c0407) which builds the loan list, that the delay is in EDIT-COL-26 which CALLs "get_hold_queue_pos".

    From site: We will investigate why there are so many requests. On first glance, it looks like it's a serial that has items in the LSC (our depository), and that individual items are being requested for use.

    Case #2: In another case, this error was caused by a bad tab17 entry. Specifically: "AV ####0606 O 0830 v". That is "V" where there should have been a time, such as "1800". This caused grossly erroneous due dates to be generated.


    • Article last edited: 6/18/2014