Tuesday, 9 November 2010

SharePoint & Project Server 2010 October CU – Critical Info

Microsoft has discovered a critical issue in the recently released October Cumulative Updates for SharePoint Server 2010 and Project Server 2010, and have removed the files from download availability.  If you have already downloaded the CU, do not install it.  If you have installed the CU, please contact Microsoft Support for assistance.  Microsoft will be posting additional information about the issue as soon as they have it, and will make the Cumulative Update available for download again as soon as the issue has been fully resolved.

Issue Details

The October Cumulative Update makes some changes and updates to the user profile database.  Unfortunately there are certain situations where this update does not complete as expected and leaves the update in an inconsistent state.  This causes issues with several SharePoint features that use the User Profile Application such as MySites, People and Expertise Search & Ratings.

If you have already applied the October Cumulative Updates

You should perform the following steps below;

Note: If you encounter any issues following these steps or have questions specific to your environment/deployment please call Microsoft Product Support for assistance.

Check the following locations for the Microsoft.Office.Server.dll to determine the version. If the version is 14.0.5128.5000 or greater, the October CU is applied.

  • C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\ISAPI\Microsoft.Office.Server.dll
  • C:\Windows\assembly\GAC_MSIL\Microsoft.Office.Server\\Microsoft.Office.Server.dll

Using Central Administration perform the following steps

  1. Click on Manage Service Applications
  2. Select User Profile Service Application by clicking on it
  3. At the top of the screen on the Service Applications tab, click on Manage
  4. On the Manage Profile Service: User Profile Service Application page, click Manage User Permissions
  5. On the Permissions for User Profile Service Application dialog, you will need to;
    • Specify the desired user accounts and click the Add button to add them to the list
    • By default SharePoint 2010 RTM has these accounts;
      • NT Authority\authenticated users
      • All Authenticated Users
    • Once the user accounts are in the list, you will need to set the permissions appropriately for your environment and click OK.

Note: info as received from Microsoft SharePoint Team

Wednesday, 3 November 2010

SharePoint 2010 – how to view/list all imported User Profiles?

Applies to: SharePoint 2010

If you encounter an issue during the user profile import process, how can you view/list all imported user profiles to start troubleshooting? Or, you may simply want to view the complete list of profiles imported from AD.

Below is a note from Microsoft Tech Support which I found useful;

It seems that there is no built-in method to list out all the users’ profile and associated properties. However, all the users profiles are stored in the SQL database “User Profile Service Application_ProfileDB_XXX” > table “dbo.UserProfile_Full”. You can run a SQL query command “Select * from dbo.UserProfile_Full” to list all the users.