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

Description:
We would like to exclude two borrower statuses when generating patron courtesy notices via p-cir-10. If we specify "setenv p_bor_status_yes_no "N"" and setenv p_bor_status_filter "81 82" we get the following execution error:

Execution error : file '/exlibris/aleph/a18_1/aleph/exe/date_x_n.gnt'
error code: 114, pc=0, call=1, seg=0
114 Attempt to access item beyond bounds of memory (Signal 11)

Job Paramenters (from /exlibris/aleph/u18_1/alephe/scratch/xxx50_p_cir_10.00892):
Fixed param: XXX50,divtest,N,81 82,Y,,002,00,N,1,N,N,3,01,
setenv p_active_library "XXX50"
setenv p_file_out "divtest"
setenv p_bor_status_yes_no "N"
setenv p_bor_status_filter "81 82"
setenv p_item_status_yes_no "Y"
setenv p_sub_library ""
setenv p_days_before_due "002"
setenv p_form_number "00"
setenv p_auto_renew "N"
setenv p_filter_type "1"
setenv p_update_no_renewal "N"
setenv p_email_only "N"
setenv p_letter_type "3"
setenv p_item_status_filter "01"

Can you tell us if there is another way to exlude two patron statuses when generating these notices?

Resolution:
The date_x_n.gnt error is generally caused by a date being zero when the program expects a non-zero. Perhaps when "except bor_status 81 or 82" is specified, a loan record is being processed which is not otherwise processed.

Try the following basic SQL check (the results for both statements should be "no rows selected"):

select z36_rec_key from z36 where z36_due_date = '00000000';
select z36_rec_key from z36 where z36_due_date is null;