Getting error "Maximum number of rows to retrieve during statement execution" | IFS Community
Solved

Getting error "Maximum number of rows to retrieve during statement execution"

  • 30 September 2019
  • 1 reply
  • 210 views

Userlevel 4
Badge +5
When executing a BA report, I get the following error. “Maximum number of rows to retrieve during statement execution”
icon

Best answer by Eranga Jayatissa 30 September 2019, 13:48

View original

1 reply

Userlevel 4
Badge +6
It takes long time since it is retrieving so many records. Please try the following steps.
1. Change the MAX_NUMBER_OF_ROWS_TO_RETRIEVE parameter in BA parameter list to a higher value.
2. When designing these kinds of reports, in Report Book -> Options, we are recommending to check “Optimize Report Expansion” and “Enable Compression of Result Set” options for proper report execution.

Reply