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