Answer
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”
Best answer by Eranga Jayatissa
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.
+6It 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.
Era
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.