p_cir_51: io_sequence_next, z31 unique constraint, Error reading Z100, etc.
- 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