Skip to main content
ExLibris
  • Subscribe by RSS
  • ExLibris Dev

    Can't log in with staff user

     

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

     

    Problem Symptoms:
    Since a couple of days we can't log in to our aleph system with staff user ABCD. 
    We receive an error "User name ABCD does not exist". User is displayed in staff privileges window, but when we try to modify user or change access rights we have an "Admin user does not exist" error. 
    We receive the same error if we try to modify ALEPH superuser.

     

    Cause:
    Missing Oracle indexes for table z66 in password library

     

    Resolution:
    Index z66_id and z66_id1 are missing (no entries in 'Exist in Database') when using util a/17/14 List Existing Indexes for a Table for table z66.

    Example for util a/17/14 List Existing Indexes for a Table

    Enter Table Name : z66

    Defined in file_list:
    __________________________________________________________
    IND z66_id 128K 0K TS1X
    IND z66_id1 128K 0K TS1X
    __________________________________________________________

    Exist in the Database:

    Enter CR to continue...

    1. Before you are able to re-create the Oracle indexes you will have to delete the duplicate staff user entries, because index z66_id is built from the z66_rec_key and needs to be unique.

    Example
    usr00@ALEPH20> select z66_rec_key from z66

    **** Hit return to continue ****

    Z66_REC_KE
    ----------
    ALEPH
    ALEPH
    ALEPH
    ALEPH
    ALEPH
    ALEPH
    ALEPH
    ALEPH
    ALEPH
    ABCD

    2. As soon as there are no duplicates, you can run 
    util a/17/2 to create the indexes

    3. Check for correct definitions (util a/17/14) after the creation. They should look like this:

    [...]
    Exist in the Database:

    INDEX_NAME STATUS INDEX_TYPE UNIQUENESS COLUMN_NAME
    --------------- ------- ---------- ----------- --------------------
    Z66_ID VALID NORMAL UNIQUE Z66_REC_KEY
    Z66_ID1 VALID NORMAL NONUNIQUE Z66_FUNCTION_PROXY

     

     

     


    • Article last edited: 17-Jun-2016
    //doorbell.io feedback widged