User name xxxx does not exist"; unique constraint ... violated

• Article Type: General
• Product: Aleph
• Product Version: 20

Description:
We are getting a "User name xxxx does not exist" message trying to log on to the GUI for certain users which *do* (as seen in util f/4) have z66 records. If we try to delete and re-add such a user, we get an error in trying to assign Functions for this user for a library (any library) in the Staff Privileges -- Access Rights .
And we see this in the pc_server log:
Oracle error: io_z67_write
ORA-00001: unique constraint (ABC50.Z67_ID) violated

Resolution:
Doing util a/17/4 (to drop the Oracle indexes) for the $pw_library z66 and z67 tables followed by util a/17/2 (to create them) corrected this problem.
If it doesn't, then do: p_file_03 (to export) and p_file_04 (specifying "replace") (to re-import them).

Note: The approach described above is appropriate when the table is a corpus/base table. If the table involved is an ALEPH Index table (such as Z01, z97, etc.), then this technique is not usually appropriate. (Instead, you should check the counters in util g/2 controlling index number assignment.)