Hello all,
The standard Advanced Billing Deposit Balance report in our environments runs intermittently (most of the time failiing). The task will just hang in System Monitor, never completing. The issue is the report generation on the Task Agent consumes so much memory that the application pool recycles the process:
Our private bytes memory limit on the application pools are set to 9GB in each environment. The reason the report generation is intermittent is that if the application pool process does not happen to reach that 9GB limit at the time we run the report, the report will generate.
(As a note we can hardly ever get the report to run in Production, but can generate it maybe 60% of the time in our Dev, Test environments due to ongoing activity)
When the report does run it does not have that much data on it, usually 2 pages worth for a 5-10 customers.
I believe that the base report is running an initial open query against OrderDtl, which has over 2.2 million records in our environments. I have tried to filter on the report by copying and changing the Report Data Definition and setting on a new report style, but this does not effect the performance, because I believe any filter I apply there (ex. OrderDate > ‘12/31/2024’ or OrderNum > some recent number) is done after any standard processing it does.
I do have an Epicor Support ticket open but after going back and forth for over a month the recommendation was to apply the latest update for our version, which we cannot do at this time just to potentially solve this one issue we have.
We are on Epicor 11.2.200, Kinetic 2022.2.28
Has anyone run into similar issues or have any advice on how to resolve this?