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

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

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

    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

    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.)

    Additional Information

     See Article 000036574  (Which tables are index, temporary, and base tables?)  in regard to which tables are corpus/base tables and which are index. 

    For a more common cause of this problem, see Article 000040359 (User name XXX does not exist" accessing local libraries ).

    Category: System management

    • Article last edited: 2/11/2015