p_file_20: Unable to process record ... check_z305 routine failed.

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

Description:
We recently began using Banner as our college system of record, including PLIF.

I've been modifying the setting to try and get it to work but keep getting "Unable to process record due to problems in other records."

Here is the first record from the report file. The match-id number in the Banner form is supposed to be 16-BannerPIDM... I don't know what 251775 is but it's not the Banner Id for this student as you see in the entry from the lis file.

Report File:

## - XML_XSL
<?xml version="1.0"?>
<printout>
<form-name>patron-loader</form-name>
<form-language>ENG</form-language>
<form-format>00</form-format>
<subject>Patron Loader</subject>

<section-01>
<form-date>06/03/2008</form-date>
</section-01>
<section-02>
<line-number>000001</line-number>
<table-name>z303</table-name>
<action>WRITE</action>
<match-id>16251775</match-id>
<user-name>Axxxxxx</user-name>
<patron-id>ABC62848</patron-id>
<msg-code>5003</msg-code>
<msg-desc>Unable to process record due to problems in other records.</msg-desc>
</section-02>
<section-02>
<line-number>000001</line-number>
<table-name>z308</table-name>
<action>WRITE</action>
<match-id>16251775</match-id>
<user-name>xxxxx, Kelly</user-name>
<patron-id>ABC62848</patron-id>
<msg-code>5003</msg-code>
<msg-desc>Unable to process record due to problems in other records.</msg-desc>
</section-02>
<section-02>
<line-number>000001</line-number>
<table-name>z308</table-name>
<action>WRITE</action>
<match-id>16251775</match-id>
<user-name>xxxxx, Kelly</user-name>
<patron-id>ABC62848</patron-id>
<msg-code>5003</msg-code>
<msg-desc>Unable to process record due to problems in other records.</msg-desc>
</section-02>
<section-02>
<line-number>000001</line-number>
<table-name>z304</table-name>
<action>WRITE</action>
<match-id>16251775</match-id>
<user-name>xxxxxxx</user-name>
<patron-id>ABC62848</patron-id>
<msg-code>5003</msg-code>
<msg-desc>Unable to process record due to problems in other records.</msg-desc>
</section-02>
<section-02>
<line-number>000001</line-number>
<table-name>z305</table-name>
<action>WRITE</action>
<match-id>16251775</match-id>
<user-name>xxxxx, Kelly</user-name>
<patron-id>ABC62848</patron-id>
<msg-code>5021</msg-code>
<msg-desc>check_z305 routine failed. Can not ins/upd record. cur-id ABC62848.</msg-desc>
</section-02>
<section-02>
<line-number>000001</line-number>
<table-name>z308</table-name>
<action>WRITE</action>
<match-id>16251775</match-id>
<user-name>xxxxxx</user-name>
<patron-id>ABC62848</patron-id>
<msg-code>5003</msg-code>
<msg-desc>Unable to process record due to problems in other records.</msg-desc>
</section-02>
<section-02>
<line-number>000001</line-number>
<table-name>z308</table-name>
<action>WRITE</action>
<match-id>16251775</match-id>
<user-name>xxxxxxx</user-name>
<patron-id>ABC62848</patron-id>
<msg-code>5003</msg-code>
<msg-desc>Unable to process record due to problems in other records.</msg-desc>
</section-02>

Resolution:
We see these messages in the $alephe_scratch/p_file_20 logs:

Error (b_file_20_chk_edit_record) : Errors in Z305 Record 000008
Number of Errors = 03

Error 0104 : Z305-EXPIRY-DATE is not correct

Error 0117 : Z305-PHOTO-CHARGE should be "C" or "F"

Error 0202 : conflict between Z305-SUB-LIBRARY and Z305-BOR-STATUS (check tab31)

Z305-EXPIRY-DATE cannot be blank. {It shows as "mandatory" in the "How to use the Patron Loader Interface Format (PLIF)" document.}

Z305-PHOTO-CHARGE should be "C" or "F"

In the BOR-REC, SUB-LIBRARY "ABCMN" is not in the abc50 tab31 patron status table, therefore, it can not be used with status "01". You should not have "ABCMN" as the BOR-REC SUB-LIBRARY. You should have "ABC50". (The How To doc says for this field: "For North American libraries, usually the xxx50 ADM library code (or a valid sublibrary code)."

The other error messages are a result of the "conflict between Z305-SUB-LIBRARY ..." error.

This "conflict between Z305-SUB-LIBRARY ..." error can occur in v18-up when you have a BOR-REC "SUB-LIBRARY ... ALEPH" record in your input file, and just one ADM library and USER-SHARING=N. In this case you do *not* need or want an ALEPH BOR-REC (you need an xxx50 BOR-REC). The ALEPH BOR-REC should be removed from your PLIF input file.