无法为没有外部数据源的工作簿启用计划 [英] A schedule cannot be enabled for a workbook with no external data sources
问题描述
大家好，
首先，这里有一点关于我的SharePoint 2016安装
First of all, here is a bit about my SharePoint 2016 installation
SpWeb = SharePoint前端
SpWeb = SharePoint front end
SpApp = SharePoint应用程序服务器
SpApp = SharePoint application server
SpDB = SharePoint数据库
SpDB = SharePoint Database
OOS = Office在线服务器
OOS = Office online server
分析服务器=服务器运行分析服务以托管PowerPivot模型
Analysis Server = Server running Analysis services to host PowerPivot model
========== =====
===============
对于配置，我使用了以下演练
For configuration I used following walkthroughs
https://docs.microsoft.com/en-us/sql/analysis-services/instances/install-windows/install-or-uninstall-the-power-pivot-for-sharepoint-add-in-sharepoint-2016?view=sql-server-2017 (Installation)
https://docs.microsoft.com/en-us/sql/analysis-services/instances/install-windows/configure-power-pivot-and-deploy-solutions-sharepoint-2016?view=sql-server-2017 (Configuration)
https://docs.microsoft.com/en- us / sql / analysis-services / instances / install-windows / configure-analysis-services-and-kerberos-constrained-delegation-kcd？view = sql-server-2017
（配置Analysis Services）
https://docs.microsoft.com/en-us/sql/analysis-services/instances/install-windows/configure-analysis-services-and-kerberos-constrained-delegation-kcd?view=sql-server-2017 (Configure Analysis Services)
这一切似乎都很好，powerpivot正在加载excel在线数据，我也可以看到Analysis服务中的模型，这样就可以了。
All this seems absolutely fine, the powerpivot is loading the data in excel online and also I can see the models in Analysis services so that's all fine.
我遇到的唯一问题是时间表刷新无效。当我进入管理PowerPivot数据刷新时，始终禁用[启用]复选框，红色文本读数为"无法为没有外部数据源的工作簿启用计划"。
The only problem I'm having is schedule refresh is not working. When I go to Manage PowerPivot Data refresh, [Enabled] checkbox is always disabled with the red text reading "A schedule cannot be enabled for a workbook with no external data sources".
这些错误记录在SharePoint中
These errors are logged in SharePoint
- EXCEPTION：System.NullReferenceException：对象引用未设置为对象的实例。
at Microsoft.Office.Excel.Server.WebServices.ExcelService。<> c__DisplayClass72。< EnsureWorkbookModel> b__70（ExcelServiceInternal service，ProxyServiceResult`1 result）
- EXCEPTION: System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.Office.Excel.Server.WebServices.ExcelService.<>c__DisplayClass72.<EnsureWorkbookModel>b__70(ExcelServiceInternal service, ProxyServiceResult`1 result)
at Microsoft.Office.Excel.Server.WebServices.ApiProxy.RunProxyAction [TResult]（Action`2 proxyAction，ProxyServiceResult`1 result，Int32 retriesRemaining） &NBSP;
at Microsoft.Office.Excel.Server.WebServices.ApiProxy.RunProxyAction[TResult](Action`2 proxyAction, ProxyServiceResult`1 result, Int32 retriesRemaining)
at Microsoft.Office.Excel.Server.WebServices.ExcelService.EnsureWorkbookModel（String sessionId，Status []& status）
at Microsoft.Office.Excel.Server.WebServices.ExcelService.EnsureWorkbookModel(String sessionId, Status[]& status)
at Microsoft.AnalysisServices.SPClient16.ExcelApi.Call [T]（String fileUrl，ExcelServiceCall`1 serviceCall） Microsoft.AnalysisServices.SPClient16.ExcelApi.Call [T]（String fileUrl，ExcelServiceCall`1 serviceCall，String methodName，Object [] parameters）
at Microsoft.AnalysisServices.SPClient16.ExcelApi.Call[T](String fileUrl, ExcelServiceCall`1 serviceCall)
;
at Microsoft.AnalysisServices.SPClient16.ExcelApi.EnsureWorkbookModel（String fileUrl，String sessionId）
at Microsoft.AnalysisServices.SPClient16.ExcelApi.EnsureWorkbookModel(String fileUrl, String sessionId)
at Microsoft.AnalysisServices.SPClient16.WorkbookSession.ForcePing（）
at Microsoft.AnalysisServices.SPClient16.WorkbookSession.ForcePing()
at Microsoft.AnalysisServices.SPClient16.ASSPClient16Proxy.OpenWorkbookModel（String workbookPath，SessionLifetimePolicy lifetimePolicy） Microsoft.AnalysisServices.SPAddin16.GeminiServiceApplication.GetWorkbookConnections（String workbookUrl，Int32& embeddedModelVersion，Boolean& hasEmbeddedModel）
at Microsoft.AnalysisServices.SPClient16.ASSPClient16Proxy.OpenWorkbookModel(String workbookPath, SessionLifetimePolicy lifetimePolicy)
at Microsoft.AnalysisServices.SPAddin16.GeminiServiceApplicationProxy.GetWorkbookConnections（String workbookUrl，Int32& embeddedModelVersion，Boolean& hasEmbeddedModel）
at Microsoft.AnalysisServices.SPAddin16.GeminiServiceApplicationProxy.GetWorkbookConnections(String workbookUrl, Int32& embeddedModelVersion, Boolean& hasEmbeddedModel)
at Microsoft.AnalysisServices.SPAddin16.DataRefresh.DataRefreshSchedule.LoadDataSourceList（SPFile file，Int32& workbookVersion）
at Microsoft.AnalysisServices.SPAddin16.DataRefresh.DataRefreshSchedule.LoadDataSourceList(SPFile file, Int32& workbookVersion)
at Microsoft.AnalysisServices.SPAddin16.DataRefresh.DataRefreshSchedule.LoadSchedule（SPListItem item）
at Microsoft.AnalysisServices.SPAddin16.DataRefresh.DataRefreshSchedule.LoadSchedule(SPListItem item)
不确定现在该做什么，感谢任何帮助。
Not Sure what to do now, any help is appreciated.
Agha Usman Ahmed http://www.aghausman.net
Agha Usman Ahmed http://www.aghausman.net
推荐答案
您好Agha，
Hi Agha,
尝试解决您的问题，如下所示：
Try to troubleshoot your issue as following:
使用PowerShell命令增加OOS服务器中的最大工作簿大小。
Use PowerShell command to Increase the Maximum Workbook Size in OOS server.
Set-OfficeWebAppsFarm -ExcelWorkbookSizeMax 250
Set-OfficeWebAppsFarm -ExcelWorkbookSizeMax 250
正确启用数据连接。
您可以查看以下文章：
检查在SharePoint（PowerPivot应用程序池）中运行PowerPivot系统服务的帐户是否具有User Profile Service应用程序的权限：
Check if the account running the PowerPivot System Service in SharePoint (PowerPivot application pool) has permissions on the User Profile Service Application:
祝你好运，
Grace Wang
Grace Wang
这篇关于无法为没有外部数据源的工作簿启用计划的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
