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

Description:
When certain patrons do Renew-All in the OPAC they get: "Renew failed" at the top of the screen and "Renew not allowed" for each individual item.

Resolution:
Renew not allowed" is message 0370 in ./error_eng/www_f_heading.

It is issued by the www_f_bor_loan_exp program when it calls check_circ and gets a non-zero return code.

The specific check which was causing the error in this case was check_circ_8_b:

! 8_b: check renew - overdue letter
! check if an overdue letter has been printed for the loaned item


The check_circ_8_b program has the following logic:

IF Z36-LETTER-DATE NOT = ZERO OR
Z36-LETTER-NUMBER > ZERO
THEN
CALL "add_error" USING
...

In this case, an SQL update had caused overdue notices to be issued incorrectly. Though the z36_letter_number was set back to zero; the z36_letter_date was set back two weeks when, since z36_letter_number is 00, it should have been set to '00000000'. Updating the z36_letter_date to 00000000 allowed the items to be renewed.

• Article last edited: 10/8/2013