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".)