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

    p_file_20: "Login record belongs to other patron"

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

    Description:
    p_file_20 loads most of the 2700+ patrons load correctly as updates, but none of the Inserts work. We see these messages in the $data_scratch p_file_20_report file:

    check_z308 routine failed. Can not ins/upd record. cur-id 000006837
    ...
    Cannot update/delete record. Login record belongs to other patron

    And, in $alephe_scratch/abc50_p_file_20.01016:

    Error (b_file_20_chk_edit_record) :
    Record No 000013
    z308-rec-key belongs to other user (01210212300271997 )

    Resolution:
    As described in KB 8192-2035, the message "Login record belongs to other patron" is associated with the case where one of the ID's is in use by another patron. This SQL shows that barcode 210212300271997 (for John Smith) is in use by patron ABU-00003997:

    abc00@ALEPH18> select * from z308 where z308_rec_key like '%210212300271997%';
    **** Hit return to continue ****

    Z308_REC_KEY Z308_VERIFICATION Z3
    --------------------------- ---------------------------------------- --
    Z308_ID Z3 Z
    ------------ -- -
    01210212300271997 210212300271997 00
    AMH-00003997 AC N

    We see that ABU-00003997 is an existing record for John Smith:

    02 z303_rec_key \
    03 id ........................ABU-00003997
    02 z303_proxy_for_id ...........
    02 z303_primary_id .............
    02 z303_name_key ...............John Smith AM
    02 z303_user_type ..............
    02 z303_user_library ...........
    02 z303_open_date ..............20060310
    02 z303_update_date ............20060526


    The reason that the system doesn't find a match on this existing record is that the type '02' match-ID is not CAC000152051, as you have specified in the input file, but rather AM-UID-00668.

    Since the z308 type '02' records, which are supposed to have the University ID, seem to sometimes have other values, site will use the barcode (z308, type '01') as the match point in the PLIF (MATCH-ID-TYPE and MATCH-ID) instead of the type '02'.


    • Article last edited: 10/8/2013