KB47650: "Maximum number of result rows retrieved per report was exceeded" error message returned when executing a data mart report in MicroStrategy Developer

Salesforce Solutions Architect • Strategy

'Maximum number of result rows retrieved per report was exceeded.'thrown when running a data mart report after setting the maximum number of result rows for data marts to infinite (-1) or a very large number (999999999)

SYMPTOM:

When running a data mart report after setting the maximum number of result rows for data marts to infinite (-1) or a very large number (999999999), the following error is thrown:


Error: Maximum number of result rows retrieved per report was exceeded.[Maximum number of result rows retrieved per report was exceeded. XXX, it is set for "YYY"]Error in Process method of Component: QueryEngineServer

CAUSE:

In each new data mart report, there is a setting for maximum number of result rows that functionally ignores the project-level setting.

ACTION:

Upon configuring the data mart in the Advanced tab, increase the "Maximum number of rows (Analytical Engine)" setting to 999999999 (functional limit for data marts).

Comment

0 comments

Details

Knowledge Article

Published:

June 12, 2017

Last Updated:

June 12, 2017