Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

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

    • 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