Best answer by Eranga Jayatissa
View original
Getting error "Maximum number of rows to retrieve during statement execution"
When executing a BA report, I get the following error. “Maximum number of rows to retrieve during statement execution”
Userlevel 4
+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.
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.