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. manage-33: "unique constraint (XXX01.Z13_ID) violated"

    manage-33: "unique constraint (XXX01.Z13_ID) 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: 20

    Problem Symptoms:
    The $alephe_scratch/xxx01_p_manage_33 log, produced by the manage-33 ("Delete Bibliographic Records Including Related ADM/HOL Records") service has the following error:

    Oracle error: io_z13_write
    ORA-00001: unique constraint (XXX01.Z13_ID) violated

    Cause:
    Each occurrence of the message indicates a single z13 (Short bibliographic record) which the program tried to write which already existed. (This could happen when the bib record was, for instance, deleted in the GUI prior to running p_manage_33.)

    Resolution:
    Since all the records have been deleted, manage-18 ("Load ALEPH Sequential MARC Records") can be run with the same parameters as it was previously (including p_old_new "NEW") and new xxx01 bib records should be created.

    {The stub records from this abortive load will still be out there, but, as are (logically) deleted, they will not have any effect on the functionality of the system.}

    Category: Cataloging (500)

    Subject: Importing records (500)


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • manage-33: I/O error : ... "File not found"
      • manage-35; Headings indexing sequence
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. Cataloging (500)
      3. contype:kba
      4. Importing records (500)
      5. Prod:Aleph
      6. 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