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. GUI Cash: ORA-01455: converting column overflows integer datatype

    GUI Cash: ORA-01455: converting column overflows integer datatype

    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: 20

    Problem Symptoms:
    Slow response time on the patron activity screen. The pc_server log shows this:
    ...
    DESCRIPTION: Get Global Patron/Local Patron Information
    ACTION : CIRC
    PROGRAM : pc_cir_c0438
    ...
    ...
    Oracle error: io_z31_get_balance
    ORA-01455: converting column overflows integer datatype
    ...

    Cause:
    This can be caused by excessively large z31_sum's. The following SQL shows such sums in descending order. (In some cases, it seems that barcodes have been pasted in to the Sum field). The following SQL retrieves sums > $100.00:

    > s+ xxx50
    SQL> select z31_sum, z31_rec_key from z31 where z31_sum > 10000 order by z31_sum desc;

    Resolution:
    1. If the sum is for an Active transaction, call up the patron's Cash in the GUI and correct the excessively large amount.
    2. If the sum is for a Cancelled Transaction, contact Ex Libris Support. (Refer to this KB 16384-58257's "Notes field".)

    Additional Information

    These are the results of the SQL at one site. (All sums greater than $100.00):

    xxx50@ALEPH20> select z31_sum, z31_rec_key from z31 where z31_sum > 10000 order by z31_sum desc;
    **** Hit return to continue ****

    Z31_SUM Z31_REC_KEY
    -------------- ---------------------------
    33311100533831 XXX000021429200809180930799
    33111006968792 XXXID38055 201210275311293
    23111002748984 XXXID4865 201206121755000
    23111002571436 XXXID2530 201209184297362
    23111002309258 XXXID19629 201209184300312
    19999999999999 ID37401 200705161414403
    13311100612173 NFGID1176 201206071641986
    00001000000000 SCREUSPMKU 200702122978097
    00000099999999 ID37401 200705161420273
    00000010000000 XXX000021058200707111522584
    00000010000000 XXX000021058200707111521292

    Category: Circulation (500)

    Subject: Cash management (500)


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • GUI budget diplay filter by year problem
      • GUI Cataloging --Search --Browse Title info
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. Cash management (500)
      3. Circulation (500)
      4. contype:kba
      5. Prod:Aleph
      6. 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