felonyone
asked on
Excel Services is unable to process the request. Wait a few minutes and try performing this operation again.
I receive the error in the title whenever I attempt to open an .XLSX file on my Sharepoint 2010 site by directly clicking the name of the file. If I select Edit in Microsoft Excel it opens fine. However, I can't figure out why I am receiving the error above when I simply click the file. My users will intuitively click the file name rather then selecting Edit in Excel from the drop down menu. Thus, I would like to fix this error before I have to inform the entire company that you must Edit the sheet in Excel.
Here are the steps I have already taken:
- Rebooted the server
- Double Checked that Excel Web Services is running in Central Administration
- Trust File location is set to http, which I assume means the entire sharepoint site.
Also, I have attached the logs pertaining to the time in which I attempted to open the XLSX file from my sharepoint site.
Please help!!!
Here are the steps I have already taken:
- Rebooted the server
- Double Checked that Excel Web Services is running in Central Administration
- Trust File location is set to http, which I assume means the entire sharepoint site.
Also, I have attached the logs pertaining to the time in which I attempted to open the XLSX file from my sharepoint site.
Please help!!!
10/04/2010 11:06:28.25 w3wp.exe (0x122C) 0x1150 Excel Services Excel Services Web Front End 144h Medium ServerSession.StampLastSentRequest: server http://LBYCOMM:32843/2ccc0cb260854290827aa9e89b097aee/ExcelService*.asmx [id: 66c0768b-ed20-4b73-9b36-a248e8ffe529] is on probation
10/04/2010 11:06:28.25 w3wp.exe (0x122C) 0x1150 Excel Services Excel Calculation Services d51n Medium MossHost.GetEndpointAddress: Server endpoint Uri: http://lbycomm:32843/2ccc0cb260854290827aa9e89b097aee/ExcelService.asmx.
10/04/2010 11:06:28.28 w3wp.exe (0x122C) 0x1150 SharePoint Foundation Claims Authentication 8306 Critical An exception occurred when trying to issue security token: Method not found: 'Boolean System.IdentityModel.Selectors.SecurityTokenRequirement.get_IsOptionalToken()'..
10/04/2010 11:06:28.28 w3wp.exe (0x122C) 0x1150 Excel Services Excel Calculation Services d51d Medium MossHost.CreateServiceChannel<IExcelServiceSoap>: Failed with the following exception: System.MissingMethodException: Method not found: 'Boolean System.IdentityModel.Selectors.SecurityTokenRequirement.get_IsOptionalToken()'. Server stack trace: at System.ServiceModel.ClientCredentialsSecurityTokenManager.CreateSecurityTokenProvider(SecurityTokenRequirement tokenRequirement, Boolean disableInfoCard) at System.ServiceModel.Channels.TransportSecurityHelpers.GetSspiTokenProvider(SecurityTokenManager tokenManager, EndpointAddress target, Uri via, String transportScheme, AuthenticationSchemes authenticationScheme, ChannelParameterCollection channelParameters) at System.ServiceModel.Channels.HttpChannelFactory.CreateAndOpenTokenProvider(TimeSpan timeout, AuthenticationSchemes authenticationScheme, EndpointAddress target, Uri via, ChannelParameterCollection channelParameters) at System.ServiceModel.Channels.HttpChannelFactory.CreateAndOpenTokenProvidersCore(EndpointAddress to, Uri via, ChannelParameterCollection channelParameters, TimeSpan timeout, SecurityTokenProviderContainer& tokenProvider, SecurityTokenProviderContainer& proxyTokenProvider) at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.CreateAndOpenTokenProviders(TimeSpan timeout) at System.ServiceModel.Channels.HttpsChannelFactory.HttpsRequestChannel.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannel.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannel.CallOnceManager.CallOnce(TimeSpan timeout, CallOnceManager cascade) at System.ServiceModel.Channels.ServiceChannel.EnsureOpened(TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation) at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message) Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at Microsoft.IdentityModel.Protocols.WSTrust.IWSTrustContract.Issue(Message message) at Microsoft.IdentityModel.Protocols.WSTrust.WSTrustClient.Issue(Message message) at Microsoft.IdentityModel.Protocols.WSTrust.WSTrustClient.Issue(RequestSecurityToken rst, RequestSecurityTokenResponse& rstr) at Microsoft.IdentityModel.Protocols.WSTrust.WSTrustClient.Issue(RequestSecurityToken rst) at Microsoft.SharePoint.SPSecurityContext.SecurityTokenForContext(Uri context, Boolean bearerToken, SecurityToken onBehalfOf, SecurityToken actAs) at Microsoft.SharePoint.SPSecurityContext.SecurityTokenForLegacyLoginContext(Uri context) at Microsoft.SharePoint.SPChannelFactoryOperations.InternalCreateChannelActingAsLoggedOnUser[TChannel](ChannelFactory`1 factory, EndpointAddress address, Uri via) at Microsoft.SharePoint.SPChannelFactoryOperations.CreateChannelActingAsLoggedOnUser[TChannel](ChannelFactory`1 factory, EndpointAddress address) at Microsoft.Office.Excel.Server.MossHost.MossHost.CreateServiceChannel[T](Uri serverUrl, Boolean delegateUser).
10/04/2010 11:06:28.28 w3wp.exe (0x122C) 0x1150 Excel Services Excel Services Web Front End abpo Unexpected An unexpected exception during ServerSession.CreateExcelService has occurred for server url: http://LBYCOMM:32843/2ccc0cb260854290827aa9e89b097aee/ExcelService.asmx, exception: System.MissingMethodException: Method not found: 'Boolean System.IdentityModel.Selectors.SecurityTokenRequirement.get_IsOptionalToken()'. Server stack trace: at System.ServiceModel.ClientCredentialsSecurityTokenManager.CreateSecurityTokenProvider(SecurityTokenRequirement tokenRequirement, Boolean disableInfoCard) at System.ServiceModel.Channels.TransportSecurityHelpers.GetSspiTokenProvider(SecurityTokenManager tokenManager, EndpointAddress target, Uri via, String transportScheme, AuthenticationSchemes authenticationScheme, ChannelParameterCollection channelParameters) at System.ServiceModel.Channels.HttpChannelFactory.CreateAndOpenTokenProvider(TimeSpan timeout, AuthenticationSchemes authenticationScheme, EndpointAddress target, Uri via, ChannelParameterCollection channelParameters) at System.ServiceModel.Channels.HttpChannelFactory.CreateAndOpenTokenProvidersCore(EndpointAddress to, Uri via, ChannelParameterCollection channelParameters, TimeSpan timeout, SecurityTokenProviderContainer& tokenProvider, SecurityTokenProviderContainer& proxyTokenProvider) at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.CreateAndOpenTokenProviders(TimeSpan timeout) at System.ServiceModel.Channels.HttpsChannelFactory.HttpsRequestChannel.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannel.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannel.CallOnceManager.CallOnce(TimeSpan timeout, CallOnceManager cascade) at System.ServiceModel.Channels.ServiceChannel.EnsureOpened(TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation) at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message) Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at Microsoft.IdentityModel.Protocols.WSTrust.IWSTrustContract.Issue(Message message) at Microsoft.IdentityModel.Protocols.WSTrust.WSTrustClient.Issue(Message message) at Microsoft.IdentityModel.Protocols.WSTrust.WSTrustClient.Issue(RequestSecurityToken rst, RequestSecurityTokenResponse& rstr) at Microsoft.IdentityModel.Protocols.WSTrust.WSTrustClient.Issue(RequestSecurityToken rst) at Microsoft.SharePoint.SPSecurityContext.SecurityTokenForContext(Uri context, Boolean bearerToken, SecurityToken onBehalfOf, SecurityToken actAs) at Microsoft.SharePoint.SPSecurityContext.SecurityTokenForLegacyLoginContext(Uri context) at Microsoft.SharePoint.SPChannelFactoryOperations.InternalCreateChannelActingAsLoggedOnUser[TChannel](ChannelFactory`1 factory, EndpointAddress address, Uri via) at Microsoft.SharePoint.SPChannelFactoryOperations.CreateChannelActingAsLoggedOnUser[TChannel](ChannelFactory`1 factory, EndpointAddress address) at Microsoft.Office.Excel.Server.MossHost.MossHost.CreateServiceChannel[T](Uri serverUrl, Boolean delegateUser) at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ServerInfo.CreateExcelService(Boolean delegateUser).
10/04/2010 11:06:28.28 w3wp.exe (0x122C) 0x1150 Excel Services Excel Services Web Front End 145b Unexpected ServerSession.GetHealthScoreCallback: Failed to get health score for server http://LBYCOMM:32843/2ccc0cb260854290827aa9e89b097aee/ExcelService*.asmx [id: 66c0768b-ed20-4b73-9b36-a248e8ffe529] due to the following unexpected exception Microsoft.Office.Excel.Server.CalculationServer.Proxy.ServerSessionException: An error has occurred. ---> System.MissingMethodException: Method not found: 'Boolean System.IdentityModel.Selectors.SecurityTokenRequirement.get_IsOptionalToken()'. Server stack trace: at System.ServiceModel.ClientCredentialsSecurityTokenManager.CreateSecurityTokenProvider(SecurityTokenRequirement tokenRequirement, Boolean disableInfoCard) at System.ServiceModel.Channels.TransportSecurityHelpers.GetSspiTokenProvider(SecurityTokenManager tokenManager, EndpointAddress target, Uri via, String transportScheme, AuthenticationSchemes authenticationScheme, ChannelParameterCollection channelParameters) at System.ServiceModel.Channels.HttpChannelFactory.CreateAndOpenTokenProvider(TimeSpan timeout, AuthenticationSchemes authenticationScheme, EndpointAddress target, Uri via, ChannelParameterCollection channelParameters) at System.ServiceModel.Channels.HttpChannelFactory.CreateAndOpenTokenProvidersCore(EndpointAddress to, Uri via, ChannelParameterCollection channelParameters, TimeSpan timeout, SecurityTokenProviderContainer& tokenProvider, SecurityTokenProviderContainer& proxyTokenProvider) at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.CreateAndOpenTokenProviders(TimeSpan timeout) at System.ServiceModel.Channels.HttpsChannelFactory.HttpsRequestChannel.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannel.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannel.CallOnceManager.CallOnce(TimeSpan timeout, CallOnceManager cascade) at System.ServiceModel.Channels.ServiceChannel.EnsureOpened(TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation) at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message) Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at Microsoft.IdentityModel.Protocols.WSTrust.IWSTrustContract.Issue(Message message) at Microsoft.IdentityModel.Protocols.WSTrust.WSTrustClient.Issue(Message message) at Microsoft.IdentityModel.Protocols.WSTrust.WSTrustClient.Issue(RequestSecurityToken rst, RequestSecurityTokenResponse& rstr) at Microsoft.IdentityModel.Protocols.WSTrust.WSTrustClient.Issue(RequestSecurityToken rst) at Microsoft.SharePoint.SPSecurityContext.SecurityTokenForContext(Uri context, Boolean bearerToken, SecurityToken onBehalfOf, SecurityToken actAs) at Microsoft.SharePoint.SPSecurityContext.SecurityTokenForLegacyLoginContext(Uri context) at Microsoft.SharePoint.SPChannelFactoryOperations.InternalCreateChannelActingAsLoggedOnUser[TChannel](ChannelFactory`1 factory, EndpointAddress address, Uri via) at Microsoft.SharePoint.SPChannelFactoryOperations.CreateChannelActingAsLoggedOnUser[TChannel](ChannelFactory`1 factory, EndpointAddress address) at Microsoft.Office.Excel.Server.MossHost.MossHost.CreateServiceChannel[T](Uri serverUrl, Boolean delegateUser) at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ServerInfo.CreateExcelService(Boolean delegateUser) --- End of inner exception stack trace --- at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ServerInfo.CreateExcelService(Boolean delegateUser) at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ServerSession.GetServerHealthScore() at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ServerSession.<>c__DisplayClass155.<ExecuteWithSecurityContext>b__154() at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ServerSession.ExecuteWithSecurityContext(Boolean forceRevert, CoreWebMethod coreWebMethod, CommandParameter parameter) at Microsoft.Office.Excel.Server.CalculationServer.Proxy.ServerSession.GetHealthScoreCallback(Object state)
ASKER
Thank you for that information but Client Integration was already enabled.
Are you trying to
1. Just open the XLSX file in Office client-side, like any other Office document?
2. View the contents of the XLSX file in the browser for viewing purposes only (Excel Web Services)
3. Trying to edit the XLSX file in Office Web Apps (Office server-side)
1. Just open the XLSX file in Office client-side, like any other Office document?
2. View the contents of the XLSX file in the browser for viewing purposes only (Excel Web Services)
3. Trying to edit the XLSX file in Office Web Apps (Office server-side)
ASKER
@FastFngrz
At this point I'd be happy to just be able to click the file and have it open. In which case it would be scenario 2 from your list above. Again, click it open without having to select "Edit in Excel" from the drop-down list.
At this point I'd be happy to just be able to click the file and have it open. In which case it would be scenario 2 from your list above. Again, click it open without having to select "Edit in Excel" from the drop-down list.
I assume the file is stored in a document library. If you navigate to that document library, see the file in a view and click the filename, does it open?
Excel Web Services are usually exposed via a webpart - I assume that's not what you really want.. if you are going for Scenario #1
Excel Web Services are usually exposed via a webpart - I assume that's not what you really want.. if you are going for Scenario #1
ASKER
The file is in a document library and it does not open when I click the file name in a view. It tries to open in Excel Web services but I then receive a popup error as stated in the title of this question.
Can you confirm that that doclib is in the list of trusted locations fo Excel Web Services back under central admin-ssp? If it is, note the path, and remove it.
ASKER
At the moment we only have a single Trusted File Location of Http://
As another troubleshooting step I deleted the Excel Services Web Service Application and recreated it.
However, the status is now as follows:
Excel Services Web Service Application - Started
Excel Services Web Service Application Proxy - Stopped
I'm not sure why the proxy is stopped or if that even makes a difference.
As another troubleshooting step I deleted the Excel Services Web Service Application and recreated it.
However, the status is now as follows:
Excel Services Web Service Application - Started
Excel Services Web Service Application Proxy - Stopped
I'm not sure why the proxy is stopped or if that even makes a difference.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
To do this, follow these steps:
1. Start SharePoint 2010 Central Administration, and then click Security.
2. Click Specify authentication providers.
3. If the Web application in the Web Application list is not the same application that you want to open in SharePoint Designer 2010, click Web Application on the Change Web Application list.
4. On the Select Web Application page, click the name of the Web application that you want to open.
5. Under Zone, Click Default to open the Edit Authentication page.
6. Under Enable Client Integration, click Yes, and then click Save.