Skip to main content
ExLibris

Knowledge Assistant

BETA
  • Subscribe by RSS
  • Back
    DigiTool

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. DigiTool
    3. Knowledge Articles
    4. Getting Oracle error: io_z312p_write/ORA-00001: unique constraint violated messa

    Getting Oracle error: io_z312p_write/ORA-00001: unique constraint violated messa

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: DigiTool
    • Product Version: 3

    Description:
    I am not able to create a patron record from the Registration tab in MySPace in RD.
    I complete all of the mandatory fields and click Submit, but I get "Action failed, please try later."
    The www_server log reports the following:

    Oracle error: io_z312p_write
    ORA-00001: unique constraint (D31_DAT01.Z312P_ID) violated

    Error [io_z312p]: Unable to write record PATRON1024 ?•x*??k
    ?“k+?³k??Sk?????????????????????

    Resolution:
    According to the log you provided, the system was trying to register PATRON1024.
    The system was trying to register new users with IDs that already existed.
    Perhaps someone updated z312 using the util?
    If not, you should try to find out how they have been adding/removing patrons.
    To resolve: use util g/2 to set the z312-bor-id to a higher value (say 1060).


    >>dlib dat01
    >>util g/2
    ...
    9. z312-bor-id 1060 y S

    Additional Information

    io_z312p_write, ORA-00001, patron, myspace, Resource Discovery


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Full text search results
      • Google Scholar Integration in Digitool
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Content Type
      Knowledge Article
      Language
      English
      Product
      DigiTool
    2. Tags
      1. 3
      2. contype:kba
      3. Prod:DigiTool
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved