本文介绍了Excel Services不再起作用,用户无法使用owa/wac在SharePoint 2013中打开Excel文件的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

使用owa/wac在SharePoint中打开Excel文件时,用户得到以下错误

Users are getting the following error when opening Excel files in SharePoint with owa/wac

" " 我们关于 对不起.我们在完成您的请求时遇到了问题.请在几分钟后再试一次."

""We’re sorry. We ran into a problem completing your request. Please try that again in few minutes."

我在服务器场中运行excel服务的服务器上的事件查看器中收到以下错误消息:

I get the following error message in event viewer on the server that is running excel services in the farm:

" WebHost无法处理请求.
发件人信息:System.ServiceModel.ServiceHostingEnvironment + HostingManager/62476613
 异常:System.ServiceModel.ServiceActivationException:由于编译期间发生异常,因此无法激活服务"/2267cd76cf664633853a5b190bc6cd10/ExcelService.asmx".异常消息是:服务器场不可用. System.InvalidOperationException:服务器场不可用.
    at Microsoft.SharePoint.Administration.Claims.SPSecurityTokenServiceManager.get_Local()
    at Microsoft.SharePoint.IdentityModel.SPServiceIssuerNameRegistry..ctor()
    at Microsoft.SharePoint.SPServiceHostOperations.Configure(ServiceHostBase serviceHost,SPServiceAuthenticationMode authenticationMode)
    at Microsoft.Office.Excel.Server.MossHost.MossHost.ConfigureServiceHost(ServiceHost serviceHost)
    at Microsoft.Office.Excel.Server.CalculationServer.ExcelServiceHostFactory.CreateServiceHost(类型serviceType,Uri [] baseAddresses)
    at System.ServiceModel.Activation.ServiceHostFactory.CreateServiceHost(字符串ConstructorString,Uri [] baseAddresses)
    at System.ServiceModel.ServiceHostingEnvironment.HostingManager.CreateService(字符串normalizedVirtualPath,EventTraceActivity eventTraceActivity)
    at System.ServiceModel.ServiceHostingEnvironment.HostingManager.ActivateService(ServiceActivationInfo serviceActivationInfo,EventTraceActivity eventTraceActivity)
    at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath,EventTraceActivity eventTraceActivity)
    ---内部异常堆栈跟踪的结尾---
    at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath,EventTraceActivity eventTraceActivity)
    at System.ServiceModel.ServiceHostingEnvironment.EnsureServiceAvailableFast(String relativeVirtualPath,EventTraceActivity eventTraceActivity)
进程名称:w3wp
 进程ID:28692"

"WebHost failed to process a request.
 Sender Information: System.ServiceModel.ServiceHostingEnvironment+HostingManager/62476613
 Exception: System.ServiceModel.ServiceActivationException: The service '/2267cd76cf664633853a5b190bc6cd10/ExcelService.asmx' cannot be activated due to an exception during compilation.  The exception message is: The farm is unavailable.. ---> System.InvalidOperationException: The farm is unavailable.
   at Microsoft.SharePoint.Administration.Claims.SPSecurityTokenServiceManager.get_Local()
   at Microsoft.SharePoint.IdentityModel.SPServiceIssuerNameRegistry..ctor()
   at Microsoft.SharePoint.SPServiceHostOperations.Configure(ServiceHostBase serviceHost, SPServiceAuthenticationMode authenticationMode)
   at Microsoft.Office.Excel.Server.MossHost.MossHost.ConfigureServiceHost(ServiceHost serviceHost)
   at Microsoft.Office.Excel.Server.CalculationServer.ExcelServiceHostFactory.CreateServiceHost(Type serviceType, Uri[] baseAddresses)
   at System.ServiceModel.Activation.ServiceHostFactory.CreateServiceHost(String constructorString, Uri[] baseAddresses)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.CreateService(String normalizedVirtualPath, EventTraceActivity eventTraceActivity)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.ActivateService(ServiceActivationInfo serviceActivationInfo, EventTraceActivity eventTraceActivity)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath, EventTraceActivity eventTraceActivity)
   --- End of inner exception stack trace ---
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath, EventTraceActivity eventTraceActivity)
   at System.ServiceModel.ServiceHostingEnvironment.EnsureServiceAvailableFast(String relativeVirtualPath, EventTraceActivity eventTraceActivity)
 Process Name: w3wp
 Process ID: 28692"

我尝试了以下操作:

_重新启动Excel Calculation Services.

_Restarting Excel Calculation Services.

_回收服务的应用程序池

_Recycling the app pool for the service

__检查了excel服务帐户的密码是否有效.

_Checked the account for excel services that password is valid.

_Ran"Get-SPExcelServiceApplication";在powershell中,并获得了excel服务作为输出.

_Ran "Get-SPExcelServiceApplication" in powershell and got the excel service as an output.

_ 已检查Excel 服务应用程序已与Web应用程序相关联 有问题.

_Checked that Excel Service Application is associated to Web Application in question.

_  检查是否为Excel Service Application配置了受信任文件位置.

_ Checked if Trusted File Location is configured for Excel Service Application.

excel服务运行良好,直到昨晚为止,最近该农场没有任何变化.

The excel service ran smoothly until last night, there has not been any changes to the farm lately.

请问关于如何解决此问题的任何想法?

Any ideas please on how to resolve this issue ?

推荐答案

您是否更改了服务帐户或服务器场帐户的密码?

Did you change the password of the service account or farm account?

要解决此问题,请检查以下内容:

To troubleshoot the issue, check things below:

1.检查文件"/2267cd76cf664633853a5b190bc6cd10/ExcelService.asmx"的权限.

1. Check the permission on the file "/2267cd76cf664633853a5b190bc6cd10/ExcelService.asmx".

  转到IIS-> Sites->展开"SharePoint Web服务"站点->查找并选择"2267cd76cf664633853a5b190bc6cd10"->在右侧面板中单击内容视图->选择并右键单击"ExcelService.asmx",然后选择编辑权限->单击 安全"标签->检查当前用户是否对该文件具有权限.

 Go to IIS->Sites-> expand "SharePoint Web Service" site->find and select "2267cd76cf664633853a5b190bc6cd10"->click content view in the right panel->select and right click "ExcelService.asmx" and select edit permission->click "Security" tab->check if the current user has the permission on the file.

2.更改SharePoint Web Services根应用程序池的标识.

2. Change the identity of the SharePoint Web Services Root application pool.

转到IIS->应用程序池->右键单击"SharePoint Web服务根",然后选择高级设置"->将标识更改为SharePoint服务器场帐户.

Go to IIS->Application Pools->Right click "SharePoint Web Services Root" and select "advanced settings"->change the Identity to a SharePoint farm account.

3.禁用SharePoint Web Services网站的ASP.Net模拟身份验证.

3. Disable ASP.Net Impersonation authentication for SharePoint Web Services Site.

转到IIS->站点->选择"SharePoint Web服务"站点->从右侧面板中选择身份验证"->禁用ASP.NET模拟"(如果启用).

Go to IIS->Sites->select "SharePoint Web Service" site->select "Authentication" from the right panel->Disable ASP.NET Impersonation if enabled.

更多参考:

Excel Services应用程序问题(SP 2010/2013).

Excel Services Application issues (SP 2010/2013).

https://collab365.community/excel-services-application-issues-sp- 2010-2013/

最诚挚的问候,

萨拉范


这篇关于Excel Services不再起作用,用户无法使用owa/wac在SharePoint 2013中打开Excel文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

10-26 20:26