Budget transaction display slow; only about 64,000 transactions display
- Article Type: General
- Product: Aleph
- Product Version: 20
Budgets are taking an excessively long time to access in the Acq GUI.
When trying the access the Budgets the GUI just hangs there for at least 3 minutes. Then selecting the transactions tab to review transactions causes the GUI to hang for another while.
In addition there are several thousand transactions missing from display in the GUI from the Budgets 'ACQ-2000', 'ACQ-2002, 'ACQ-2007', and 'ACQ-2010'. For example, when retrieving the budget transactions (Z601) from the budget 'ACQ-2007', only the 2006 transactions appear in the list of transactions, all the 2007 transactions do not appear.
There are a total of 171,563 budget transactions (Z601 records) for the budget 'ACQ-2007'; within that total there are 69171 z601 records for ENC and Z601_OPEN_DATE = 2007 and
for 2006 there are 68273 ENC records. This means that there are 69171 z601 records for 2007 that are not displaying in the GUI for this budget ('ACQ-2007').
So the question is ==> Is there a limit to the total number of transactions that can be retrieved in the GUI?
It seems that there is a limit of about 64,000 transactions (z601s). We are checking on this.
This issue is still open and was escalated to Development for further investigation <2011-03-13 01:00:06>.
- Article last edited: 10/8/2013