Slow response in RESTful API when patrons have many loans
- Article Type: General
- Product: Aleph
- Product Version: 18.01
Description:
For Patrons with large number of loans it is not possible to see list of loans in Primo.
Instead the following error is shown:
"We're sorry, but an unrecoverable problem was detected trying to call the ILS system. Try again later."
Resolution:
When calling up a list of loans via API, section RENEW-WWW from tab_check_circ is performed for every loan.
In this case we see that you use check_circ_1_d and check_circ_9_a in RENEW-WWW:
RENEW-WWW check_circ_1_d
RENEW-WWW check_circ_9_a
These procedures do *NOT* cause performance problems when performed for a single loan (in Aleph OPAC) but they cause performance problems when performed for all loans of patron (in Primo API). Another problematic routine might be check_circ_10_a. In our tests we did not see performance problems with check_circ_9_b and check_circ_10_b.
Therefore we remove these sections from RENEW-WWW-section in tab_check_circ.
For checking overdue loans check_circ_8_b might be used instead. For checking the cash limit you may use check_circ_5 instead.
- Article last edited: 10/8/2013