IBM Support

Number of Rows Retrieved Exceeds the Data Retrieval Limit

Troubleshooting


Problem

[

Using governor settings, you can set limits on the number of rows that are returned when you execute a report or query. If the report or query exceeds the number of rows that are set in your governor settings, you will receive the following message, where 10 reflects the value of the Data Retrieval Limit governor.

]

Symptom

RQP-DEF-0110 The number of rows retrieved for the user who has the identity '{Everyone, Authors, Query Users, Consumers, Metrics Authors, Metrics Users, Planning Users, Controller Users, Analysis Users, Data Manager Authors, System Administrators}' exceeds the limit of 10.

When you receive this message, your report or query will not return any data.

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Framework Manager","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.1.1;10.2.1;10.2.2;8.4.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SS6G84","label":"IBM Cognos Analytics on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
13 January 2026

UID

swg21340548