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.

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