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

    p_file_20: "check_z308_duplicate routine failed. Can not ins/upd record."

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

    Description:
    The p_file_20 report file in the xxx50 $data_scratch has this message:

    check_z308_duplicate routine failed. Can not ins/upd record.

    And the $alephe_scratch p_file_20 job log has the error: "Duplicates in Z308 Record nnnnnn"

    Why?

    Resolution:
    These messages occur when the program finds that the Z308-KEY-DATA + Z308-USER-LIBRARY (bytes 3 to 27 of the z308_rec_key) duplicates the Z308-KEY-DATA + Z308-USER-LIBRARY of a different patron's Z308.

    The ./check_record/check_z308_duplicate program, called by b_file_20_chk_edit_record, wants the Z308-KEY-DATA + Z308-USER-LIBRARY to be unique across all ID types (-- unless it's for the same patron/z303_rec_key/z308_id). See KB 16384-41025 for complete description of logic.

    There can be two reasons for this duplication:

    (1) If the z308 is one being generated by the system (always, the type 00 system patron ID and, sometimes, the type 01 barcode), this is due to the xxx50 util g/2 last-bor-id or last-bor-id-1 being set too low. The former needs to be higher than any existing z308 type 00 and the latter needs to be higher than any existing type 01 system-generated patron barcode.

    (2) The ID which the operator is entering in or which in p_file_20 is trying to add is already being used as an ID in a *different* patron's record.

    The $data_scratch/p_file_20_report should be useful: it will show you *which* ID is getting the "Duplicates in Z308 Record nnnnnn" error message .


    • Article last edited: 10/8/2013