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.)