p_serial_04 not finding issues to be claimed

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

Description:
The Serial Claims report (serial-04) is very small, and we don't know why. It does not include some items whose Expected Arrival Dates have passed.

We did *not* see this problem in v14.2; only since we have gone to v16.02.

Why is this happening?

Resolution:
The job logs had this error in them:

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

We found that it was bombing when it found a z20 (claim record) with a z20_claim_date of '00000000' and, using this SQL, that there were 10 such cases:

SQL-xxx50> select z20_rec_key from z20 where z20_claim_date = '00000000' order by z20_rec_key;

You need to delete these or put a date in them.

We believe that these zero-date z20's will not be produced under v16.02-up and that, therefore, this one-time clean-up should take care of the problem.