Reports error message: Request generated >10000 rows, reaching the limit

Applies to:

UCX Suite, any version

Description:

In the reports (typically call monitor reports) only first 10,000 lines are reported.
If more records are present you get a message: "Your request has generated [>10,000] rows and it 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 limit for reported records.  

50000 is the highest configurable value - A higher value 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.

You might need to follow this additional solution here.