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

Description:
We have a patron, Bill Moller, who is not loading into Aleph. We're getting the following error when trying to both update a record and add a new record: "Cannot update/delete record. Login record belongs to other patron". However, I can't find the patron's info anywhere in Aleph or in the database itself.

His ID is 80033672 and barcode is 60000001040440. In the p_file_20_report, one section has a patron ID of MLC900003872, the other has no patron ID (I believe one is the "update" attempt and the other is the "add" attempt). The last load only consisted of 14 patrons (including Bill), and the other 13 seem to load fine.

Resolution:
This is similar to KB 8192-7559. We see in the hcc50 p_file_20_report that the "Login record belongs to other patron" occurs for the third z308 / ID record (though the ID is not shown).

Using the hcc50 util f/2/5/1 utility to parse the input record, we see this for Bill Moller:

USER-KEY-REC # 01
ACTION............. I
KEY................
TYPE............. 01
LOGIN............ 60000001040440
VERIFICATION....... xxxxx
VERIFICATION-TYPE.. 00
STATUS............. AC
ENCRYPTION......... Y

USER-KEY-REC # 02
ACTION............. I
KEY................
TYPE............. 02
LOGIN............ 60000001040440
VERIFICATION....... xxxxx
VERIFICATION-TYPE.. 00
STATUS............. AC
ENCRYPTION......... Y

USER-KEY-REC # 03
ACTION............. I
KEY................
TYPE............. 03
LOGIN............ HCC800033672 <---------------------
VERIFICATION....... xxxxxxxxxxxxxx
VERIFICATION-TYPE.. 00
STATUS............. AC
ENCRYPTION......... Y


util f/4 shows us that 03HCC800033672 belongs to patron MLC900003772:
enter start Z308 key (YYXXXXXXXXXXXXXXXXXXXX)
03HCC800033672

01 z308 \
02 z308_rec_key \
03 key_type ...............03
03 key_data ...............HCC800033672
03 user_library ...........
02 z308_verification ........800033672
02 z308_verification_type ...00
02 z308_id ..................MLC900003772


and ID MLC900003772 is Amanda K. Moller:

02 z303_rec_key \
03 id ........................MLC900003772
02 z303_proxy_for_id ...........
02 z303_primary_id .............
02 z303_name_key ...............moller amanda k ML
02 z303_user_type ..............
02 z303_user_library ...........
02 z303_open_date ..............20081010
02 z303_update_date ............20090423
02 z303_con_lng ................ENG
02 z303_alpha ..................L
02 z303_name ...................Moller, Amanda K.

Jerry

• Article last edited: 10/8/2013