locked
Performancepoint Services 2010 : Unable to create report. Query produced too many results RRS feed

  • Question

  • Hi All,

    I am creating an Analytical grid (Tabular Format) in PPS 2010. I get an error when the no: rows (dimensions) and cols (fact's) increases , the error is:

    "Unable to create report. Query produced too many results".

    I checked the Event Viewer and it gives the Error details:

    An exception occurred while rendering a Web control. The following diagnostic information might help to determine the cause of this problem:

    Microsoft.PerformancePoint.Scorecards.BpmException: There was a problem preparing the WebPart for display.

    PerformancePoint Services error code 20700.

    ***********************************************************

    I took the query and run it in Management Studio , I get the result in 27 secs.

    Any answers are highly appreciated.

    Monday, May 27, 2013 6:21 PM

Answers

  • Hello,

    Can you please try changing the  of the parameters listed below to a larger value. May be you can try by making it double the value and then run the query to check whether the issue is resolved. To do this, follow these steps:

    Please take a backup of the web.config file prior to the changes

    1. On the SharePoint 2010 server, open the Web.config file. The file is located in the following folder:
      \Program Files\Microsoft Office Servers\14.0\Web Services\PpsMonitoringServer\
    2. Locate and change the the below values from 8192 to 16384.
    3. Open the Client.config file. The file is located in the following folder:
      \Program Files\Microsoft Office Servers\14.0\WebClients\PpsMonitoringServer\
    4. Locate and change the below values from 8192 to 16384.
    5. After you have made the changes, restart Internet Information Services (IIS) on the SharePoint 2010 server.

    <readerQuotas

                  maxStringContentLength="2147483647"

                  maxNameTableCharCount="2147483647"

                  maxBytesPerRead="2147483647"

                  maxArrayLength="2147483647"

                  maxDepth="2147483647" />

    Also can you please let me know the number of rows the report fetches the data or also try filtering the non-empty cells by using the NON-EMPTY MDX function in the Report's Query Designer

    • Marked as answer by ConnectDebz Friday, May 31, 2013 6:36 PM
    Friday, May 31, 2013 11:37 AM
  • Thanks Ravaan for the reply.

    Though there can be multiple ways of increasing the amount of values fetched from SSAS server. I tried the below statement in one of the blogs

    Set-SPPerformancePointServiceApplication -identity "PerformancePoint Service Application" -AnalyticQueryCellMax 10000000

    This helped me in increasing the amount of rows fetched.

    Now if NONEMPTY () function is used , I have observed that the query processing is increased. There are some NULL values being also retrieved which can be filtered by using NON EMPTY.

    Thanks 

    • Marked as answer by ConnectDebz Friday, May 31, 2013 6:37 PM
    Friday, May 31, 2013 6:36 PM

All replies

  • Hello,

    Can you please try changing the  of the parameters listed below to a larger value. May be you can try by making it double the value and then run the query to check whether the issue is resolved. To do this, follow these steps:

    Please take a backup of the web.config file prior to the changes

    1. On the SharePoint 2010 server, open the Web.config file. The file is located in the following folder:
      \Program Files\Microsoft Office Servers\14.0\Web Services\PpsMonitoringServer\
    2. Locate and change the the below values from 8192 to 16384.
    3. Open the Client.config file. The file is located in the following folder:
      \Program Files\Microsoft Office Servers\14.0\WebClients\PpsMonitoringServer\
    4. Locate and change the below values from 8192 to 16384.
    5. After you have made the changes, restart Internet Information Services (IIS) on the SharePoint 2010 server.

    <readerQuotas

                  maxStringContentLength="2147483647"

                  maxNameTableCharCount="2147483647"

                  maxBytesPerRead="2147483647"

                  maxArrayLength="2147483647"

                  maxDepth="2147483647" />

    Also can you please let me know the number of rows the report fetches the data or also try filtering the non-empty cells by using the NON-EMPTY MDX function in the Report's Query Designer

    • Marked as answer by ConnectDebz Friday, May 31, 2013 6:36 PM
    Friday, May 31, 2013 11:37 AM
  • Thanks Ravaan for the reply.

    Though there can be multiple ways of increasing the amount of values fetched from SSAS server. I tried the below statement in one of the blogs

    Set-SPPerformancePointServiceApplication -identity "PerformancePoint Service Application" -AnalyticQueryCellMax 10000000

    This helped me in increasing the amount of rows fetched.

    Now if NONEMPTY () function is used , I have observed that the query processing is increased. There are some NULL values being also retrieved which can be filtered by using NON EMPTY.

    Thanks 

    • Marked as answer by ConnectDebz Friday, May 31, 2013 6:37 PM
    Friday, May 31, 2013 6:36 PM
  • Hi ConnectDEbz,

    Hope the answer helped you in that case happy to help you

    Monday, June 10, 2013 11:22 AM