Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. p_file_20: Patron Unable to load ("Login record belongs to other patron")

    p_file_20: Patron Unable to load ("Login record belongs to other patron")

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 16.02

    Description:
    I am trying to load a patron (with PLIF) that will not add due to this error:

    + <section-02>
    + <line-number>000245</line-number>
    + <table-name>z308</table-name>
    + <action>WRITE</action>
    + <match-id>0160000001035872</match-id>
    + <user-name>Howley, Caitlin M.</user-name>
    + <patron-id>MLC900002526</patron-id>
    + <msg-code>5037</msg-code>
    + <msg-desc>Cannot update/delete record. Login record belongs to other patron</msg-desc>
    + </section-02>

    However, I have tried to find the existing record by using SQL and it returns 0 rows.

    SQL-PWD50> select * from z308 where z308_id like '%60000001035872%';

    no rows selected

    SQL-PWD50> select * from z308 where z308_id like '%MLC900002524%';

    no rows selected

    SQL-PWD50> select * from z308 where z308_rec_key like '%60000001035872%';

    no rows selected

    SQL-PWD50> select * from z308 where z308_rec_key like '%MLC900002524%';

    no rows selected

    [ <Jerry Specht > ]

    [ <Jerry Specht > ]

    Resolution:
    [From site:] I was able to find the key in 03 record in z308 that was causing problems. It is:

    03HCC800000777

    This person received a new bar code and ID card, but the same patron ID number. When adding a record we create an 03 record with the person's patron ID number. When the new record with the new bar code was being added into the database, it caused an error because the 03 record already existed with the previous barcode record. I deleted the 03 record from her old record and ran the patron load and it created the new bar code records including the 03 record in z308. We need to readdress our procedures.


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • p_file_20: patron barcodes leading zero
      • p_file_20: PLIF-MODIFICATION doesn't prevent creation of Address type '02'
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 16.02
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved