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