Creating reports and dashboards | Stimulsoft community forum

We are experiencing problems related to memory overflow in some requests, which directly affects the performance of the service and, in some cases, results in a system crash. We need to perform an analysis to identify ways to control or limit these processings, in order to improve the visualization of the reports.
We need to identify possible bottlenecks and implement measures to mitigate the memory overflow problem.


Transaction name: /report-executor/stimulsoft_webviewer_action
Error: GC overhead limit exceeded
exception
java.lang.OutOfMemoryError: GC overhead limit exceeded


attached traces for analysis

Hello.

You have two different java.lang.OutOfMemoryError exceptions:
1 - During loading data from database - report building process need to load all data to memory, only way to avoid it is to increase system memory.
2 - During report build - you can activate Report Cache Mode, then report engine saves serialised version of each page to folder when cache mode is activated. So report engine can work with big reports without high memory consumption.

If report.ReportCacheMode = StiReportCacheMode.Auto, then the first page that goes into the cache is determined by the following parameter:
StiOptions.Engine.ReportCache.LimitForStartUsingCache.

If report.ReportCacheMode = StiReportCacheMode.On then caching will start from the first page.

The number of pages that are constantly in RAM is determined by the parameter:
StiOptions.Engine.ReportCache.AmountOfQuickAccessPages.

We will perform the adjustments and continue with the tests.
Thanks.

Hello,

Ok.
Let us know if you need our help.

Thank you.