Link to home
Start Free TrialLog in
Avatar of felonyone
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!!!

 
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)

Open in new window

Avatar of pramodsk40
pramodsk40
Flag of United States of America image

Try enabling client integration and see if it fixes

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.
Avatar of felonyone
felonyone

ASKER

Thank you for that information but Client Integration was already enabled.
Avatar of Daryl Sirota
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)

@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.
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
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.
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.
ASKER CERTIFIED SOLUTION
Avatar of mvozila
mvozila

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial