Knowlege base

In reports you get the message: Your request has generated >10000 rows and has reached the configured limit.Only the first 10000 rows will be extracted.

Article ID: 613
Last updated: 21 Sep, 2023

Applies to:

Billy Blue's
Blues Enterprise 4

Description:

In the reports (typically call monitor reports) only first 10000 lines are reported.
If more records are present you get a message: "Your request has generated [>10000] rows and has reached the configured limit.Only the first 10000 rows will be extracted.". This happens for both interactive and scheduled reports

How-to:

To increase (or reduce) this limit proceed as follows:
1. Open SQL Management Studio and connect to SQL Instance used by our application.
2. Create new query from DB (BluesPro or IAS).
3. Paste the following queries:

update opzioni set sValue=50000 where ssection='MaxInteractiveRows'

for interactive reports
and

update opzioni set sValue=50000 where ssection='MaxSchedulerRows'


for scheduled reports 
where 50000 is the new value for reported records.  

NOTE: 50000 is the limit that can be achieved - A value too high may cause a timeout of the report.

4. Click [Execute Command] to confirm. (please run one single query at time):
5. Click 'Options' next to the SQL Panel to verify if the parameters have been updated.

NOTE: At the end you may need to follow the solution here

Article ID: 613
Last updated: 21 Sep, 2023
Revision: 7
Views: 811
Print Export to PDF Subscribe Share
This article was:  
Prev   Next
How to change date format from DD/MM/YYYY to MM/DD/YYYY in Billy...     No calls or no recent calls displayed on Billy Blue's statistics...