p_file_20: z308-rec-key does not exist ; Can not upd/del; Login does not exist

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

Description:
p_file_20 doesn't add the patrons it should. Andrew Mmmmm and Jingyu Wwwwww should both have been loaded in last night's loads, but neither of them loaded.

Resolution:
Looking at the abc50 $data_scratch/p_file_20_report file, we see the errors for the patrons you mention. (See below.)

* Error 5016 ("Cannot update/delete record. Login does not exist") is issued by the b_file_20_chk_edit_record program when the ACTION = "U" AND SW-FOUND-MATCH-Z308 = "N".

* Error 5010 ("Can not upd/del z303. No match found.") is issued by the b_file_20_chk_edit_record program when the ACTION = "U" AND SW-FOUND-MATCH-Z304 = "N".

And we see "z308-rec-key does not exist" errors in the $alephe_scratch/abc50_p_file_20.nnnn job log. (See further below.)

These errors all have the same cause: the PLIF input record has "U" as the User Rec "Action" (the first byte) when, in fact, it is a *new* record. A new record can not have "U". It needs to have "I" (Insert) or "A" (Add). "A" is the most flexible: if the user exists, it is changed to "U" and the update occurs; if the user does not exist, it is changed to "I" and the insert occurs.

**You need to change the User Rec "Action" for these patrons to "A" (or "I").**

-------------------------------
Errors in p_file_20_report file:
-------------------------------

+ <line-number>000009</line-number> <---- input record 000009
+ <table-name>z308</table-name>
+ <action>REWRITE</action>
+ <match-id>0121006823910106</match-id>
+ <user-name>Mmmmm, Andrew </user-name>
+ <patron-id></patron-id>
+ <msg-code>5016</msg-code>
+ <msg-desc>Cannot update/delete record. Login does not exist</msg-desc>
...
...
+ <line-number>000029</line-number> <---- input record 000029
+ <table-name>z303</table-name>
+ <action>REWRITE</action>
+ <match-id>0121016789460103</match-id>
+ <user-name>Wwwwww, Jingyu</user-name>
+ <patron-id></patron-id>
+ <msg-code>5010</msg-code>
+ <msg-desc>Can not upd/del z303. No match found.</msg-desc>
<etc.>


----------------------------
Errors in abc50_p_file_20.nnnn job log:
----------------------------

Error (b_file_20_chk_edit_record) : Errors in Z303. Record No 000009 <-----
Can not update/delete. No match found.

Error (b_file_20_chk_edit_record) :
Record No 000009
z308-rec-key does not exist (0121006823910106 )

Error (b_file_20_chk_edit_record) : Errors in Z305. Record No 000009
Can not update/delete. No match found.

Error (b_file_20_chk_edit_record) : Errors in Z303. Record No 000029 <-----
Can not update/delete. No match found.

Error (b_file_20_chk_edit_record) :
Record No 000029
z308-rec-key does not exist (0121016789460103 )

Error (b_file_20_chk_edit_record) : Errors in Z305. Record No 000029
Can not update/delete. No match found.

<etc.>


The lack of these patrons in the current z303 file is confirmed by these SQLs:

pwd50@MALC20> select z303_rec_key from z303 where z303_name = 'Mmmmm, Andrew';
no rows selected

pwd50@MALC20> select z303_rec_key from z303 where z303_name = 'Wwwwww, Jingyu';
no rows selected

• Article last edited: 10/8/2013