Skip to Content
Author's profile photo Murthy Gunuputi

SAP BO Analysis for Office 2.2 generates “Size Limit of Result Set Exceeded” error message

Size Limit of Result Exceeded is a common issue with Analysis for Office.

Below blog already explains on how to avoid this issue, but this doesn’t work with Analysis for Office 2.2

SAP BO Analysis for Office generates “Size Limit of Result Set Exceeded”error message

Below steps will enable to you overcome the default limit of 500000.

1. Screenshot 001 below shows that the default limit is 500000.

001.PNG

2. Screenshot 002 clearly states that for 1.x versions of AO, we need to change it from registry but from 2.x onwards we can change it at file system level.

002.PNG

3. Screenshot 003 will shows how to navigate to the file system and check whether the settings are UserRoaming or PerMachine. If user UserRaoming, then we user can change it at user level. If PerMachine is maintained, it is applicable for all the users in the machine.

003.PNG

4. Screenshot 004 shows the Ao_app.config file in C:\ProgramData\SAP\Cof

Here parameter “ResultSetSizeLimit” is maintained as “UserRoaming”. This setting enables each user to have different settings on the same machine.

004.PNG

5. Screenshot 005 shows how to before and after of Ao_user_roaming.config file in Users\[UserID]\AppData\Roaming\SAP\Cof.

If the entry is not maintained, we need to insert a new line and add the entry. In this case there was no entry maintained.

005.PNG

Below is the link for Administrator Guide that I referred to

https://websmp103.sap-ag.de/~sapidb/012002523100004457362016E/22SP2_aaoffice_admin_en.pdf

Please use this option carefully, as this can increase the load on db server.

Assigned tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      seperti dengan tujuan dari toko bliherbal online ini diciptakan bertujuan untuk sentral pengobatan tradisional yang bersumber dari tumbuh-tumbuhan  obat herbal sinusitis alami

      Author's profile photo nilima rodrigues
      nilima rodrigues

      Thank you. This blog helped me to resolve issue of result size limit of 500.000 in analysis for office for my users too.