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

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

     

    • Product: Aleph
    • Product Version: 20, 21, 22, 23
    • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

     

    I

    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:

    We see 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.

    Additional Info

     

     


    • Article last edited: 22-Feb-2016