Cash display takes minutes for patrons with many Cash lines; cash-05 very slow

• Article Type: General
• Product: Aleph
• Product Version: 20, 22, 22, 23

Problem Symptoms:
1. In GUI Circ, there is a very slow/or no response in producing the cash display for certain patrons. Some patrons get "Server failed to execute request after 60 seconds" in the "All transactions" and "Active cash" tabs.

Though the Cash display of patrons with infrequently-loaned entries comes up in just a few seconds, the display for patrons who have Cash entries for items which have been loaned hundreds of times takes a minute or more.

 2.  The cash-05 ("Unpaid Transactions Letter") Service is extremely slow in producing letters for patrons who have Cash entries for items which have been loaned hundreds of times.

Cause:
Items with many z36h (Loan history) and/or z30h (Item history) records.

Resolution:
* Do util a/17/14 in the ADM library to confirm that the z31(Cash), z36h (Loan history), and z30h (Item history) Oracle indexes are present and valid. If not, use util a/17/2 to build them.

* Assuming they are present and valid, delete older z36h and z30h records:

• the z36h is used in the GUI Circ Loan --> History. The farther back this display goes, the slower the Cash display will be.
• the z30h is used in the GUI Circ (in order to get the "Last updated" date in "History" in the tree on the left) and, in Cataloging, the "Items List -- All Items History" display.   
• z36h records older than xx months/years can be purged from the patron id via service 'Remove Patron ID' (cir-32) to detach them from the patron record
• z36h records older than xx months/years can be deleted by util x/13/4 
• z30h records older than xx months/years can be deleted as described in the article " Unnecessary z30h history records "

* If the preceding doesn't help and this is a pseudo-patron, create a second, new pseudopatron.