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. Can't create patron record: "unique constraint (xxxnn.Z353_ID) violated"

    Can't create patron record: "unique constraint (xxxnn.Z353_ID) violated"

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Aleph
    • Product Version: 16.02

    Description:
    I have added a new sublibrary in our Test instance and testing has shown that we cannot register new global patron records with the new sublibrary, CCWC entered as the Patron Sublibrary in the Patron Registration Form. The error returned on pressing Update is:

    Remote Service Error (c0463 21)
    Unable to find Global Patron information.

    The pc-server.log shows this:

    DESCRIPTION: Fast Patron Registration
    ACTION : NEW
    PROGRAM : pc_cir_c0468
    ...
    Oracle error: io_z353_write
    ORA-00001: unique constraint (ABC50.Z353_ID) violated

    Resolution:
    util a/17/14 for abc50 z303 shows that none of the three Oracle indexes are present.

    Enter Table Name : z303
    make_library_file_list: env file_list_size does not exists. Using data_root/file_list as is

    Defined in file_list:
    __________________________________________________________
    ! For IND z303_id* / z304_id* / z305_id* give 5M per 80000 users
    IND z303_id 10M 0K TS2X
    IND z303_id1 100K 0K TS1X
    IND z303_id3 20M 0K TS2X
    __________________________________________________________

    Exist in the Database:

    Enter CR to continue...

    You need to do util a/17/2 to create them. (The z303_id_1 and z303_id_2, which are NONUNIQUE, should be OK, but the z303_rec_key *could* have duplicates which might prevent the z303_id from being built. If that is the case, then use util a/17/18 to locate the duplicates and build the unique index. KB 8192-424 describes how to use util a/17/18.)

    Additional Information

    faq


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Can't create invoice; "memory could not be read."
      • Can't delete a course even though no items are linked to it
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 16.02
      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