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

    z63: unique constraint violated; user VIR01 lacks CREATE SESSION privilege

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

    Description:
    We see this message in the log:.
    Oracle error: io_z63_write.
    ORA-00001: unique constraint (VIR01.Z63_ID) violated.
    I found that the vir01 UTIL-G-2 was empty: no vir01 z52.
    I ran clear_vir01 after first enabling error-logging and we see this message in the init z52 section of the clear_vir01 log:.
    ORA-01045: user VIR01 lacks CREATE SESSION privilege; logon denied

    Resolution:
    Corrected by giving user VIR01 CREATE SESSION privilege..


    • Article last edited: 10/8/2013