Start a conversation Sign in
Start a conversation
  1. Service Gateway Support
  2. Service Gateway - Solution
  3. Articles

Report Returning Too Many Rows

Article Original Creation Date: 2012-05-15

Overview

Following error message displays while executing a report from ServiceGateway GUI:

The report has returned too many rows. Check the Parameters and try again.

Environment

  • Solaris
  • Oracle
  • SQL Server

Root Cause

The root cause of the error is the number of rows, the report returns, is higher than the configured value.

Resolution

To resolve the issue mentioned previously, configure the maximum no. of rows in a report to a higher value.
To update the value, follow the steps listed below:
  1. Navigate to Administration > Settings > Preferences

    General.png

  2. From the left sidebar, Select General and in the right section, find the setting Maximum Number of Rows in a Report. The default value for this field is 1000. Increase the value as desired.

    preference-general.png

Note: Prefer keeping the Maximum Number of Rows in a Report value to a lesser value, as running reports generating a large number of rows affects application/database performance.

Choose files or drag and drop files
Was this article helpful?
Yes
No

  1. Priyanka Bhotika

  2. Posted

Comments