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. Error for z101_id opening new library: "Such column list already indexed"

    Error for z101_id opening new library: "Such column list already indexed"

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

    Description:
    I need to know if this ORA error that appeared in the LOG when I opened up a new library is an issue?

    Elapsed: 00:00:00.01
    15:29:55 SQL-ALEPH_ADMIN> CREATE UNIQUE INDEX ODN07.Z101_ID ON ABC07.Z101 (Z101_REC_KEY ASC)
    *
    ERROR at line 1:
    ORA-01408: such column list already indexed

    Resolution:
    I find that when I do util a/17/4 for the z101_id it says that it is not managed by abc07, but when I try util a/17/2 to create the z101_id, I get the "Such column list already indexed" message which you describe.

    But doing util a/17/14 for abc07, I find the following:

    Enter Table Name : z101

    Defined in file_list:
    __________________________________________________________
    IND z101_id 128M 0K TS3X
    __________________________________________________________

    Exist in the Database:

    INDEX_NAME STATUS INDEX_TYPE UNIQUENESS COLUMN_NAME
    --------------- ------- ---------- ----------- --------------------
    IOT_Z101 VALID IOT - TOP UNIQUE Z101_REC_KEY

    Note that the name of the index is not "Z101_ID" but rather "IOT_Z101". This has to do with the fact that the $alephm_root/sql_tab/z101_create.sql on your server contains the following line:

    CONSTRAINT IOT_Z101 PRIMARY KEY

    (This site seems to be the only one with this line in z101_create.sql.)


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • error_eng variable in aleph_start
      • Error in aleph_shutdown: "Warning (tab_library_group): Invalid library in tab_library_group"
    • 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