Skip to main content
ExLibris
  • Subscribe by RSS
    • Back
    Aleph
    Ex Libris Knowledge Center

    p_cir_51: io_sequence_next, z31 unique constraint, Error reading Z100, etc.

    1. Last updated
    2. Save as PDF
    • 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