Summary
This article explains how to set a maximum row limit for report output in the TRBOnet Server configuration file to prevent oversized report queries from destabilizing the SQL service and Console.
Current versions have no limit of report rows output. However, large report queries may cause the SQL service to become unresponsive and lead to Console instability. To prevent dispatchers from generating oversized reports such as outputs above 1000000 rows you can set a row limit in the Server configuration file.
Before making any changes create a backup of the Server configuration file.
1. Stop Server Service.
2. Close Server Configurator.
3. Open Notepad as administrator and then open the TRBOnet.Enterprise.Server.config file located at:
Enterprise: C:\ProgramData\Neocom Software\TRBOnet.Enterprise\
Plus: C:\ProgramData\Neocom Software\TRBOnet Plus\
4. Locate the line MaxDBSelect and set the required row limit value. Change False to True.
5. Save the file.
6. Open Server Configurator and start the Server service.
The default line and an edited example are shown below:
<MaxDBSelect enable="False">100000</MaxDBSelect>
<MaxDBSelect enable="True">50000</MaxDBSelect>
