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

    item_stat_code_code_idx not unique after upgrade

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Voyager
    • Product Version: 8.1.2

    Problem Symptoms:
    * Upgrade engineer reported that index item_stat_code_code_idx could not be created as a unique index on the item_stat_code table after upgrade.

    Cause:
    Item statistical category codes are not unique.

    Resolution:
    1. Give each item statistical category a unique code.
    a. Log into System Administration.
    b. Navigate to System > Statistical Categories > Item tab.
    c. Highlight one of the categories and click Edit.
    d. Edit the code to be a unique 3-character code.
    e. Save.
    2. Repeat steps 3-5 until all categories have unique codes.
    3. Open an incident with Voyager Support to have item_stat_code_code_idx rebuilt as a unique index.

    Category: Oracle

    • Article last edited: 10/8/2013