SharePoint 2010 service applications – BCS, MetaData, Access Service are not working ?
Recently I had faced an issue with BCS, MetaData and Access Services in my SharePoint environment. Those are the only services that I have checked and not sure about other services, but a single point resolution resolved all those issues.
Issue with BCS was once I open SharePoint site in SharePoint designer and Click on “External Content Types” in the left side menu then I got the below error.
Click on “External Content Type” on top menu I got another one :)
I have checked and confirmed the below configuration settings (these settings must need to be checked, because I have seen this issue before as well because of the mismatch versions)
Both SPD and SPS are running with same version (RTM)
Installed the WCF hotfix for Windows 2008 R2 ( same for windows 7 ), which was not there before.
Services are running and selected for the corresponding web application.
Issue with Access Services:
Once I tried to browse to the Access WebForm it wasthrowing the below error in the UI.
Exception in ULS log is given below:
High (w3wp.exe)
Error while executing web part: Microsoft.Office.Access.Server.Application.AccessServerSessionException: Access Services is unable to process the request. at Microsoft.Office.Excel.Server.CalculationServer.Proxy.LoadBalancer.GetFailoverServer(String excludeServerId) at Microsoft.Office.Excel.Server.CalculationServer.Proxy.LoadBalancer.GetNextServer(String workbookUrl) at Microsoft.Office.Excel.Server.CalculationServer.Proxy.LoadBalancer.ExecuteNewSessionMethod(CreateServerSessionMethod createServerSessionMethod, CoreNewSessionMethod newSessionMethod, String workbookUrl) at Microsoft.Office.Access.Server.Application.AccessServerSession.CreateNewSession() at Microsoft.Office.Access.Server.Data.AccessServicesDataSourceView.get_ServerSession() at Microsoft.Office.AccessServer.Data.AccessServicesDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) at System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) at Microsoft.SharePoint.WebControls.SingleDataSource.GetXPathNavigatorInternal() at Microsoft.SharePoint.WebControls.SingleDataSource.GetXPathNavigator() at Microsoft.SharePoint.WebPartPages.DataFormWebPart.GetXPathNavigator(String viewPath) at Microsoft.SharePoint.WebPartPages.DataFormWebPart.PrepareAndPerformTransform(Boolean bDeferExecuteTransform) 88303781-07a4-43e7-966d-b648207b9b0f
I can see that all content published correctly to SharePoint site. If I edit any of the items in the EmpInfo list it is synching that data with my client Access application (access table - EmpInfo). But while accessing the webform only I am getting the above error.
Access service was enabled for the webapplication that I am testing.
Another issue was related to the Managed MetData , once I click on the Managed metadata service, it was throwing an other error which I don’t remember now.
As a summary the resolution was in a single point: From the all above findings we can see that most of the service applications are failing.
Once I checked the event logs I could see the below errors whenever there is a SharePoint service application failure.
An exception occurred when trying to issue security token: The HTTP service located at https://localhost:32843/SecurityTokenServiceApplication/securitytoken.svc/actas is too busy. .
An unexpected error occurred. Error 52068.
Exception details:
System.ServiceModel.ServerTooBusyException: The HTTP service located at https://localhost:32843/SecurityTokenServiceApplication/securitytoken.svc/actas is too busy. ---> System.Net.WebException: The remote server returned an error: (503) Server Unavailable.
at System.Net.HttpWebRequest.GetResponse()
at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)
--- End of inner exception stack trace ---
Resolution was re-provision the Security Token Service application. Below PS script will do it !
PS C:\Users\sowmyans> Get-SPServiceApplication
DisplayName TypeName Id
----------- -------- --
Access Services Access Services W... 77562ca9-5c80-45f4-9a21-6d86c013eb75
Secure Store Service Secure Store Serv... 5eceb8dd-ef3d-4c7d-b900-59436e4743a1
State Service State Service 54dfbd6d-dc83-48e9-9b79-a52853aad23d
PerformancePoint ... PerformancePoint ... 7556e63a-4c50-400c-8788-de6724b64ab7
Visio Graphics Se... Visio Graphics Se... ac3ab2e0-3952-473d-9901-001b050ef945
Managed Metadata ... Managed Metadata ... 32eeb3d8-b710-4635-81d5-771701072593
Web Analytics Ser... Web Analytics Ser... 9cb8fdbb-c87c-4c11-9c91-d89e04aec703
Excel Services Ap... Excel Services Ap... 8918fc32-b6f2-49ad-9d60-f0d7a866d85d
Security Token Se... Security Token Se... 033b6266-261d-4318-9a9a-36f0e390d346
Application Disco... Application Disco... 80a9e9de-88d0-4ce1-8108-380117fc1c11
Usage and Health ... Usage and Health ... 746c7339-1e8c-47ae-8583-ea80faae5fac
Search Administra... Search Administra... 944cfcd9-155e-41c0-82b7-95386d737fcb
Word Automation S... Word Automation S... c2a414b6-dfb7-4974-8eb4-6c2c6da65af0
Application Regis... Application Regis... e1131c58-0242-4aab-9156-1de22c2be8a4
User Profile Serv... User Profile Serv... 24f623c3-d368-4901-aee0-aed2f8e3f129
Business Data Con... Business Data Con... 2d21dffe-a188-42d7-b46e-04850805bcde
Lotus Notes Conne... Lotus Notes Conne... 115431c5-80e7-40d4-bdd8-7a7254951714
Search Service Ap... Search Service Ap... 1f69450e-c835-4219-9b46-7f444c204059
PS C:\Users\sowmyans> $sts = Get-SPServiceApplication | ?{$_ -match "Security"}
PS C:\Users\sowmyans> $sts
DisplayName TypeName Id
----------- -------- --
Security Token Se... Security Token Se... 033b6266-261d-4318-9a9a-36f0e390d346
PS C:\Users\sowmyans> $sts.Status
Online
PS C:\Users\sowmyans> $sts.Provision()