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

    p_manage_01 in parallel: Z95_ID: "name is already used by an existing object"

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 16.02

    Description:
    Running a parallel indexing p_manage_01, we see the following message in the $aleph_scratch p_manage_01 log:

    SQL-ALEPH_ADMIN> 14:21:23 SQL-ALEPH_ADMIN> CREATE UNIQUE INDEX ABC07.Z95_ID ON ABC07.Z95 (Z95_DOC_NUMBER ASC)
    *
    ERROR at line 1:
    ORA-00955: name is already used by an existing object


    This message in the $data_scratch z95_dmp_ora.log.5:

    Record 1: Rejected - Error on table ABC07.Z95.
    ORA-00001: unique constraint (ABC07.Z95_ID) violated

    And there is a z95.bad file in $data_scratch which has a non-zero length. (It should be zero.)

    Resolution:
    I see that you have these lines in the ABC07 file_list:

    LS z95 ABC02
    LS z97 ABC02
    LS z970 ABC02
    LS z98 ABC02
    LS z980 ABC02

    If you are running p_manage_01 to regenerate the Z9n files for ABC07, then the Z9n tables and indexes need to be defined in the ABC07 file_list -- not LS'ed.

    • Article last edited: 10/8/2013