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

Description:
p_cir_51 is a job run daily/automatically from the job_list to produce overdue notices and Lost item bills.

There was an errant abc50 p_cir_51 (for Lost bills) launched on May 23. In the meantime the p_cir_51's for abc50 and the other ADM's have continued to be launched and to perform correctly.

The job had produced a 2.4 gig log in $alephe_scratch:

-rw-rw-r-- 1 aleph exlibris 2495914473 Jun 9 10:17 abc50_p_cir_51.01338

with the following error messages:

Oracle error: io_sequence_next
ORA-00942: table or view does not exist

Oracle error: io_z31_write
ORA-00001: unique constraint (abc50.Z31_ID) violated

Error reading Z100 in usr_library
Z100-REC-KEY:

(The latter is repeated several thousand times.)

Resolution:
I killed the processes for this abc50 job. After which, the p_cir_51 for xyz50 ran successfully

• Article last edited: 10/8/2013