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.

clip_image001

Click on “External Content Type” on top menu I got another one :)

clip_image002

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)

clip_image003

Installed the WCF hotfix for Windows 2008 R2 ( same for windows 7 ), which was not there before.

clip_image004

Services are running and selected for the corresponding web application.

clip_image005

 

Issue with Access Services:

 

Once I tried to browse to the Access WebForm it wasthrowing the below error in the UI.

clip_image001[5]

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.

clip_image003[7]

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 http://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 http://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 applicationBelow 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()