SharePoint Web Services Round Robin Service Load Balancer Event: EndpointFailure

Its been a while since I have posted updates. Things have been hectic, with a move to a new company, country and house all at the same time. Well, I hope to make more regular updates from here on as I am getting settled and finding more time.

Here is the first of the posts which I hope will assist you in some way or another:

Have you run into this error message in your SharePoint 2010 event logs.

SharePoint Web Services Round Robin Service Load Balancer Event: EndpointFailure
Process Name: w3wp
Process ID: 4692
AppDomain Name: /LM/W3SVC/1298049692/ROOT-1-129995799432439788
AppDomain ID: 2
Service Application Uri: urn:schemas-microsoft-com:sharepoint:service:0cbdaef473aa41ccbefff880e6f844ba#authority=urn:uuid:66678e5d6d324193b456e233c76a4d31&authority=
https://myserver:32844/Topology/topology.svc
Active Endpoints: 1
Failed Endpoints:1
Affected Endpoint: http://myserver:32843/0cbdaef473aa41ccbefff880e6f844ba/SearchService.svc

I’d done alot of research, and found many blogs that suggested restarting the service, and while this was a great short term fix, it was not a permanent solution.

I needed to find the root cause of the problem. I did some digging and found that the problem was due to Search Query and Site Settings configured incorrectly.
In essence, the error message means that you have a server in your farm which has a Search Query and Site Setting role enabled. When your search service runs/executes any queries, this service will attempt to execute queries on its host server. Now, if you have not configured your Search Service on thie host server, you will recieve this error in your logs.

This is how I fixed this issue:

1. Go to System Settings->Manage services on server: Check the status of the Search Query and Site Settings Service:

2. Or you can check this with PoSh. Run the following on each of your web front ends:

3.Stop the service on the server which is not configured for the Search query role:

4. Or you could use PoSh:

Now you should not have that error again.

Cheers for now.

Getting to know SharePoint 2013

So, the much awaited release of SharePoint 2013 has come and gone, and many of us have been itching to get our fingers dirty and mess about with it.

In this post, I’ll go through some things which I’ve noticed while I’ve bee scratching my itch

This post will not cover installing SharePoint 2013, as a few guys have already done so, and if you really need a guide, you can check out Bradley Geldenhuys’ great blog post on the subject: http://www.bradg.co.za/?p=339

Alrighty, so back to the SP2013 Preview. A few things which I’d like to mention. 1.) Hardware & Software requirements on Technet state you need 24Gb of memory to run SharePoint 13 as a standalone farm. Well, it seems this is not entirely true. I have my virtualized instance running on 6Gb RAM, Windows Server 2008 R2, SQL Server 2008 R2 and Visual Studio 2011 preview. The box pers like a kitten.

2.)The initial installation steps are pretty much the same as the SharePoint 2010. There are however a few new items in the prerequisites which need to be installed/downloaded.

Once you have gone through the install, you are able to view your SharePoint 2013 Central Admin site. The site looks very simirlar to the one of SP2010, with few noticable differences: 1.) The styling has been updated to the new Metro style which seems be the new “black”.

SharePoint 2013 – Central Admin

2.)There is an updated menu to the top right of the CA(Central Admin) home page.

3.) There appears to be a new configuration area named Apps.

I will be going into these options as I work through the configuration of my SharePoint 2013 Farm.

Application Management On creating a new Web Application, the Create New Web Application Screen appears to be similar.

Another area here that appears to be new – Configure service application Associations.

Applications

There are a few new site templates too:

Site Templates

One of the cool new features or SP2013 is that when creating a site collection you can opt to set the user experience to SP2010 or SP2013.

Templates which I haven’t seen before or are new:
Group Work Site
Developer Site
Multipage Meeting Workspace
Discovery Center
Community Portal
Product Catalog
Visio Process Repository

There also appear to be a few new Service Applications that one can choose from:

Service Applications

There is now also a page specifically for controlling the associations between web apps and service apps.

Service Application Associations

In the next post, I will look into the System Settings.

Happy SharePointing…

SharePoint 2010 Administration Toolkit

While looking for an ‘As Is’ environment assesment template, I came across the SharePoint 2010 Administration Toolkit.

I really think this tool can be a great asset to any consultant or SharePoint team looking at measuring performance or expanding the diagnostics of their SharePoint farms.

The SharePoint Administration Toolkit version 2.0, includes the following features:

• The Load Testing Kit, which generates a Visual Studio Team System 2008 (VSTS) load test based on Microsoft Office SharePoint Server 2007 IIS logs
• The Security Configuration Wizard (SCW) manifest, which add roles for SharePoint 2010 Products to Windows Server 2008 with Service Pack 2 or to Windows Server 2008 R2.
• The User Profile Replication Engine, which provides a shared services administrator the ability to replicate user profiles and social data between shared services providers (SSP) in Office SharePoint Server 2007 and User Profile service applications in SharePoint Server 2010.
• The Content Management Interoperability Services (CMIS) connector for Microsoft SharePoint Server 2010, which enables SharePoint users to interact with content stored in any repository that has implemented the CMIS standard, as well as making SharePoint 2010 content available to any application that has implemented the CMIS standard.
• New in SharePoint Administration Toolkit 2.0, the SharePoint Diagnostic Studio 2010 (SPDiag 3.0) provides SharePoint administrators with a unified interface that can be used to gather relevant information from a farm, display the results in a meaningful way, identify performance issues, and share or export the collected data and reports for analysis by Microsoft support personnel.

As a consultant myself, I know that I could have definitely made use of these toolkits in past projects.
So I hope that you find them as useful as I feel they are.

All info was taken from the SharePoint 2010 Administration Toolkit page:
http://technet.microsoft.com/en-us/library/cc508851

C#, Taxonomies and Metadata

Ah, its been a while since I’ve blogged! Its been busy to say the least. Well, I hope you find this blog post useful!

Recently I took over development from a colleague on a content migration project.

The tool is a windows application – it uploads documents in a specified location, and applies taxonomy/metadata as specified in a configuration file which an administrator has control over.

Configuration File

So while testing this, I found that although we could upload a document just fine, only the first term of the term set would be applied as metadata.
If the taxonomy data went more than one level deep, the field would be blank. This happend for all the fields that we tried to set that specific term to:

Empty Field Values

If the term was not in the 1st level, then the code would not find it.
To fix this, I needed to create a Term Collection, and use the TermStore.GetTerms(string, boolean) method to check for the term in the collection.

Visio 2010 Business Intelligence Solutions

Recently I favourited a link posted on Twitter by Chris Hopkins, about Visio as a Business Intelligence Solution.
Whilst checking out the link, I found that it was 5 completely free labs, which include:
Publishing Data Connected Diagrams
Building a simple dashboard using Web Part Connections
Building mash ups using with Visio Services
Building Data Graphics
Using Visio with SharePoint Workflow

These labs will give a good base to start with on your BI solutions.
Feel free to check them out here – http://blogs.msdn.com/b/chhopkin/archive/2012/05/22/visio-services-hands-on-labs-now-available.aspx

Also, check out the writers other blog posts – http://blogs.msdn.com/b/chhopkin/

Migrating Your SharePoint 2010 SQL Instance To A New Server

There are a good few posts on the interweb providing information around this subject, many are specific to MOSS 2007. Some cover SharePoint 2010.

Anyway, I wanted to share my approach, which I documented and figured you could use this as a template. The area in the document which really stands out for me is the section on the permissions – I handed my document to our DBA, who did the move of the databases and permissions for us using the document/template.

All the required permissions were copied/moved over and we had no issues whatsoever when we brought the services back up again.

You can download the document from here:
SharePoint2010SQLInstanceMigration

The file also contains links to refrence sites that I used when I built the file.

Move your Managed Metadata to a new farm

A few weeks ago, I recreated a clients environment so that they have a dev/qa environment.

The client really wanted to have their Service Applications moved into the dev environment too.

But how? Well, there are numerous ways to do this, but I’m going to let you in on the easy way
Courtesy of Andrew Connell, who gave me the idea from this thread – http://www.andrewconnell.com/blog/archive/2011/06/15/sharepoint-2010-managed-metadata-movingcopying-mms-instances-term.aspx

I was able to recreate the service applications by backing up the production environment service application dbs, and copying them to the dev environment and restoring them to the dev database. I then rectreated the service application in Central Administration, and in the database field, specify the name of the database which you restored from your production environment. Your farm will configure the new service application using the settings configured in the database which you restored.

In terms of Managed Metadata, this means that you dont have to export your term stores and then re-import them into the dev environment.

Hope you found this post helpful – it certainly saved me some time!