Time delay in exporting reports
One of the main reasons for delay in report exports is the large volume of report entries. To reduce the report export time, we recommend you generate and export only the information needed. Select the exact time period and columns that are required to reduce the report size.
- Fine-tune the criteria of the report based on your requirements. Ensure that you choose the appropriate log type to cut noise.
- When you want to export bulk reports, we advise that you split and schedule report exports. We also recommend that you schedule the data export via the report scheduler to run during non-business hours, since exporting reports in bulk directly from a web browser can negatively impact the product performance.
Why is there a delay when you export large volume of reports?
During direct bulk exports, 20,000 records per batch are stored as streams in the memory. After completing the data export, all the stored report data will be moved from the Java memory to a file location on the server. Based on the number of entries, size of the export file, and other aspects, moving the report file to a specified location can be time-consuming.
New to ADSelfService Plus?
Related Articles
Why are some SQL Server reports showing no data?
Case 1: Are the required audit policies configured? Open SQL Server Management Studio application in the Windows machine in which SQL Server is installed, and connect to the required instance. Click the Security option. The Server Audit ...Scheduled reports are not getting delivered
There could be many reasons why the scheduled reports were not delivered to the specified email ID. The most common reasons include improper configuration of the mail server, generation of empty reports with settings that specify not to deliver empty ...STATUS_MARKED_ROLLBACK in export
Issue: STATUS_MARKED_ROLLBACK in export Steps to fix: i) For postgres Database, download attachment<StatusMarkedRollback.txt> and rename file extension to .bat. 1. Copy patch statusMarkedRollback.bat to <ELA-HOME>\pgsql\bin folder. 2. Open Command ...How to collect the users Enabled/Disabled SQL logs?
The Enable/Disable logs will be recorded in the Event Viewer in the following scenarios: In SQL Server Management Studio, Security ⇾ Logins ⇾ Right-click on any user ⇾ Properties ⇾ Status ⇾ Login section ⇾ select Disabled/Enabled. By executing the ...ELA Distribution Upgrade to Latest
How to: Upgrading EventLog Analyzer (*Distributed Edition) to the latest Service Pack. Note: A folder backup or a snapshot of the Admin and the Managed Server VMs is MANDATORY. If the backend database is customer's MSSQL, it is recommended to take a ...