• 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