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. Cash 'by sublibrary' sort crashes circ client: "fetched column value is NULL"

    Cash 'by sublibrary' sort crashes circ client: "fetched column value is NULL"

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    We can crash the circ client by using the 'by sublibrary' button on the patron cash screen.

    I am able to replicate this with her user account (00000923), but not another, patron id 00000003).

    We see the following information in the pc_server log:

    PROGRAM : pc_cash_c0711

    Oracle error: io_z31_sub_library_list
    ORA-01405: fetched column value is NULL

    Load: /LUN0/utf_files/exlibris/aleph/u18_1/abc01/tab/tab_sub_lib_sort

    Resolution:
    The io_z31_sub_library_list routine is trying to sort the cash records for this particular patron and finding some whose z31_sub_library field is null:

    SQL> select z31_rec_key from z31 where z31_rec_key like '00000923%' and Z31_SUB_LIBRARY is null;
    Z31_REC_KEY
    ---------------------------
    00000923 200001061637251
    00000923 200001070916293
    00000923 200001070945205
    00000923 200001070948064
    00000923 200001070949259

    5 rows selected.

    SQL> select z31_rec_key from z31 where z31_rec_key like '00000003%' and Z31_SUB_LIBRARY is null;
    no rows selected

    The following SQL shows that 7919 z31 records have a null z31_sub_library:

    SQL> select count(*) from z31 where Z31_SUB_LIBRARY is null;
    COUNT(*)
    ----------
    7919

    (The total number of abc50 z31's is 114444.)

    The z31_rec_key "... 2000...." indicates that these records are from the year 2000.

    I suggest that you use SQL to populate these Z31_SUB_LIBRARY fields with a valid sublibrary. (If you don't want to use an actual sublibrary, you could add a sublibrary "DUMMY" for ABC50 in tab_sub_library.eng and use that.)

    Additional Information

    faq


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Case sensitivity of Patron IDs
      • Cash Credits being created with Description "Payment Change"
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 18.01
      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