When executing a BA report, I get the following error. “Maximum number of rows to retrieve during statement execution”
Page 1 / 1
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 E-mail address. We'll send you an e-mail with instructions to reset your password.