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

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

    • 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
    //Feedback