Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. oracle_imp_aleph_libs: unique constraint (ABC01.IOT_Z127) violated

    oracle_imp_aleph_libs: unique constraint (ABC01.IOT_Z127) violated

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 17.01

    Description:
    We are seeing thousands of occurrances of the following error in running the oracle_imp_aleph_libs to import our v17 data onto our new v20 server:

    IMP-00019: row rejected due to ORACLE error 1
    IMP-00003: ORACLE error 1 encountered
    ORA-00001: unique constraint (ABC01.IOT_Z127) violated

    Resolution:
    The z120 and z127 are the Union View tables. Since the abc01 tab100 has "UNION-LIBRARY=0", you are not using either Union Catalog or Union View and neither the z120 or the z127 is actually used.

    As can be seen at the end of the $TMPDIR/oracle_imp_aleph_libs.log.32081, the oracle_imp_aleph_libs is continuing to run (successfully): there is no indication of any error except the z127.

    Since you are not using the z120 or z127, they are just taking unnecessary space, and I think the simplest way to prevent these error messages in future imports is to delete them (anytime) prior to doing the export.

    Note: If you *are* using Union View or Union Catalog, you can rebuild the z127 by running $aleph_proc/create_z127 after the import is done.


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • oracle_imp_aleph_libs loading of the z980 takes too long.
      • oracle_imp_aleph_libs: "...export.gz_aa or ...data.export.gz_aa do not exist"
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 17.01
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved