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

    Oracle error: io_z110_write ... unique constraint (VIR01.Z110_ID) violated

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

    Description:
    www_server log shows 1834 occurrences of this error:
    Oracle error: io_z110_write
    ORA-00001: unique constraint (VIR01.Z110_ID) violated

    >>grep -c 'unique constraint (VIR01.Z110_ID) violated' www_server_14600.log
    1834

    Resolution:
    This error occurs because the Z110-NUMBER (the first 6 digits of z110_rec_key) has reached 999999:

    SQL-VIR01> select max (z110_rec_key) from z110;
    MAX(Z110_
    ---------
    999999001

    The routine which is supposed to reinitialize the Z110 is clear_vir01.

    Running clear_vir01 corrected this problem.

    clear_vir01 needs to be run with greater frequency.

    Additional Information

    faq


    • Article last edited: 10/8/2013