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

    Oracle error: io_z01_write; unique constraint (ABC60.Z01_ID2) violated

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

    I find these errors in the abc60 $data_scratch/ue_01 log:
    Oracle error: io_z01_write
    ORA-00001: unique constraint (ABC60.Z01_ID2) violated

    The abc60 util g/2 had: last-acc-number 232429
    while sql showed:
    SQL-ABC60> select max (Z01_ACC_SEQUENCE) from z01;

    Therefore, I corrected last-acc-number to be 1469828.

    After doing this, the doc records which were sent to the server during the time that the last-acc-number was incorrect will need to be re-sent to the server. You can do this by running p_ret_01 to locate records updated today and using its output as input to p_manage_40. p_manage_40 will produce a z07 indexing request record for each record# in the input file. These z07's will then be processed by ue_01.

    KEYWORDS: UTIL-G-2 p-manage-40 manage-40 manage_40

    Additional Information


    • Article last edited: 10/8/2013