Skip to main content
ExLibris
  • Subscribe by RSS
  • ExLibris Dev

    Course Catalog New: "Unable to create bib record"

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

    Description:
    When we select a particular course in the GUI Circ List of Courses, select "Course Doc List", click on Catalog New, fill in the bib and item screens, and then click "OK", we get the error message "Unable to create bib record".

    Resolution:
    The message "Unable to create bib record" is message 0034 in pc_cir_c0402. It is produced when, after writing the record ("update_docx") the program attempts to read the record ("get_buf_docx") and gets a non-zero return code.

    Looking in the pc_server log, I see the following message:

    Oracle error: io_z00_write
    ORA-00001: unique constraint (ABC30.Z00_ID) violated

    SQL showed these existing abc30 doc records:

    abc30@ALEPH20> select z00_doc_number from z00;
    **** Hit return to continue ****

    Z00_DOC_N
    ---------
    007339496
    007339397
    007339595
    007339389

    000000002
    000000004

    but abc30 util g/2 showed:

    last-doc-number 0

    I used the util g/2 update-function to change this to

    last-doc-number 5

    After doing this, I was able to successfully create an abc30 doc record with the Catalog New button.


    • Article last edited: 10/8/2013
    //doorbell.io feedback widged