Archive for the ‘BI’ Category

Exporting Performance Point Data Throws Duplicate Headers Received Error

Friday, April 17th, 2015

Version 1.0

Error

Recently I came across a situation where a user was trying to export a SharePoint Performance Point dashboard data to Excel and was getting the Duplicate Header Received error.

Duplicate headers received from server

ERR-RESPONSE_HEADERS_MULTIPLE_CONTENT_DISPOSITION

Duplicate Headers Received Error When Exporting PerfPoint.jpg

 

Details

I looked into the PerformancePoint dashboard and used the export to Excel option.

SPProd_PerfPoint_Report_Export_to_Excel_Duplicate_Header_Issue_02.png

 

I was able to export the data to excel and view it in there.

SPProd_PerfPoint_Report_Export_to_Excel_Duplicate_Header_Issue_03.png

 

Under one instance, when I used ‘Export to Excel’ option, the file download dialog box showed an extremely long file name with lots of special characters.

SPProd_PerfPoint_Report_Export_to_Excel_Duplicate_Header_Issue_01.png

 

Root Cause

It turns out to be the user was using the Chrome browser instead of Internet Explorer. The error is specific to Chrome as other browsers ignore the duplicate headers.

Enclosing the file names in ” ” or using underscore instead of spaces or comma (,) is one solution.

Read the following articles for little mode details on the issue.

a. Fix for Duplicate Headers Erro 349

b. Duplicate Headers received from Server

 

Keywords
  • PerformancePoint data export error
  • PerformancePoint data export error in Chrome
  • PerformancePoint Export to Excel does not work in Chrome
  • SharePoint PerformancePoint Dashboard Error
  • SharePoint PerformancePoint BI data export Error
  • SharePoint Duplicate Header Received error
  • SharePoint Duplicate Header error
  • SharePoint with Internet Explorer VS Chrome

Common Errors in SharePoint Visio Services

Wednesday, November 26th, 2014

Common Errors in SharePoint Visio Graphics Services

Version: 1.0

Applies to: SharePoint 2010, SharePoint 2013

What is Visio Graphics Services

Visio Graphics Services is a service application in Enterprise editions of SharePoint Server 2010 and 2013. The service application allows SharePoint users to:

  1. view the Visio drawings without having MS Visio installed on their PCs
  2. allows data connected Visio drawings that can be refreshed from data sources
  3. allows users to view the SharePoint Workflow Visualizations

Common Issues with Visio Graphics Services

Following list shows common Visio Graphics Services errors, causes and resolutions.

  1.  The server failed to process the request

1. The server failed to process the request

A user tries to view Visio in browser (or view the Workflow Visualization page) from SharePoint and gets the error message:

The server failed to process the request

SharePoint Visio Graphics Service Error - The server failed to process the request
SharePoint Visio Graphics Service Error – The server failed to process the request

At this point a user tries to click on ‘Open in Visio’ link on top left of the workflow Visualization section to open the file in MS Visio on their desktop. The Visio file opens up in MS Visio.

In one scenario I was able to open the Workflow Visualization file in MS Visio on my desktop only in read only mode. I was getting a warning message:

Visio Standard does not support savings files of this type. When saving the file, you will be prompted to save as a different file type.

The reason of this warning is clear from the warning message. I had standard version of MS Visio on my PC. The Workflow Visualization file had .visio web drawing file extension (.VDW). The users with Ultimate, Premium and other higher version would be able to open and edit the web drawing format Visio files.

SharePoint Workflow Visualization - Web Drawing VDW can't be edited with Visio Standard
SharePoint Workflow Visualization – Web Drawing VDW can’t be edited with Visio Standard

Event Viewer Errors on Servers

Event Viewer Error 01

Log Name:      Application
Source:        System.ServiceModel 3.0.0.0
Date:          11/19/2014 4:44:00 PM
Event ID:      3
Task Category: WebHost
Level:         Error
Keywords:      Classic
User:          domainSPFarmAdminAct
Computer:      SPAppServer02.domain.com
Description:
WebHost failed to process a request.
 Sender Information: System.ServiceModel.ServiceHostingEnvironment+HostingManager/5426204
 Exception: System.ServiceModel.ServiceActivationException: The service ‘/20bf95936ed944db89431a9d16459372/VisioGraphicsService.svc’ cannot be activated due to an exception during compilation.  The exception message is: Loading this assembly would produce a different grant set from other instances. (Exception from HRESULT: 0x80131401). —> System.IO.FileLoadException: Loading this assembly would produce a different grant set from other instances. (Exception from HRESULT: 0x80131401)
   at Microsoft.Office.Visio.Server.GraphicsServer.VisioGraphicsServiceHostFactory.CreateServiceHost(String constructorString, Uri[] baseAddresses)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.CreateService(String normalizedVirtualPath)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.ActivateService(String normalizedVirtualPath)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath)
   — End of inner exception stack trace —
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath)
   at System.ServiceModel.ServiceHostingEnvironment.EnsureServiceAvailableFast(String relativeVirtualPath)
 Process Name: w3wp
 Process ID: 4724

Event Xml:
<Event xmlns=”http://schemas.microsoft.com/win/2004/08/events/event”>
  <System>
    <Provider Name=”System.ServiceModel 3.0.0.0″ />
    <EventID Qualifiers=”49154″>3</EventID>
    <Level>2</Level>
    <Task>5</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime=”2014-11-19T22:44:00.000000000Z” />
    <EventRecordID>730921</EventRecordID>
    <Channel>Application</Channel>
    <Computer>SPAppServer02.domain.com</Computer>
    <Security UserID=”S-1-5-21-1627688274-1190192956-3999157559-1223″ />
  </System>
  <EventData>
    <Data>System.ServiceModel.ServiceHostingEnvironment+HostingManager/5426204</Data>
    <Data>System.ServiceModel.ServiceActivationException: The service ‘/20bf95936ed944db89431a9d16459372/VisioGraphicsService.svc’ cannot be activated due to an exception during compilation.  The exception message is: Loading this assembly would produce a different grant set from other instances. (Exception from HRESULT: 0x80131401). —&gt; System.IO.FileLoadException: Loading this assembly would produce a different grant set from other instances. (Exception from HRESULT: 0x80131401)
   at Microsoft.Office.Visio.Server.GraphicsServer.VisioGraphicsServiceHostFactory.CreateServiceHost(String constructorString, Uri[] baseAddresses)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.CreateService(String normalizedVirtualPath)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.ActivateService(String normalizedVirtualPath)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath)
   — End of inner exception stack trace —
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath)
   at System.ServiceModel.ServiceHostingEnvironment.EnsureServiceAvailableFast(String relativeVirtualPath)</Data>
    <Data>w3wp</Data>
    <Data>4724</Data>
  </EventData>
</Event>

Causes:

There can be different reasons for the error ‘failed to process request’. Some of those are listed below:

  1. Service Account running Visio Services doesn’t have access to SharePoint Content Databases
  2. Application ID under Visio Graphics Service is not not correct or missing (Go to Central Administration  > Manage Service Applications > Visio Graphics Services > Global Settings)
  3. Secure Store Service application ID that is configured for Visio Graphics Services doesn’t have correct Permissions
  4. Visio Graphics Services on SharePoint Server are not running
  5. Some other failing services causing issue

Resolution:

In one of my scenario, everything was right except the fact that Secure Store Service was having some issues. That lead to issues for Visio Graphics Services. An IISReset /noforce on SharePoint Servers helped in resolving this issue.

Visio drawing started working in Workflow Visualization and also in Visio Web Part.

SharePoint Visio Graphics Services - Visio Web Access Web Part
SharePoint Visio Graphics Services – Visio Web Access Web Part

Workflow Visualization page showing the visio workflow

SharePoint Visio Graphics Services - Workflow Visualization Showing Process in Visio
SharePoint Visio Graphics Services – Workflow Visualization Showing Process in Visio

References:
1. Visio Graphics Service administration in SharePoint Server 2013
http://technet.microsoft.com/en-us/library/ee524059(v=office.15).aspx

2. SharePoint 2013 Visio Service: the server failed to process the request
http://alstechtips.blogspot.com/2014/05/sharepoint-2013-visio-service-server.html

3. Share Point 2013 – Visio Graphics Not Displaying – The server failed to process the request
http://squarelogics.com/share-point-2013-visio-graphics-not-displaying-the-server-failed-to-process-the-request/

4. Troubleshooting workflow visualization in SharePoint 2010
http://www.robertseso.com/2012/02/troubleshooting-workflow-visualization.html

5. Visio 2010 Services Error – The server failed to process the request
http://www.sathishtk.com/blog/post/2010/02/04/Visio-2010-Beta-Services-Error-The-server-failed-to-process-the-request.aspx

Keywords:

  • Common Errors in SharePoint Visio Graphics Services
  • Troubleshooting workflow visualization in SharePoint 2010
  • SharePoint 2013 Visio Service the server failed to process the request
  • SharePoint 2010 Visio Service the server failed to process the request
  • Visio Graphics Not Displaying
  • workflow visualization error
  • workflow visualization not displaying visio
  • workflow visualization errors out
  • Visio Web Access errors
  • Visio Web Access can not display visio
  • Visio Web Access issues
Visit www.softvative.com for professional services.

SharePoint Excel Data Refresh Common Issues

Monday, November 3rd, 2014

SharePoint Excel Data Refresh – Common Issues

Version: 1.0

SharePoint Excel Services requires different bits and pieces to work correctly in order for it to deliver your BI Reports correctly. There are times when you have to review and update the configurations in order to make it work.

I’ll cover some of my experiences related to issues and fixes in working with the SharePoint Excel Services in this publication.

Common SharePoint Excel Services Issues

Following are the few common issues that can happen with SharePoint Excel Services and the resolution of those issues.

a. Unable to refresh data for a data connection in the workbook. … The following connections failed to refresh

a. Unable to refresh data for a data connection in the workbook. … The following connections failed to refresh

I created a nice report in Microsoft Excel using the SSAS (SQL Server Analysis Services) as the data source. I was able to refresh the data connection within MS Excel file to pull the latest data or apply filters to get the data I wanted. No issue so far and every thing looks great.

MS Excel Report with SSAS Data Connection - Data Refresh Option
MS Excel Report with SSAS Data Connection – Data Refresh Working

I uploaded my report to a Business Intelligence (BI) Center site on SharePoint. I launched the report using Excel Web Services and I was able to see the data. I got the following error when I tried to do the Data connection refresh in an attempt to pull the latest data from SSAS data source.

Error:
Unable to refresh data for a data connection in the workbook. Try again or contact your system administrator. The following connections failed to refresh:
SSASserverName – InstanceName SSAS database ProjectDW TimeReport

SharePoint Excel Service Excel Report with SSAS Data Connection - Data Refresh Error
SharePoint Excel Service Excel Report with SSAS Data Connection – Data Refresh Error

More precisely, here is the what the screen looked like. Also I couldn’t apply the filters and my nice report turned out to be ‘acting not so nicely’.

SharePoint Excel Service Excel Report with SSAS Data Connection - Data Refresh Error Fullpage
SharePoint Excel Service Excel Report with SSAS Data Connection – Data Refresh Error Fullpage

Issue Cause

I started the SharePoint Log Viewer on the server and then launched my Excel report again in Excel Web services to reproduce the error. Paused the live monitoring of the ULS logs and started reviewing the log information. I found the line item in the log pertaining to data refresh issue.

Area: Excel Services Application
Category: External Data
Event ID: 2052
Level: Information

Highlighting the log entry revealed the message detail about it.

The workbook ‘http://sharepoint.domain.com/sites/dept1/team2/deptsolutions/BI/Excel Analysis Reports/SPExcelBIReport_ByFM.xlsx’ attempted to access external data using the unsupported provider ‘Provider=MSOLAP.5;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=SSAS Project Control;Data Source=SSASServerNameInstanceName;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error’. [Session: 1.V21.3V9WQUVIjSGKsFX87MBjr90.5.en-US5.en-US73.+0360#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.289039c6-fe3c-4074-ac1f-48520e7f45a41.N User: 0#.w|domainfmasood]

SharePoint LogViewer - Excel Data Refresh error with SSAS Cube - Unsupported Data Provider Used
SharePoint LogViewer – Excel Data Refresh error with SSAS Cube – Unsupported Data Provider Used

Though, above information is sufficient clue to go about fixing the issue, I’m putting few more log entries that were logged for the same session.

Few ULS Log Entries:

1. 
ExternalSource.GetExternalKeyAndStateAndMarkUsed: Populating the session’s credentials for external data. Index=0, Credentials=[8126098, domainfmasood]

2. 
ConnectionRequest.ConnectionRequest: New connection request. SessionId=1.V21.3V9WQUVIjSGKsFX87MBjr90.5.en-US5.en-US73.+0360#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.289039c6-fe3c-4074-ac1f-48520e7f45a41.N, WorkbookVersion=ConnectionInfo.WorkbookVersion: Uri=http://sharepoint.domain.com/sites/dept1/team2/deptsolutions/BI/Excel Analysis Reports/SPExcelBIReport_ByFM.xlsx, Version=Thursday, 23 October 2014 19:19:17

3.
The workbook ‘http://sharepoint.domain.com/sites/dept1/team2/deptsolutions/BI/Excel Analysis Reports/SPExcelBIReport_ByFM.xlsx’ attempted to access external data using the unsupported provider ‘Provider=MSOLAP.5;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=SSAS Project Control;Data Source=SSASServerNameInstanceName;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error’. [Session: 1.V21.3V9WQUVIjSGKsFX87MBjr90.5.en-US5.en-US73.+0360#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.289039c6-fe3c-4074-ac1f-48520e7f45a41.N User: 0#.w|domainfmasood]

4. 
Refresh failed for ‘SSASServerName_InstanceName SSAS Project Control ProjectDW ProjectTimeReports’ in the workbook ‘http://sharepoint.domain.com/sites/dept1/team2/deptsolutions/BI/Excel Analysis Reports/SPExcelBIReport_ByFM.xlsx’. [Session: 1.V21.3V9WQUVIjSGKsFX87MBjr90.5.en-US5.en-US73.+0360#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.289039c6-fe3c-4074-ac1f-48520e7f45a41.N User: 0#.w|domainfmasood]

5.
ExternalSource.ValidateConnection: Unable to get a connection: Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionException: Exception of type ‘Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionException’ was thrown.     at Microsoft.Office.Excel.Server.CalculationServer.ConnectionManager.ValidateConnectionInfo(ConnectionRequest connectionRequest, ConnectionInfo connectionInfo)     at Microsoft.Office.Excel.Server.CalculationServer.ConnectionManager.GetConnection(ConnectionRequest connectionRequest, ExtendedConnectionInfo extendedConnInfo, Credentials credentials, Int64 privateConnectionId, Boolean auditConnection)     at Microsoft.Office.Excel.Server.CalculationServer.ExternalSource.TryGetValidatedConnection(Request request, Credentials credentials, Extended…

6.
…ConnectionInfo extendedConnectionInfo, Boolean shouldReportFailure, Boolean auditConnection, Connection& connectionOut). sessionId=1.V21.3V9WQUVIjSGKsFX87MBjr90.5.en-US5.en-US73.+0360#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.289039c6-fe3c-4074-ac1f-48520e7f45a41.N, externalSource=SSASServerName_InstanceName SSAS Project Control ProjectDW ProjectTimeReports

7.
ConnectionInfoManager.InitConnInfoFromOdcFile: ODC File Uri is local: C:UsersfmasoodDocumentsMy Data SourcesSSASServerName_InstanceName SSAS Project Control ProjectDW ProjectTimeReports.odc

8.
ExternalSource.ExecuteOperation: We exhausted all available connection information. Exception: Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionInfoException: Exception of type ‘Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionInfoException’ was thrown.     at Microsoft.Office.Excel.Server.CalculationServer.ConnectionInfoManager.GetConnectionInfo(Request request, String externalSourceName, Int32 externalSourceIndex, Boolean& shouldReportFailure)     at Microsoft.Office.Excel.Server.CalculationServer.ExternalSource.ExecuteOperation(Request request, ExternalSourceStateInfo externalSourceStateInfo, ExternalSourceStateInfo prevExternalSourceStateInfo, Int32 index, ConnectionInfoManager connectionInfoManager, ExternalDataScenario scenario, DataOperation dataOpe…

9.
…ration, Boolean verifyPreOperationConnection), Data Connection Name: SSASServerName_InstanceName SSAS Project Control ProjectDW ProjectTimeReports, SessionId: 1.V21.3V9WQUVIjSGKsFX87MBjr90.5.en-US5.en-US73.+0360#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.289039c6-fe3c-4074-ac1f-48520e7f45a41.N, UserId: 0#.w|domainfmasood

10.
ExcelService.PostProcessRequest: finished request of type RefreshAll

Issue Resolution

I went to SharePoint Central Administration site and reviewed the Trusted Data Providers under Excel Services. The location of the configuration is Central Admin home > Application Management > Manage Service Applications > Click on your Excel Service Application > Trusted Data Providers.

In SharePoint 2010, MSOLAP.5 data provider is not present default. See the screenshot below.

SharePoint Excel Services - Trusted Data Provider - MSOLAP.5 not present by default
SharePoint Excel Services – Trusted Data Provider – MSOLAP.5 not present by default

Click on Add Trusted Data Provider link on top left and configure the MSOLAP.5 data provider.

SharePoint Excel Services - Trusted Data Provider - Configure MSOLAP.5 Data Provider
SharePoint Excel Services – Trusted Data Provider – Configure MSOLAP.5 Data Provider

Once added, you should see the MSOLAP.5 data provider in the list.

SharePoint Excel Services - Trusted Data Provider - MSOLAP.5 Data Provider Added
SharePoint Excel Services – Trusted Data Provider – MSOLAP.5 Data Provider Added

Once I had the MSOLAP.5 added as the Trusted Data Provider, in excel services, refresh all data connection feature started working. At that point I was also able to use filters in my report without any errors.

My SharePoint BI report lived happily ever after.

References:
1. Primer on SharePoint Excel Data Refresh Settings
2. SQL Server Version Numbers
3. Excel Services Data Refresh Flowchart – Review the screenshot titled E and section E in the table at bottom right for information related to this issue.
4. Add MSOLAP.5 as a Trusted Data Provider in Excel Services
5. How to: Install the Analysis Services OLE DB Provider on an Excel Services Computer

Keywords:

  • Fix Excel Data Refresh Issue
  • Fix Excel Data Refresh error
  • Fix Excel Data Refresh connection failure
  • Excel Data Refresh Issue
  • Excel Data Refresh connection failure
  • Data refresh issue due to MSOLAP.5
  • Missing Data Provider MSOLAP.5
  • Adding a new Trusted Data Provider
  • Trusted Data Provider in Excel Services
  • Trusted Data Provider in SharePoint Excel Services
  • Unable to Refresh SSAS Data from Excel
  • Event ID 2052
  • External Data Connection Failure
  • External Data Refresh Failure
  • SharePoint BI Report Refresh Issue
  • SharePoint BI Report data Refresh Issue
  • How to fix Excel Data Connection issue
  • How to fix Excel Data refresh issue
  • How to fix Excel Data Connection refresh issue
  • Get the real time data in Excel Services

SharePoint 2010 Kerberos Delegation

Monday, May 5th, 2014
Kerberos Delegation Can Cross Domain Boundry Can Cross Forest Boundary
Basic Yes No
Constrained No No
Note:
Have the SharePoint and external data on same Active Directory Domain
SharePoint Service Application Kerberos Delegation Type
Excel Services Constrained Delegation
Performance Point Services Constrained Delegation
InfoPath Forms Services Constrained Delegation
Visio Services Constrained Delegation
BDC / BCS Basic or Constrained Delegation
Access Services Basic or Constrained Delegation
SQL Reporting Services SSRS Basic or Constrained Delegation
MS Project Server Basic or Constrained Delegation
Note:
1. Kerberos delegation method can only change from basic to constrained as identity travels between services to services
2. Services require translation of claims based credentials to Windows credentials. The Process of translation uses C2WTS service
3. C2WTS must be constrained

Excerpt from:

Configuring Kerberos Authentication for Sharepioint 2010 Products

PerformancePoint Unable to Create Report QueryProducedTooManyResults

Tuesday, April 29th, 2014
Issue Summary:
In SharePoint 2010, using PerformancePoint Dashboard Designer tool, you are trying to create report and it brings the following message:Unable to create report. Query produced too many results.
Contact the administrator for more details.

Event Viewer Errors on SharePoint App Server:

Error 1:
Log Name:      Application
Source:        Microsoft-SharePoint Products-PerformancePoint Service
Date:          2/4/2014 11:37:55 AM
Event ID:      1
Task Category: PerformancePoint Services
Level:         Error
Keywords:      
User:          DomainSPFarmAct
Computer:      SrvApp02.domain.com
Description:
An exception occurred while running a report.  The following details may help you to diagnose the problem:
Error Message: Error running data source query.
<br>
<br>
Contact the administrator for more details.
Dashboard Name: 
Dashboard Item name: 
Report Location: {6ed9a727-029b-1e22-d81a-f39274d4d9e2}
Request Duration: 300,564.30 ms
User: DomainBIDeveloper
Parameters: 
Exception Message: Error running data source query.
Inner Exception Message: 
Stack Trace:    at Microsoft.PerformancePoint.Scorecards.Server.PmServer.ExecuteAnalyticReportWithParameters(RepositoryLocation 
analyticReportViewLocation, BIDataContainer biDataContainer)
   at Microsoft.PerformancePoint.Analytics.ServerRendering.OLAPBase.OlapViewBaseControl.ExtractReportViewData()
   at Microsoft.PerformancePoint.Analytics.ServerRendering.OLAPBase.OlapViewBaseControl.CreateRenderedView(StringBuilder sd)
   at Microsoft.PerformancePoint.Scorecards.ServerRendering.NavigableControl.RenderControl(HtmlTextWriter writer)

PerformancePoint Services error code 20604.
Event Xml:
<Event xmlns=”http://schemas.microsoft.com/win/2004/08/events/event”>
  <System>
    <Provider Name=”Microsoft-SharePoint Products-PerformancePoint Service” Guid=”{A7CD5295-CBBA-4DCA-8B67-D5BE061B6FAE}” />
    <EventID>1</EventID>
    <Version>14</Version>
    <Level>2</Level>
    <Task>1</Task>
    <Opcode>0</Opcode>
    <Keywords>0x4000000000000000</Keywords>
    <TimeCreated SystemTime=”2014-04-18T16:37:55.171984000Z” />
    <EventRecordID>603586</EventRecordID>
    <Correlation ActivityID=”{43305F92-CD1F-4E75-B19B-2581FE7C04CD}” />
    <Execution ProcessID=”6420″ ThreadID=”6468″ />
    <Channel>Application</Channel>
    <Computer>SrvApp02.domain.com</Computer>
    <Security UserID=”S-1-5-41-1623458274-11437692956-399368559-1726″ />
  </System>
  <EventData>
    <Data Name=”string1″>An exception occurred while running a report.  The following details may help you to diagnose the problem:
Error Message: Error running data source query.
&lt;br&gt;
&lt;br&gt;
Contact the administrator for more details.
Dashboard Name: 
Dashboard Item name: 
Report Location: {6ed9a727-029b-1e22-d81a-f39274d4d9e2}
Request Duration: 300,564.30 ms
User: DomainBIDeveloper

Parameters: 
Exception Message: Error running data source query.
Inner Exception Message: 
Stack Trace:    at Microsoft.PerformancePoint.Scorecards.Server.PmServer.ExecuteAnalyticReportWithParameters(RepositoryLocation 

analyticReportViewLocation, BIDataContainer biDataContainer)
   at Microsoft.PerformancePoint.Analytics.ServerRendering.OLAPBase.OlapViewBaseControl.ExtractReportViewData()
   at Microsoft.PerformancePoint.Analytics.ServerRendering.OLAPBase.OlapViewBaseControl.CreateRenderedView(StringBuilder sd)
   at Microsoft.PerformancePoint.Scorecards.ServerRendering.NavigableControl.RenderControl(HtmlTextWriter writer)
PerformancePoint Services error code 20604.</Data>
  </EventData>
</Event>

Error 2:
Log Name:      Application
Source:        Microsoft-SharePoint Products-PerformancePoint Service
Date:          2/4/2014 11:37:55 AM
Event ID:      2
Task Category: PerformancePoint Services
Level:         Warning
Keywords:      
User:          DomainSPFarmAct
Computer:      SrvApp02.domain.com
Description:
Error running data source query.
XML for Analysis parser: The XML for Analysis request timed out before it was completed.

Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: XML for Analysis parser: The XML for Analysis request timed out before it was completed.
   at 
Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IExecuteProvider.ExecuteMultidimensional(ICommandContentProvider contentProvider, AdomdPropertyCollection commandProperties, IDataParameterCollection parameters)
   at Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteCellSet()
   at Microsoft.PerformancePoint.Scorecards.DataSourceProviders.AdomdDataSourceProvider.RunQueryInternal(String query, Boolean 
isCellSet, Int32 sessionTimeout)

PerformancePoint Services error code 10116.
Event Xml:
<Event xmlns=”http://schemas.microsoft.com/win/2004/08/events/event”>
  <System>
    <Provider Name=”Microsoft-SharePoint Products-PerformancePoint Service” Guid=”{A7CD5295-CBBA-4DCA-8B67-D5BE061B6FAE}” />
    <EventID>2</EventID>
    <Version>14</Version>
    <Level>3</Level>
    <Task>1</Task>
    <Opcode>0</Opcode>
    <Keywords>0x4000000000000000</Keywords>
    <TimeCreated SystemTime=”2014-04-18T16:37:55.156358900Z” />
    <EventRecordID>603585</EventRecordID>
    <Correlation ActivityID=”{43305F92-CD1F-4E75-B19B-2581FE7C04CD}” />
    <Execution ProcessID=”6420″ ThreadID=”6468″ />
    <Channel>Application</Channel>
    <Computer>SrvApp02.domain.com</Computer>
    <Security UserID=”S-1-5-21-1627688274-1190192956-3999157559-1626″ />
  </System>
  <EventData>
    <Data Name=”string1″>Error running data source query.
XML for Analysis parser: The XML for Analysis request timed out before it was completed.

Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: XML for Analysis parser: The XML for Analysis request timed out before it was completed.
   at 
Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IExecuteProvider.Ex

ecuteMultidimensional(ICommandContentProvider contentProvider, AdomdPropertyCollection commandProperties, IDataParameterCollection 

parameters)
   at Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteCellSet()
   at Microsoft.PerformancePoint.Scorecards.DataSourceProviders.AdomdDataSourceProvider.RunQueryInternal(String query, Boolean 
isCellSet, Int32 sessionTimeout)

PerformancePoint Services error code 10116.</Data>
  </EventData>
</Event>

Resolution:
I went to Central Admin > Manage Service Applications > PerformancePoint Service Application Settings and found these default settings.

There wasn’t any relevant setting. I then used Power shell commands.

Run this PowerShell Get command to see current values.
Get-SPPerformancePointServiceApplication -identity “PerformancePoint Service Application”

Then run following PowerShell to set a higher value for AnalyticQueryCellMax.
Set-SPPerformancePointServiceApplication -identity “PerformancePoint Service Application” -AnalyticQueryCellMax 10000000

References:
1. http://technet.microsoft.com/en-us/library/ee906547(v=office.14).aspx
2. http://social.technet.microsoft.com/Forums/en-US/3e676663-0d5f-4cbf-9694-14e82772c8e6/unable-to-create-report-query-produced-too-many-results?forum=ppsmonitoringandanalytics