Share via

SharePoint 2010 service applications – BCS, MetaData, Access Service are not working ?

  • Article

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 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()

Comments

  • Anonymous
    October 01, 2010
    The comment has been removed

  • Anonymous
    October 13, 2010
    Nope, Still get: User Profile Application Proxy failed to retrieve partitions from User Profile Application: Microsoft.Office.Server.UserProfiles.UserProfileApplicationNotAvailableException: No User Profile Application available to service the request. Contact your farm administrator.     Funny thing is that search works on one server, but not the other

  • Anonymous
    January 12, 2011
    After searching on this error on a client site this was the only fix that worked. Other posts were pointing to theoobvious patches and fixes time and time again, restarting Sharepoint Web Services Root. Excellent post and fix.

  • Anonymous
    January 12, 2011
    Thanks Sowmyan, I had the same problem after upgrading a SPF farm to Search Server Express 2010. The Search Results page would induce such an error in the event log. Reprovisionning the service worked like a charm ! Jonathan

  • Anonymous
    February 10, 2011
    YOU ARE THE MAN....this worked for me

  • Anonymous
    March 16, 2011
    The comment has been removed

  • Anonymous
    June 07, 2011
    This procedure left my SharePoint Environment inoperable. After several attempts to reinstall with no sucess, it appears that a total server install is in order. Any information about how to undo the powershell commands above.

  • Anonymous
    November 04, 2011
    I did this, and it didn't immediately work.  I have an all-in-one SQL/SP2010 system (DEV) and even after a reboot it did not come back up.  What I did do though is notice in the event viewer that there was an error saying my service account didn't have permissions to the DB, I think the DB wasn't fully started so I did this: From PowerShell get-spserviceinstance |stop-spserviceinstance then get..|start-spserviceinstance

  • Anonymous
    January 17, 2012
    Great! I have used your solution in PowerShell and works. But Why happened this?

  • Anonymous
    September 20, 2012
    Thanks Fixed loads of issue with in Sharepoint !!!!

  • Anonymous
    November 27, 2012
    The reason you get the exception 'calling "Provision" with "0" argument(s): "' is because you will need to run the PowerShell as an administrator (run as administrator)

  • Anonymous
    January 24, 2013
    Thanks. I've set up a great number of farms and have just run into this for the first time. Your solution is spot-on!

  • Anonymous
    April 11, 2013
    Hi All, The server was unable to process the request due to an internal error. For more information about the error, either turn on IncludeExceptionDetailInFaults (either from ServiceBehaviorAttribute or from the <serviceDebug> configuration behavior) on the server in order to send the exception information back to the client, or turn on tracing as per the Microsoft .NET Framework 3.0 SDK documentation and inspect the server trace logs. I am getting the above statement in the browser with the Service Header. Can you please help me in this. Regards, Ram

  • Anonymous
    March 05, 2014
    An idea how long this command should take? After running the $sts.Provision() command I thas been 2 hours and nothing has returned from that command yet.

  • Anonymous
    March 05, 2014
    It won't be taking much time to provision it. Could you please check the ULS logs and see anything unusual happening ?

  • Anonymous
    June 16, 2014
    Thanks a million - the provision worked for me!

  • Anonymous
    February 17, 2015
    In my case I started this AppPool in inetmgr.exe. Thank You very much that You pointed in right direction!

  • Anonymous
    October 15, 2015
    Having had a very similar problem, along with many other associated problems, which put my work at an altogether unacceptable, extended standstill, I decided to post the resolution I found to as many forums relating to this issue that I could. The resolution that I found was one of two things that I did at the same time. (duh – not a smart tactic, but I was getting desperate…) I am not willing to spend the time to isolate the effects of each of these motions, so it could be one, or the other, or both.

  1. I noticed that SharePoint was moving the Farm Account Security Managed Account (The user account that Farm Account uses for credentials) from the Administrators group, to the WSS_ADMIN_WPG group. In my case Central Admin was being run on the same machine as the SharePoint Server. I run a single server developer environment. So the Farm Account needed “Log on Locally” privileges. WSS_ADMIN_WPG group did not appear to have the needed privilege, where the Administrators group did. Strangely enough though, the Administrators group is a member of the WSS_ADMIN_WPG group. So I moved the above mentioned user account back into the Administrators group. Let me know if I’m not seeing something here….
  2. Upon examining the SecurityTokenServiceApplicationPool (the name I gave for the Security Token Service’s Application Pool), I notice that the Enable 32-bit Applications setting under the Advanced Settings had been set to True. This to me was strange as I remembered installing the 64 bit versions of everything, because the Server machine on which I was working was indeed 64 bit. So I set it to False. After those two simple motions I did all the familiar and necessary things to be done to make sure that the system and SharePoint was running with all the latest settings and tried what I had been doing once again, and to my amazement and shock (after having tried everything on the internet several times each) it worked! I am now happily moving forward in my work! At least until the next roadblock comes along. Weird, dumb and stupid, what were the chances? Maybe it will be worth a quick look for you.