07-22-2020 08:43 AM
When exporting using the save option in the DI console there seems a limitation of 50,000 lines (+header) no matter how much data is avaialble in the console view. Where is the configuration setting property to allow for raising the limit?
DO you know @CraigeH?
Solved! Go to Solution.
07-22-2020 09:02 AM - edited 07-22-2020 09:03 AM
Hey Rod!
It is not an exposed setting but can be added as follows:
Edit <INSTALLDIR>\Program Files\DataInsight\bin\WebServerService.vmoptions
Add the following line to the end of the file:
-Dmatrix.export.maxrecords=<VALUE>
Example:
-Dmatrix.export.maxrecords=200000
Restart the DataInsightWeb service
A couple of notes to keep in mind:
1. This will increase load on resources for the webserver on the MS when exporting to CSV
2. Excel (most common program used to open CSV files) has a row limit of 1048576
07-22-2020 09:02 AM - edited 07-22-2020 09:03 AM
Hey Rod!
It is not an exposed setting but can be added as follows:
Edit <INSTALLDIR>\Program Files\DataInsight\bin\WebServerService.vmoptions
Add the following line to the end of the file:
-Dmatrix.export.maxrecords=<VALUE>
Example:
-Dmatrix.export.maxrecords=200000
Restart the DataInsightWeb service
A couple of notes to keep in mind:
1. This will increase load on resources for the webserver on the MS when exporting to CSV
2. Excel (most common program used to open CSV files) has a row limit of 1048576
07-23-2020 12:35 PM
Thank you @CraigeH successfully confirmed solution.