This issue is fixed in SharePoint 2013 SP1 (Released Feb 25th 2014):
Update center for Office, Office servers, and related productshttp://technet.microsoft.com/en-US/office/ee748587.aspx
Issue:
"Call to Excel Services returned an error" when performing a Scheduled Data Refresh.
In the ULS logs, you will see:
w3wp.exe (0x0A28) 0x0DB8 PowerPivot Service Data Refresh 99 High EXCEPTION: System.InvalidOperationException: Call to Excel Services returned an error. ---> Microsoft.AnalysisServices.SPClient.Interfaces.ExcelServicesException: We're sorry. We can't open the workbook in the browser because it uses these unsupported features: • Shapes or other objects ---> Microsoft.Office.Excel.Server.WebServices.ExcelServerApiException: We're sorry. We can't open the workbook in the browser because it uses these unsupported features: • Shapes or other objects at Microsoft.Office.Excel.Server.WebServices.ApiShared.ExecuteServerSessionMethod(Boolean hasSessionId, String sessionId, CoreServerSessionMethod coreWebMethod, String name, Boolean skipFeatureCheck) at Microsoft.Office.Excel.Server.WebServices.ExcelServiceInternal.OpenWorkbookInternal(String workbookPath, Boolean editingMode, String uiCultureName, String dataCultureName, Boolean newWorkbook, Boolean suppressRefreshOnOpen, Boolean openExclusive, Status[]& status) at Microsoft.Office.Excel.Server.WebServices.ExcelServiceInternal.OpenWorkbookEx(String workbookPath, String uiCultureName, String dataCultureName, Boolean exclusive, Status[]& status) at Microsoft.AnalysisServices.SPClient.ExcelApi.<>c__DisplayClassa.<OpenWorkbookEx>b__9(ExcelService svc, Status[]& status) at Microsoft.AnalysisServices.SPClient.ExcelApi.Call[T](String fileUrl, ExcelServiceCall`1 serviceCall) --- End of inner exception stack trace --- --- End of inner exception stack trace --- at Microsoft.AnalysisServices.SPClient.ExcelApi.Call[T](String fileUrl, ExcelServiceCall`1 serviceCall) at Microsoft.AnalysisServices.SPClient.ExcelApi.Call[T](String fileUrl, ExcelServiceCall`1 serviceCall, String methodName, Object[] parameters) at Microsoft.AnalysisServices.SPClient.ExcelApi.OpenWorkbookEx(String fileUrl, String uiCultureName, String dataCultureName, Boolean exclusive) at Microsoft.AnalysisServices.SPClient.ASSPClientProxy.OpenWorkbookModelForRefresh(String workbookPath, SessionLifetimePolicy lifetimePolicy) at Microsoft.AnalysisServices.SPAddin.DataRefresh.DataRefreshService.ProcessingJob(Object parameters)
This is a rather generic error message. However, we have seen several cases where the Scheduled Data Refresh fails because of Unsupported Features in the workbook.
We have a tool that you can use to remove these Unsupported Features.
Excel Services Compatibility Checker Download Page
http://blogs.msdn.com/b/cumgranosalis/archive/2007/06/29/excel-services-compatibility-checker-download-page.aspx
First install the "Excel Services Compatibility Checker Add-In". As you can see a tab called "Excel Services" will appear in the ribbon (may need to restart Excel). Now you can remove the Unsupported Features by choosing "Quick Fix". I do suggest creating a copy (back up) of the workbook. After you have removed the Unsupported Features, republish to the PowerPivot Gallery and run a Scheduled Data Refresh.
Excel Services Compatibility Checker Add in - Beta
http://blogs.msdn.com/b/cumgranosalis/archive/2007/06/29/excel-services-compatibility-checker-addin-beta.aspx
Other Resources:
Differences between using a workbook in Excel and Excel Services
http://office.microsoft.com/en-us/excel-help/differences-between-using-a-workbook-in-excel-and-excel-services-HA010021716.aspx
Excel Services part 12: Unsupported features
http://blogs.office.com/b/microsoft-excel/archive/2005/12/01/excel-services-part-12-unsupported-features.aspx
Excel Services in SharePoint 2010 Feature Support
http://blogs.msdn.com/b/excel/archive/2009/11/19/excel-services-in-sharepoint-2010-feature-support.aspx
Edit a workbook that contains features unsupported by Excel Web App
http://office.microsoft.com/en-us/web-apps-help/edit-a-workbook-that-contains-features-unsupported-by-excel-web-app-HA102540964.aspx
Again, this is somewhat of a generic message, so this may or may not resolve your issue, but it is definitely worth testing.
Other FIX: You may also see this error in the ULS logs:
w3wp.exe (0x0A28) 0x0AC8 PowerPivot Service Data Refresh 99 High EXCEPTION: System.InvalidOperationException: Call to Excel Services returned an error. ---> Microsoft.AnalysisServices.SPClient.Interfaces.ExcelServicesException: You don't have permission to save your workbook here. ---> Microsoft.Office.Excel.Server.WebServices.ExcelServerApiException: You don't have permission to save your workbook here. at Microsoft.Office.Excel.Server.WebServices.ApiShared.ExecuteServerSessionMethod(Boolean hasSessionId, String sessionId, CoreServerSessionMethod coreWebMethod, String name, Boolean skipFeatureCheck) at Microsoft.Office.Excel.Server.WebServices.ExcelServiceInternal.SaveWorkbookCopy(String sessionId, String workbookPath, WorkbookType workbookType, SaveOptions saveOptions, Status[]& status) at Microsoft.AnalysisServices.SPClient.ExcelApi.<>c__DisplayClass10.<SaveWorkbookCopy>b__f(ExcelService svc, Status[]& status) at Microsoft.AnalysisServices.SPClient.ExcelApi.<>c__DisplayClass13.<Call>b__12(ExcelService e, Status[]& status) at Microsoft.AnalysisServices.SPClient.ExcelApi.Call[T](String fileUrl, ExcelServiceCall`1 serviceCall) --- End of inner exception stack trace --- --- End of inner exception stack trace --- at Microsoft.AnalysisServices.SPClient.ExcelApi.Call[T](String fileUrl, ExcelServiceCall`1 serviceCall) at Microsoft.AnalysisServices.SPClient.ExcelApi.Call(String fileUrl, ExcelServiceCall serviceCall, String methodName, Object[] parameters) at Microsoft.AnalysisServices.SPAddin.DataRefresh.DataRefreshService.ProcessingJob(Object parameters)
To fix this, you will need to give the account running PowerPivot Full Control to the Web App under Policy for Web Application.
After upgrading your SharePoint 2010 PowerPivot server to be at SQL 2012 SP1 level you get data refresh failures and this error in the logs:
EXCEPTION: Microsoft.AnalysisServices.SharePoint.Integration.Redirector.RedirectorException: This request could not be redirected to a PowerPivot for SharePoint server. An internal error occurred. Please look in the SharePoint logs for more information or contact the administrator of this farm. --->
System.Data.SqlClient.SqlException: Procedure or function UpdateRunProcessTimeWindow has too many arguments specified.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, BooleanbreakConnection)
...
Cause:
It appears that the "PowerPivot Configuration tool" which needs to be ran after the SQL service pack does not update the PowerPivotServiceApplicationDB SQL database correctly. (We are still researching this)
This causes a mismatch between the updated DLL's and the database on the number of parameters to use on the UpdateRunProcessTimeWindow stored procedure.
Workaround:
The workaround is to manually update your PowerPivotServiceApplicationDB. Follow steps below:
The steps above will redefine the stored procedure so that it matches what the updated DLL's are looking for.
You may receive the following error when trying to view an Excel chart or graph on a website using Excel Services in SharePoint:
The maximum number of allowed sessions per user has been exceeded. The operation cannot be completed.
To fix this error, go to SharePoint Central Administration > Application Management > Service Applications > Manage service applications > Excel Services application > Global Settings. In the Session Management section, increase the value for Maximum Sessions Per User.
If this does not fix the error, you may be using anonymous authentication, for example when your site is on a public website. For the Maximum Sessions Per User setting, a user is an authenticated user. When anonymous access is enabled in SharePoint, all the users hitting the site are anonymous users, which maps to a single internal account that is authenticated to retrieve the data. So the maximum sessions setting applies to the same pool of sessions for all users.
If you are using anonymous authentication, you will see the following error in the SharePoint ULS log:
SessionManager.CheckAndUpdateSessionsPerUser: Throwing MaxSessionsPerUserExceeded SessionException. User=NT AUTHORITY\ANONYMOUS LOGON Count=25
There is a separate setting for anonymous users that is not exposed in the Excel Services settings in the SharePoint Central Administration GUI. The setting is called SiteCollectionAnonymousSessionsMax. To modify the setting, go to Start > Programs > Microsoft SharePoint > SharePoint Management Shell. Run the following command:Get-SPExcelServiceApplication | format-list *Look for the SiteCollectionAnonymousSessionsMax setting, It will most likely be set to 25 as this is the default setting. Also note the value of DisplayName which refers to the name of the Excel Services application. To change the session setting, for example to 500 sessions, run the following command, replacing DisplayName with the DisplayName value:Set-SPExcelServiceApplication -identity DisplayName -SiteCollectionAnonymousSessionsMax 500
You may need to restart IIS. After making this change, users will not receive the error and should be able to view the Excel chart or graph successfully.