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

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

Rate This
  • Comments 16

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

  • 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

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

  • 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

  • YOU ARE THE MAN....this worked for me

  • Hi!

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

    PS C:\Users\admin> $sts.Provision()

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

    At line:1 char:15

    + $sts.Provision <<<< ()

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

       + FullyQualifiedErrorId : DotNetMethodException

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

  • 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

  • Great!

    I have used your solution in PowerShell and works.

    But Why happened this?

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

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

  • 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!

  • 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

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

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

Page 1 of 2 (16 items) 12
Leave a Comment
  • Please add 4 and 3 and type the answer here:
  • Post