Paul Grimley's Blog

User Profile Information not correct in Site Collection My Settings (userdisp.aspx page)

2011-08-01T23:21:00.001+01:00

I came across a strange one the other day. A client called me to say when a user adds an alert it shows an email address that the user had a while ago and does not reflect an update in Exchange / AD. So the easy target was the user profile service however it proved not to be this (for once!).

So doing some digging I found some really strange behaviour. I tested the user in questions alerts and sure enough it was showing the old email address even though all the information for that user was definitely correct.

After further testing I experienced different profile information in different site collections (some correct and up to date and the others not).

So to picture the page I am referring to, here’s a screenshot below (_layouts/userdisp.aspx)

This is the page you would normally see in WSS or SharePoint Foundation and you can still access this page from SharePoint Standard or Enterprise selecting My Settings from the drop down.

Back to the issue.in hand so noticing different behaviour between site collections, I came across a Microsoft KB article KB2012619 which suggested that if a user is only a reader of the site collection they wont be able to update the information. I thought this was strange however I tested this and strangely it worked. Long story short I then tested again and it didn't so results were mixed. I then discovered the actual timer job which updates each site collection with the user profile information from the service application which is called ‘User Profile Service Application - User Profile to SharePoint Full Synchronization’:

This Timer Job was running fine however the specific site collections were not updating.

From articles relating to MOSS 2007 there was suggestions that if the database was not correctly attached to the farm the SSP would report issues. As the farm I was working on was upgraded I had suspicions that maybe not all was well with content database so decided to create a new content database and migrate all the site collections into this database using PowerShell to do so (See http://technet.microsoft.com/en-us/library/cc825328.aspx#Section3).

After moving the site collections to the new content database then re-running the ‘User Profile Service Application - User Profile to SharePoint Full Synchronization’ Timer Job this successfully updated all site collections with the correct information. I tested this further by adding additional profile information in AD then running a full profile synch and finally the Timer Job to update the SharePoint Sites and the new information successfully propagated to each site collection.

So to conclude the user who’s alert page was showing an old email address was now corrected so his was able to receive alerts.

The dangers of going live without thorough investment in testing

2011-06-27T14:29:00.001+01:00

This post is a little more generic than my normal product focus on SharePoint technologies, reason being it applies to all IT solutions projects delivering a solution.

As you may have read in the news over the last couple of weeks a couple of high profile problems hit the headlines. These were the failure of Tesco’s banking platform migration (http://www.bbc.co.uk/news/business-13888891) and The Olympics ticketing system for London 2012 (http://www.guardian.co.uk/sport/2011/jun/24/olympic-tickets-sale-second-round).

Both scenarios indicate that sufficient testing of their respective systems was clearly not carried out to avoid these unfortunate outcomes. With the advancement in virtualisation technologies there should be no reason why replicated scenarios can’t be simulated to forecast and avoid this happening.

One of the main reasons why testing is reduced is due to the financial overhead of such intense testing. This includes provisioning hardware, additional software licenses, resources to commission the system, testing the systems and the list goes on and effectively this is a project in itself.

What the system glitches didn't highlight and especially in the case the Olympics' ticket application system was that they simply didn't cater for the volume of applicants. This begs the question, why didn't they? Surely they were expecting this many applicants to apply?

This brings me on to the next point which is systems should be tested for every eventuality ‘What if’ and the outcome / behaviour of such a scenario.

Personally for the Olympic application (of which first time round I was unsuccessful) I was frustrated by how the results were displayed when searching for an event to attend. The results displayed all events even if they had been sold! All this did was make it harder for me to find events with availability and in the end I gave up. What I believe should have happened was as an event was sold out it was removed from the results to allow for easy navigation of availability. This was a case of the ‘what if’ scenario and how easy it should be for potential applicants to apply for tickets especially as second time round it was first come first serve so people would have been panicking trying to find availability as it rapidly disappeared.

So when discussing the financial cost of testing migrations / go-live scenario’s were the relevant risks pointed out of not thoroughly testing? Was the risk absorbed and understood?

IT may have been the one’s who were having the finger pointed at them however if they have highlighted the risks and issues of not thoroughly testing then is it IT’s fault? I certainly don’t think so and it easy to blame IT for this.

User Profile Synchronization Service failed to start due to Kerberos issue

2011-06-24T10:29:00.001+01:00

If you’ve reached this page and its the first one you’ve read about setting up the SharePoint user profile synchronization service I would highly recommend making sure you have read in detail this article http://technet.microsoft.com/en-us/library/ee721049.aspx.

If you have read this and are still having issues read on..

So the issue I was having was that after upgrading a MOSS 2007 server to SharePoint 2010 (in place) the User Profile Synchronization service would attempt to start then after 5 minutes or so return to ‘stopped’. At this point I want to make clear that no part of my farm is setup for Kerberos authentication.

Looking into the server logs I found the following logs that looked suspicious:

Security ID:                DOMAIN\farmaccount
Account Name:                farmaccount
Account Domain:                DOMAIN
Logon ID:                0x58732
Logon Type:                        3
Account For Which Logon Failed:
Security ID:                NULL SID
Account Name:
Account Domain:
Failure Information:
Failure Reason:                An Error occured during Logon.
Status:                        0xc000005e
Sub Status:                0x0
Process Information:
Caller Process ID:        0xed8
Caller Process Name:        C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN\OWSTIMER.EXE
Network Information:
Workstation Name:        SHAREPOINTSERVER
Source Network Address:        -
Source Port:                -
Detailed Authentication Information:
Logon Process:                C
Authentication Package:        Kerberos
Transited Services:        -
Package Name (NTLM only):        -
Key Length:                0
I also found an entry in the SharePoint Logs:

06/23/2011 10:43:23.73 OWSTIMER.EXE (0x1E2C) 0x1FE8 SharePoint Portal Server User Profiles 9q15 High UserProfileApplication.SynchronizeMIIS: Failed to configure ILM, will attempt during next rerun. Exception: System.Security.SecurityException: There are currently no logon servers available to service the logon request. at System.Security.Principal.WindowsIdentity.KerbS4ULogon(String upn) at System.Security.Principal.WindowsIdentity..ctor(String sUserPrincipalName, String type) at System.Security.Principal.WindowsIdentity..ctor(String sUserPrincipalName) at Microsoft.IdentityManagement.SetupUtils.IlmWSSetup.GetDomainAccountSIDHexString(String domainName, String accountName) at Microsoft.IdentityManagement.SetupUtils.IlmWSSetup.GrantSQLRightsToServiceAccount() at Microsoft.IdentityManagement.SetupUtils.IlmWSSetup.IlmBuildDatabase() at Microsoft.Office.Server.Us...

From researching this I managed to find this blog which suggested the issue is related to Kerberos.

Now this seems strange as my farm is not running Kerberos and nor are the Web Applications so I could have quite easily discarded the blog however stranger things have happened so I followed the blog mentioned and added a Kerberos SPN for the farm account to AD.

Sure enough this fixed the issue and the User Profile Synchronisation Service started and has since worked perfectly.

One thing that to note is that if you remove the SPN after starting the service and it for some reason returns to the stopped state you will need to re-enter the SPN to start the service.

Credit to my colleague James Brennan for assisting in resolving this issue.

SharePoint databases report ‘Database is in compatibility range and upgrade is recommended’ after upgrade

2011-06-23T17:07:00.001+01:00

Following on from previous blog and day 2 of upgrade found some of the databases were reporting the following error:

Database is in compatibility range and upgrade is recommended

This was appearing on non content databases (as in SharePoint system databases).

This seemed strange as I mentioned in my previous blog that the upgrade had been successful so was a little perplexed to find this issue.

After a little research there didn't seem to be anything that looked to answer my problem.

Although this blog was referring to Windows 7 it was interesting in helping my trail of thought and also made me aware that you can only upgrade content databases and not just standard SharePoint system databases using PowerShell http://blogs.technet.com/b/blairb/archive/2010/07/16/patching-sharepoint-2010-on-windows-7.aspx.

Another article relating to this was found here where no solution had actually been found (at the time of blogging) http://social.technet.microsoft.com/Forums/en-IE/sharepoint2010setup/thread/7d3ee7cf-56f8-46fe-b2c9-b8662e88825a

So concluding that I could only upgrade content databases the above did not help in resolving the issue.

The two databases in question were:

Database – Type

WSS_Search - SPSearchDatabase

WSS_UsageApplication - SPUsageDatabase

I finally managed to resolve the problem by running a b2b upgrade command:

PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures

Credit to this blog (http://blog.techgalaxy.net/archives/2585) for pointing out the b2b command as I was having issues running this prior to finding this.

People Picker Searchcustomquery vs. Searchcustomfilter property

2011-06-22T22:49:00.001+01:00

So I wanted to share an issue I recently had with the people picker which I have to admit was due to user error on my part but you may fall into the same trap!

So the trap I fell into was that I assumed the SharePoint staadm peoplepicker only had one configuration option for querying AD and this is where I went wrong!

So if you follow this TechNet guide for the people picker this is why I believe it isn't as clear as I thought! http://technet.microsoft.com/en-us/library/cc263318(v=office.12).aspx (appreciating this is for MOSS it was suggested this was still applicable to SharePoint 2010).

If you notice from the previous URL it suggests that there is only stsadm -o setproperty -pn peoplepicker-searchadcustomquery available for AD queries so I pursued this route to find very strange results appearing when searching for users. For example lets say I told my parameter only to return users where they have a phone number this command above returned anyone who had a phone number regardless of what you entered in the search term.

So after lots of head scratching I realised after taking a step back that rather than look at the parameters appended to the command I needed to look at the makeup of the command. On closer inspection I realised that there are 2 types of AD commands applicable to the people picker -pn peoplepicker-searchadcustomquery and -pn peoplepicker-searchadcustomfilter (The latter being the actual command I needed) from reading this further TechNet article which actually does the opposite to the previous article and does not mention the query command http://technet.microsoft.com/en-us/library/gg602075.aspx#section8.

Hopefully you can see how easily it was to be confused. So I after the light bulb moment I quickly changed the command and after hours of failure doubting the structure of the LDAP query I realised it was a simple mistake everything worked like a dream.

So to conclude on the commands:

Stsadm -o setproperty -pn peoplepicker-searchadcustomquery – THIS WILL SHOW RESULTS BASED UPON THE QUERY YOU PLACE HERE REGARDLESS OF THE VALUE ENTERED INTO THE PEOPLEPICKER

Stsadm -o setproperty -pn peoplepicker-searchadcustomfilter – THIS WILL SHOW RESULTS BASED UPON FILTERING A VALUE APPLICABLE.

I’m not entirely sure why you would use the customquery option so this is why I didnt wven give it a second thought this existed. If anyone has any scenario’s where this could be used I’d be interested to hear from you.

In place upgrade from MOSS 2007 to SharePoint 2010 fails

2011-06-22T22:04:00.001+01:00

Its been too long! I just realised I haven’t blogged for over 3 months – must try harder!

So today I was working on a client site on an in place upgrade from MOSS 2007 Standard to SharePoint 2010 Standard. Firstly I must say I’m not a fan of any in place upgrade whether this is SharePoint or another experience with Microsoft however due to time constraints and hardware availability this was the best way forward.

Background to the upgrade process

Following the TechNet article on in place upgrade to SharePoint 2010 http://technet.microsoft.com/en-us/library/cc263212(v=office.14).aspx. MOSS 2007 was installed with service pack 2 (Build number 12.0.0.6421) and the pre-upgrade checker run reporting no errors (at this stage it is worth noting that the October 2009 CU updates the pre-upgrade checker however due to timescales this CU update was not installed).

SharePoint 2010 media was slipstreamed with August 2010 CU that would take the new SharePoint build to 14.0.5123.5000.

The Upgrade

The upgrade failed with 3 errors 2 of which were due to features and these were deactivated and solutions retracted for the purposes of removing errors in the short term however 1 error remained from running the command:

psconfig -cmd upgrade -inplace v2v –passphrase <passphrase> -wait

From the logs generated the errors in the log (the log file is typically named Upgrade-Date-Time-error.log) were as follows:

[PSCONFIG] [SPUpgradeSession] [INFO] [6/22/2011 1:45:30 PM]: No context object
[PSCONFIG] [SPUpgradeSession] [ERROR] [6/22/2011 1:45:30 PM]: This upgrade session has been stopped. Possible causes include the process being terminated abruptly or the OS has rebooted. Please restart the upgrade again.

As you can see from the error it wasn't very helpful as this did not apply as I tried to complete the upgrade several times. Further errors were also present when running the command from the prompt:

Failed to upgrade SharePoint Products.

An exception of type Microsoft.SharePoint.Administration.SPUpdatedConcurrencyException was thrown. Additional exception information: An update conflict has occurred, and you must re-try this action. The object SPUpgradeSession Name=xxxxxxxxxxxxxxxxxxx was updated by domain\user, in the PSCONFIG (10056) process, on machine SERVER. View the tracing log for more information about the conflict.

Microsoft.SharePoint.Administration.SPUpdatedConcurrencyException: An update conflict has occurred, and you must re-try this action. The object SPUpgradeSession Name=xxxxxxxxxxxxxxxxxxx was updated by domain\user, in the PSCONFIG (10056) process, on machine SERVER. View the tracing log for more information about the conflict.

From researching other blogs I found a Microsoft article http://support.microsoft.com/kb/939308 suggesting that when upgrading you may need to clear the cache on the WFE servers. This also suggests it is for MOSS 2007 and not SharePoint 2010 and at this stage the server was upgraded with SharePoint 2010 binaries although this blog by Stefan Goßner that suggested it may be applicable to SharePoint 2010 http://blogs.technet.com/b/stefan_gossner/archive/2011/03/04/delayed-february-2011-cu-for-sharepoint-2010-is-now-available.aspx (see Stefan’s comments).

I tried this procedure several times with no luck!

I found a further article here http://social.technet.microsoft.com/Forums/en-US/sharepoint2010setup/thread/8406c0f6-5de9-4079-bf37-8640a60d1a19/ and detached all content databases from the farm and this did not work.

Basically time and time again receiving the breakdown at the bottom of each attempt:

Total number of configuration settings run: 3

Total number of successful configuration settings: 2

Total number of unsuccessful configuration settings: 1

Successfully stopped the configuration of SharePoint Products.

So at this point I was starting to run out of ideas and short of reinstalling which I really didn't want to do.

Solution

I finally managed to resolve my issue by taking a brave step of upgrading the farm (see my previous note that I was very short of ideas and time at this) to a later cumulative update (Should this have failed I had a complete backup prior to the upgrade to fall back on). Not being a fan of installing the latest CU just for the sake of it being the latest I chose February 2011 CU (Build number 14.0.5136.5002) and after implementing this CU I was successful in upgrading with a concluding statement along the lines of 4 out of 4 tasks completed successfully.

As always I hope this helps if you end up reading this, please do leave me a comment on your experiences.

I’m speaking at European SharePoint Best Practices Conference 2011

2011-03-23T12:41:00.001+00:00

I’m delighted to announce I'm speaking at the up and coming European SharePoint Best Practice Conference 2011 on Wednesday 13th April 2011 at 11:30 http://www.sharepointbestpractices.co.uk/Abstracts_COM.html#COM614:

This session will talk about sharing thoughts about how to prepare for SharePoint 2010 whether this be an upgrade or a greenfield implementation and things to consider to make the implementation as successful as possible. I will touch on planning the upgrade / implementation and how best to do it, who to involve, discuss challenges and how to overcome them

Due to work commitments I’m only going to be at the conference on the Wednesday, however I look forward to meeting some of the friends I've connected with on Twitter face to face so come and say hello and hope you can join me in my session.

Hide / Remove Web Parts in SharePoint 2010

2011-03-21T18:44:00.001+00:00

I came across a requirement where a client was looking to hide web parts for use in SharePoint. Before reading any further I’ve only carried out some light testing on this to see if its suitable but seems a viable solution and happy to get feedback on this.

The ideal solution would be to have a similar user interface to that that hides site templates and page layouts however this isn't available for web parts.

So the solution is really simple, for those web parts you don't want to display you can do one of two things:

1. Delete the web part from the gallery

2.Sever security permissions for that web part for those you don't want to use the web part.

I prefer the option 2 as this allows to easily reinstate the web part should things change in the future.

So exploring option 2 navigate to site settings at the root of the site collection and select web parts from galleries.

Click edit next to the web part you wish to hide.

Web parts gallery – sever inheritance add users who you may want to add these web parts.

As shown above click ‘manage permissions’. From here as you would with any item in SharePoint edit the permissions to allow only those who you wish to use this web part.

Simply stop inheriting from the parent and remove these users who you don't wish to have access. For the purposes of my quick test I removed all users so you will have to do some more testing as to allowing specific users.

For a quick test I removed the advancedsearchbox web part and logged in as standard site admin (not site collection admin) and the web part was removed from the list available as shown below when editing a page.

To add the web part back into the list simply reapply inheritance to the specific web part.

Your web part should then reappear in the list below.

Please note no IISRESET is required to do this.

SharePoint User Group (SUGUK) Slides – Preparing for SharePoint 2010 & Real world experiences

2011-03-14T09:08:00.001+00:00

I’ve added my slides below from the SharePoint User Group meeting I presented at on 9th March 2011.

My presentation was on Preparing for SharePoint 2010 and Real world experiences. I wanted to share some of the challenges and issues I face when consulting so to help others where possible avoid these or at the very least be aware of them so there’s no hidden surprises.

This was my first time presenting to the user group and I have to say I really enjoyed it. It was really pleasing to hear it was encouraging others who haven't yet presented to start thinking about it.

Those who are interested in speaking but not quite sure what to present on I thought I'd share a few of personal interest to me:

Access Services
Claims
Forefront
PowerShell
Performance Point / BI
Accessibility

Feel free to leave a comment with your thoughts on what you’d like to see at the next event and I’ll happily feed them back.

Thank you to everyone who attended including Steve Eyton-Jones for organising and a special thank you to Penny Coventry who not only provided 2 of her books (Microsoft SharePoint Designer 2010 Step by Step) to give away at the event but also offered to cover for me as I was in danger of not making it. See you at the next one!

Changing Master Page for SharePoint 2010 Blog Site (Workaround)

2011-02-16T16:56:00.002+00:00

So I thought I'd share a quick find with you regarding 2010 blog sites (and may apply to other templates as well). I tried to search for a fix for this but search engines and searching for “SharePoint 2010 Blog master page” proved unsuccessful.
I created a blog site and from site settings changed the master page to a custom developed page (having to enable publishing features to be able to do this through the UI). After applying the master page change the new master page did not render on the blog site.
With credit to my colleague Inderjit Singh (Link to Linkedin) the workaround is to apply the custom master page to the system master page section. This master page setting is for all application pages and site settings pages as shown below.

At this point I must stress that applying the master page to the system may cause many knock-on effects and further testing of each application page will be required to satisfy using and suggesting this to a client and could cause a lot more work with regards to styling.
I strongly believe this is not by design behaviour and have raised this with MS and will as always keep you posted.
Further information about the blog template
Each page in the blog site contains a reference to default.master (known as a token) as show below:
~masterurl/default.master
Changing this reference to custom.master as shown below will render the custom master page selected in the site master page section (shown in the screen grab above):
~masterurl/custom.master
The issue of changing this on each page means that each page becomes un-ghosted potentially causing issues later on and i would strongly advise against recommendations in other blogs to edit the pages directly on the file system as this will fix the issue short term but will cause more problems in the long run.
*** Update 18/05/11 ***
After numerous diagnostic tests I was provided with a support KB that was applicable to MOSS 2007 http://support.microsoft.com/kb/936908. The KB suggests two ways to work around the issue. One of these was to simply enable the publishing feature on the site you need to modify the master page (well you have to do this anyway to be able to change the master page through the UI) and this didn't work. The other option was what I described in my original post above which was to change the system.master which I have explained the issues this could cause by doing so.
This case has now been closed with Microsoft on the basis I have been informed that the blog functionality is classed as collaboration (and not publishing) functionality.
After writing various paragraphs here on my view of the above outcome of the case I felt these were best removed!
I welcome your comments and feedback.

Managed Metadata changes not applied to list items after term change

2011-02-15T18:17:00.001+00:00

So scenario is that you have a SharePoint 2010 managed metadata term store up and running and you need to make a change to one of the terms. Lets just say that you have spelt one of the terms wrong and need to update it on all items you have added that have selected this misspelt term.

In my example I have a list of countries in the term store and have spelt England wrong and is spelt Egnland.

Jumping a few steps ahead I have a simple list created with a managed metadata property as shown (Noticing the Tag is spelt incorrectly).

So once the item is committed to the list it will look as shown below.

Navigating back to the term store you make an update to the incorrectly spelt term.

After updating and saving the term navigating back to the list you assume that this change should reflect on the list item. Wrong! A timer job needs to be run to update this on list items.

The timer job in question is the Taxonomy Update Scheduler and this runs every hour. You can manually run this timer job from central admin to force an update making sure that you run the timer job associated to the web application where your list is stored.

Once the timer job ran the list automatically updated (within a matter of seconds).

Adding a custom User Profile Property to SharePoint 2010

2011-02-11T14:22:00.001+00:00

This one recently caught me out when creating a custom user profile property and thought I'd share this.

To create a custom user profile property navigate to the the User Profile Service Application –> Manage User Profile Properties and click on New Property.

On the New Property page where you enter all the configuration of the property type right at the bottom there is a ‘Add New Mapping’ section which is where you would sync and connect this to your data connection (noting that my data connection had been removed from view below).

The requirement for my property was simply to be a string value with no connection to a data source and the above section confused me that I needed to add a property regardless. This is not the case and you do not have to add a property at this point for the creation to be successful.

Should you need to add a property mapping to a data source above shows how it looks (again my data connections have been removed).

There are many different mappings that can be configured for creating these properties however my post was simply to make you aware of what caught me out.

Reference: http://technet.microsoft.com/en-us/library/cc262327.aspx

Installing (French) language pack causes Event ID 6464 UPS issue and access to check timer jobs errors

2011-01-27T14:59:00.001+00:00

I’ve just installed the French language pack to carry out some testing for page variations (http://technet.microsoft.com/en-us/library/cc262404.aspx).

I followed the process of installing the language pack and then running the wizard (PSConfig) and all seem to run well apart from I was guessing it ran well as frustratingly the wizard is all in French and my French is a little rusty to say the least.

My next step was to setup a variation within SharePoint and all went well, apart from the fact that the timer job for variations runs between midnight and 3 am so I went to manually run the timer job and was presented with the friendly error message ‘Operation is not valid due to the current state of the object’

Ok so next step was to do the usual, IISRESET then reboot then re-run PSConfig. Still no joy, so next step was to check the logs and event viewer which showed the error and was referring to the User Profile Application Language Synchronization Job.

Referring back to my earlier comment about my French translation it seems that it did not complete the install properly thanks to @givenscj for his suggestion that the language may have failed (I have to say it is strange that just because I’m installing a French language pack it is assumed I as the admin know French which clearly I don't! So this didn't help the matter!).

I reinstalled the language pack to no avail and still had the same issues UPS error and couldn't check my timer job.

Again ran IISRESET and still no luck. So as I was working on a test environment I was feeling ruthless and deleted the User Profile Service and again no joy.

Brian Lalancette suggested forcing a PSConfig with the command:

PSConfig.exe -cmd upgrade -inplace v2v -passphrase <FarmPassphrase> -force -wait

This popped up a VS2010 debug window.

Not being a developer this wasn’t of great use to me so the last option I had left was to update the farm to December 2010 cumulative update (http://support.microsoft.com/kb/2459257).

I attempted to revert back to my original install but to no avail. My next step was to check the ULS logs and found the following entry:

System.InvalidOperationException: Operation is not valid due to the current state of the object.
at Microsoft.Office.Server.Administration.UserProfileApplicationJob.get_UserProfileApplication()
at Microsoft.Office.Server.Administration.UserProfileApplicationJob.get_DisplayName()
at Microsoft.SharePoint.ApplicationPages.JobDefinitionsDataSourceView.AddRow(SPJobDefinition jd, DataTable table, DataSourceSelectArguments selectArguments)
at Microsoft.SharePoint.ApplicationPages.JobDefinitionsDataSourceView.AddService(SPService service, DataTable table, DataSourceSelectArguments selectArguments)
at Microsoft.SharePoint.ApplicationPages.JobDefinitionsDataSourceView.AddFarm(SPFarm farm, DataTable table, DataSourceSelectArguments selectArguments)
at Microsoft.SharePoint.WebControls.TimerJobDataSourceView.FillDataTable(DataTable table, DataSourceSelectArguments selectArguments)
at Microsoft.SharePoint.WebControls.DataTableDataSourceView.Select(DataSourceSelectArguments selectArguments)
at Microsoft.SharePoint.WebControls.AdministrationDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments)
at System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback)
at System.Web.UI.WebControls.DataBoundControl.PerformSelect()
at System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound()
at System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls()
at System.Web.UI.Control.EnsureChildControls()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

I found the TechNet forum below where someone else has experienced this issue but with no luck resolving this: http://social.technet.microsoft.com/Forums/en-US/sharepoint2010setup/thread/45cd502a-580d-49ab-85bb-e5ab10294474.

If anyone has any ideas or has resolved this issue feel free to post a comment.

Cannot use SharePoint feature to deploy content types using content type hub functionality when using XML elements

2010-11-29T09:43:00.002+00:00

*** Update 11/05/11 ***
Over the last few weeks I have been contacted regarding this post and had contradicting reports that you are in fact able to create a feature to deploy content types to a content hub without the need for the feature to be enabled on each subscribing site collection.
My original issue experienced was also replicated by others once I’d posted this issue so this seems a strange one as since both of us are unable to recreate the issue.
Upon retesting the issue I can confirm that you are able to deploy a feature to a content type hub without the need to enable the feature on subscribing site collections.
Thanks to Chakkaradeep Chandran for following up on this and feeding back his findings.
*** Original Post ***
I’ve recently stumbled across a restriction of using the content type hub in SharePoint 2010 and I am a little surprised by its behaviour. From a quick search around there was very little discussing this so thought I’d post a blog on my findings.
So the plan was to leverage the new content type publishing feature in SharePoint 2010 alongside programmatically deploying site columns and content types using a feature to simplify deployments. Admins and developers of MOSS 2007 will recall that to deploy content types to multiple site collections easily required a feature creating with the necessary customisations. A downside to this was that every time you needed to update the content type you had to redeploy the feature with the updates.
An assumption on my part with the new SharePoint 2010 hub was that when you create a feature to deploy content types all you needed to do was to enable that feature on the content type hub and publish this out to subscribing site collections. Unfortunately it doesn't seem to work this way as subscribing site collections do not receive the published content types and looking at the error log on the receiving site collection states that it it requires the custom content type feature to be enabled which defeats the object as we will be back to the MOSS 2007 scenario mentioned above.
~~So some thoughts around options available to use to deploy content types to the content hub for successful publishing:~~

~~Raise it with Microsoft~~
~~Create a PowerShell script that can receive a maintainable XML input file to update the content types on the hub.~~
~~Not sure if this is possible but if the feature could be enabled on the subscribing site collection and have a dependency on the ‘Content Type Hub’ feature before deploying the content types.~~

~~Thanks to~~ ~~Chris O’Brien~~ ~~for confirming this for me on~~ ~~Twitter. As always I welcome your comments / feedback / findings on this.~~
~~*** Update 30/11/2010 ***~~
~~After posting my blog entry a great SharePoint community member~~ ~~Nick Hadlee~~ ~~posted a comment with his initial thoughts / frustrations and kindly shared further finding’s based on a quick test he carried out.~~
~~So to explain further the way the feature I described above was deployed was using an XML file which requires no code.~~
~~Nick pointed out that if you created a code based deployment of the content types using a feature receiver this works. This is effectively the same as using the UI to enter content types / columns.~~
~~So to conclude there is a workaround to deploy content types using a feature however this requires coding rather than the XML format.~~
I did have a thought around enabling the feature on all site collections and then seeing if any updates from the Hub were published however I’m sure this will get messy in the long run as updates and changes are applied.
~~Credit to~~ ~~Nick Hadlee~~ ~~for his input and also my client who I’m currently working with who has helped in investigating this.~~
~~*** Update 10/01/2011 ***~~
~~Nick Hadlee~~ ~~has thankfully posted his workaround which can be found~~ ~~here. Again thanks Nick for following this up and hope its useful.~~

Video and Audio option not available on Ribbon for SharePoint 2010 site

2010-11-17T12:24:00.001+00:00

If you’ve created a team site and want to add video’s to your site with Wiki page feature active as the homepage (add text directly to the page you are editing without the need for a web part). You will notice the Video option is not available on the Ribbon.

To enable adding video and audio on the page simply enable the publishing feature at site and site collection level and when you re-edit the page you will notice that the Video and Audio option is available.

Hope that saves you some time.

[Updated] Side effects of attaching additional SharePoint 2010 servers to the farm using PowerShell

2010-11-17T09:12:00.001+00:00

Over the last few weeks I have been implementing various SharePoint environments for clients such as PoC’s, Dev, Pilots to name a few. All these environments have been single server farm deployments which I have found the community autospinstaller PowerShell script useful in configuring the majority of the install.

Now the challenge comes when you want to add additional servers to the farm. Initially the version of the installer script used had an issue where the logic for joining the farm worked but for some reason did not enable relevant features / services (osearch), I later discovered this when trying to add the query role to the new addition to the farm only to find that I could not select the server from the drop down in the UI.

After resolving this issue the new server did appear in the drop down but this is where I hit another issue and this is where I am currently at but read on for my findings and workaround.

So at the stage when I’m trying to assign the query role to the additional server in the farm using PowerShell the script just hangs, likewise if I try to assign the role via Central Admin I experience the same behaviour.

After many a roll back of VM snapshots I found the unlikely issue to be related to joining the farm using PowerShell. All PowerShell commands have been executed as per the TechNet article: http://technet.microsoft.com/en-us/library/cc262839.aspx#section6 and THE SERVER WILL JOIN THE FARM SUCCESSFULLY! Yes that's correct the server will join the farm with no errors. This is why it took so long to diagnose the farm attach as the problem as it didn't fail!

So how did I find this out? I simply added the server using PSConfig (The grey wizard as its known) and assigned the query role via Central Admin and all worked fine.

I have raised this issue with Microsoft and after a week and a half they have managed to experience the same issue. I’m currently working on the issue with them however in the meantime I would suggest adding the additional servers to the farm using PSConfig and then running PowerShell scripts again.

Users of the script may have not come across this issue yet as SharePoint 2010 RTM is only just over six months old and most environments being deployed are in preparation for a production 2010 build and those who have SharePoint 2010 in production may have built the server via the UI. Development environments may also have relaxed security even if a multi-server farm has been installed where the install account may have been a domain admin which may bypass these issues (be happy to hear your experiences on this).

As well as failing to assign search roles to additional servers, another issue I have discovered is deploying solutions. Deploying solutions to the new servers hangs and fails to deploy successfully.

Background to my environment:

Windows 2008 R2, SQL 2008 R2.
A specific install account was used to create the farm (not the Farm account)
The install account is NOT a domain admin
The install account is only admin on the local SharePoint servers
The farm account is not local admin or domain admin on SharePoint / SQL / AD servers
AD is on a separate server
SQL service account is running under a separate account to any of the SharePoint services
The search account is a dedicated search account (and so is the service application pool account (separate to the service account))

I will update my blog with progress. Credit also goes to my colleague James Brennan for assisting with this issue.

*** Update 17/12/2010 ***

After weeks of emailing back and forth with Microsoft Support I have now had confirmation that a hotfix will be created to address the issue, no timescales for the fix have been provided at this stage.

*** Update 23/03/2011 - Workaround ***

Contrary to the update on 17/12/2010 I have now received confirmation of a workaround to the issue.

The resolution is really simple. Basically after following the steps to add an additional server to the farm from the TechNet website http://technet.microsoft.com/en-us/library/cc262839.aspx#section6 there is a step missing where the SharePoint 2010 Timer (Job) (and Possibly the Admin Job) windows services require starting manually.

Once you start the service and wait a short time you should then successfully be able to assign server roles to the new addition to the SharePoint farm.

Next steps are that I have requested that this additional step to start the SharePoint 2010 Timer service is added to the TechNet article (http://technet.microsoft.com/en-us/library/cc262839.aspx#section6).

More information

Another symptom experienced when attaching new SharePoint servers to the farm is that when you try and assign the query role via the user interface you receive the following error:

‘The path must point to a fixed, NTFS drive whose root directory exists’

I also stumbled across a blog by Abdul where he has a different solution to resolving this using Repair-SPManagedAccountDeployment.which I’m guessing also starts the Timer service along the way.

Adding search scopes to site collections in SharePoint 2010

2010-11-12T10:37:00.001+00:00

In MOSS 2007 you were able to hover over the search drop down and take you to the option to add new SSP defined scopes to your site collection. In SharePoint 2010 they’ve removed the hyperlink from the group.

SharePoint 2010 search scopes are configured in pretty much the same way as in MOSS 2007, the only difference being the SSP has now become a Service Application although the Admin UI is the same.

Once you’ve created your scope in the Service Application as you did in MOSS 2007 navigate to the search scopes settings in the site collection and instead of clicking on the name of the group click on ‘Display Groups’ (circled in blue above) and this will then give you the link to the group to administer the scopes you want to add.

Not sure why this has changed as it simply adds more clicks to achieve the same result, perhaps this is an issue with the style that has not been picked up yet?

Published Content Types not replicated to subscribing SharePoint 2010 blank site template site collection

2010-11-09T19:10:00.001+00:00

I discovered an issue which was documented in a blog by Wictor Wilen regarding using a blank site template and fell into this trap myself as there seems no point turning on lights on a site collection that will only be used as a content type hub (Turning on lights would allow anyone to think it was somewhere to put content right?).

As I’d already created the site collection with a blank site I wanted to understand what exact feature was missing.

So the problem is that if you create a subscribing site collection blank root site then published content types aren't replicated to the newly created blank site collection. I’d made sure all the timer jobs related to the content hub we’re run but no luck.

I stumbled across a post which didn't specifically relate to the issue to but I had a feeling I was in the right place.

The feature is called TaxonomyFieldAdded and by querying a blank site you will notice this is not enabled whereas on a Team Site it is.

So I enabled the feature by running the following command from PowerShell:

Enable-SPFeature -Url "<enter url here>" -Identity "73EF14B1-13A9-416b-A9B5-ECECA2B0604C"

Almost instantly the published content types appeared in the blank site collection.

Why after I enable the Document ID Service Feature do I not see Document ID's on my documents?

2010-11-03T12:34:00.001+00:00

I got caught out when enabling the Document ID service for SharePoint 2010 trying to understand why instantly after enabling the feature my documents did not have unique ID's so I thought I'd write a quick blog on how to do this.

Navigate to the site collection that you require the Document ID Service to run on and activate the Site Collection Feature as shown below.

Again from Site Collection Administration navigate to Document ID settings as highlighted in red below:

From this section you can provide a predefined document ID naming prefix to suit.

If you have existing documents in the documents in the site collection there is also the option to reset all the document ID's with the new naming prefix.

So at this stage you would assume that the document ID's are there when you visit a document center after enabling the

settings above? Wrong! Although this feature has been activated the process of assigning the ID's to documents has not yet been run and this is carried out via a SharePoint Timer Job.

Navigate from Central Admin to monitoring then click Review Job Definitions.

From the list here make sure the correct web application is selected in the top right.

Then run the Document ID enable/disable job. This basically propagates changes to content types across all sites after the Document ID feature has been reconfigured.

Once this Timer Job has run (depending on how many content types you have created should not take long) you then need to run the Document ID assignment job which will assign document ID's to all items in that specific Site Collections.

SharePoint 2010, Administrator Pro 70-668 Exam Passed

2010-10-28T15:58:00.001+01:00

I passed another SharePoint exam Monday and I’m now a MCITP – Microsoft Certified IT Professional.

Again I had a few people ask how did I study for this and the same material applied as to my 70-667 blog.

So my next steps are to take the SharePoint 2010 dev exams – yes you read right! I think PowerShell has refreshed my memory of my days of coding C for DOS (That sounds old!) and thought I’d delve into the dark side.

Good luck if you’re taking yours!

SharePoint and Exchange – better together?

2010-10-14T17:48:00.001+01:00

I just wanted to share some thoughts I have had since attending TechEd back in 2009 and have been meaning to blog about this ever since.

Walking around the exhibition hall I stopped by the Exchange stand and had a quick demo of some of the new features of Exchange 2010 which had been released at TechEd during the Keynote. I was interested to see that the Exchange product had functionality for users to update their AD information which had been something that had been lacking from SharePoint functionality. I asked how this was achieved and it was by directly writing back to AD.

Roll on to the SharePoint 2010 release back in April this year and was pleased to find that SharePoint also has update AD functionality although this works in a different way as it replicates the AD information into a SQL DB then writes back the information from SQL to AD via FIM (Forefront Identity Manager).

It made me think ‘why don’t the Exchange team and SharePoint team work together to provide a consistent solution?’. Possibly due to internal competition who knows.

So why Exchange and SharePoint better together? Well as SharePoint now has service applications I see no reason why Exchange can’t be one. Previously there was talk of Exchange mailstore edb files becoming SQL DB’s but this never materialised, possibly due to performance of SQL compared to hosting on the file system. Well now SharePoint 2010 / SQL 2008 has RBS functionality along with service apps this should go some way to addressing the performance of using SQL whilst still keeping the mailstore files on a file system.

With email tightly integrated into SharePoint all the same rich functionality can be applied to email management whilst retaining a single centralised web based management tool.

So will it happen, we’ll have to wait and see…

SharePoint 2010 Configuring 70-667 Exam Passed!

2010-09-28T19:12:00.002+01:00

This is the first blog I’ve wrote in a while and long overdue! I’ve been a little busy over the past couple of months. One of the reasons for being busy was studying for my SharePoint 2010 exam.
I sent out a tweet after passing my exam and was asked if I had any tips. Unfortunately due to my NDA I can only point you to the exam page where a full list of the skills measured can be seen.
How did I study I hear you ask?
Well firstly I installed SharePoint 2010 a few times and got to know the user profile service very well! Which led me into the new Service Apps layout and functionality nicely. This led to lots of playing with central admin and SharePoint generally.
Following on from this I ran through all the virtual labs some were very good, some were not so good. The labs can be found here http://technet.microsoft.com/en-us/bb512933.aspx.
I also read a lot of articles on TechNet http://technet.microsoft.com/en-us/library/cc303422.aspx. Now that SharePoint 2010 has been released a few months content is starting to become populated with the right level of detail.
I’ve now become addicted to podcasts as well. I drive to work or sit on the train and radio in the morning just irritates me (I wont get personal). I listen to a couple of excellent podcasts and would strongly recommend if you are a SharePoint enthusiast you do the same. The podcasts are:

Todd Klindt’s Weekly Net cast – Shares some good experiences on week to week issues encountered
SharePoint Pod Show – Some great guys on here interviewing various SharePoint people on the road

Finally I purchased the book SharePoint 2010 Administrator's Companion from the Book Repository as Amazon kept delaying my order.
Taking the exam
Currently Prometric / Microsoft are running a free second shot offer if you buy a pack of 2 or more exams http://www.prometric.com/microsoft/certpacks. This offer runs until June 2011 so there's plenty of time. I’d highly recommend this as it gives you that extra security and takes the pressure off you to pass first time round without having to put your hand in your pocket again.
Additional resources
After running through all these virtual labs I found a heap of other resources which you may find useful:

SharePoint 2010 Advanced IT Admin Virtual Labs
http://technet.microsoft.com/en-us/sharepoint/ff420396.aspx – (Videos can be downloaded to view offline here)
SharePoint 2010 Developer Virtual Labs
http://msdn.microsoft.com/en-us/cc707678.aspx
SharePoint 2010 Advanced Developer Labs and more
http://msdn.microsoft.com/en-us/sharepoint/ff420377.aspx

Also SharePoint user groups are a great way of people interested in SharePoint getting together and sharing experiences.
The UK SharePoint user group can be found here http://suguk.org/ or search for ‘SharePoint User Group’ to find one in your country / area.
(Updated 19/05/11) Sample exam questions for the exam can be found here http://www.accelerated-ideas.com/aiMExamsChoose.aspx
Conclusion
Just to conclude exams do help in benchmarking skills against recognised accreditation, however the real skill with SharePoint is knowing when to use what you know and where. Unfortunately exams can only teach you so much the rest is down to real world experience.
With thanks to Marc Molenaar for sharing his thoughts and views on passing the exam.

How to detect broken links in SharePoint 2010

2010-07-27T12:00:00.000+01:00

I’ve been doing some digging over the last week as to an easy / free way to detect broken links in SharePoint 2010. This approach uses Google Analytics for the SharePoint site whether external or internal facing. To setup Google Analytics for SharePoint see my previous blog explaining how to implement this.

So the next step is to add the code supplied from Google here to the SharePoint 404 page. This will track how many times the page was hit and also the referring page (the Google article explains this in more detail). It is worth noting that for the code to run requires the client pc’s to have internet access, SharePoint servers do not.

The downside to this approach is that you have to wait for users to actually hit the page before knowing where the broken links are, therefore this scenario may not be ideal for every scenario as you may want to find broken links before your users do!

From a brief scan of the internet another tool worth looking at is the Search Engine Optimization (SEO) Toolkit which can be downloaded here and can be installed on client pc’s to avoid server installs. A blog by Tristan Watkins of using this with SharePoint can be seen here.

SharePoint 2010 user profile property fields disabled after full farm restore

2010-07-15T13:20:00.001+01:00

I received this error on a SharePoint 2010 full farm restore when trying to access the Managed Metadata Service application. The farm was a single server with local SQL installed.

I originally received an error relating to certain user profile properties stating:

There was a problem retrieving data for this field. Updating values in this field is disabled temporarily. You can still update values in other fields

I found a blog article by Wictor Wilén which pointed me in the right direction and when I clicked on the Managed Metadata Service I received the error:

The Service Application being requested does not have a Connection associated with the Central Administration web application. To access the term management tool use Site Settings from a site configured with the appropriate Connection

I discovered the reason for this error was due to the restored service applications not being associated to the default Application Proxy Group (as they were before the restore).

Navigating to Central Admin->Application Management->Configure service application associations and re-adding the service application back into the group will resolve the issue.

Synching custom Hotmail domains onto iPhone

2010-07-09T17:11:00.001+01:00

Following on from a previous blog I talked about hosting email with hotmail but still keeping your custom domains for free.

If you try and sync your custom domain on the iPhone mail it will not recognise the settings and ask you to enter the pop / smtp settings which I couldn’t find documented anywhere.

So here’s what you need to do (assuming this is your first mail account).

Tap mail
Select other
Enter your name email address and a description. This will not detect your settings and on the next screen you will need to enter the information manually.
For incoming mail server enter:

Host Name: pop3.live.com
User Name: ‘Your custom Hotmail address’
Password: ‘Your password

Outgoing mail server:

SMTP: smtp.live.com

Thats it! Your custom hotmail is now synch’d.