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

  1. ssummone says:

    Thanks Sowmyan I was scratching my head with this one. But your solution was spot on 😉 Cheers. I just wonder why after setting this up 3 times the third time it decides to screw up….

  2. Jacob Alifrangis says:

    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

  3. Kamis Consulting says:

    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.

  4. JonathanR says:

    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

  5. SharePoint = banghead says:

    YOU ARE THE MAN….this worked for me

  6. Kora says:

    Hi!

    I got this error after running the last script of $sts.Provision() .. any ideas as to why?

    PS C:Usersadmin> $sts.Provision()

    Exception calling "Provision" with "0" argument(s): "

    At line:1 char:15

    + $sts.Provision <<<< ()

       + CategoryInfo          : NotSpecified: (:) [], M

       + FullyQualifiedErrorId : DotNetMethodException

  7. wc says:

    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.

  8. Brian says:

    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

  9. Ramon Torras says:

    Great!

    I have used your solution in PowerShell and works.

    But Why happened this?

  10. Richard says:

    Thanks Fixed loads of issue with in Sharepoint !!!!

  11. Hossein Aarabi says:

    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)

  12. svanschalkwyk says:

    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!

  13. 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

  14. UncleT says:

    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.

  15. sowmyancs says:

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

  16. HaroldGray says:

    Thanks a million – the provision worked for me!

  17. Rockie says:

    In my case I started this AppPool in inetmgr.exe. Thank You very much that You pointed in right direction!

  18. Carrie says:

    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.