I have just finished troubleshooting a SharePoint 2010 issue where the Ranking (0-5) field was not updated on a post list even after forcing the "Social Data Maintenance Job" and "Social Rating Synchronization Job" to run.

Problem #1:  The rating data is associated with the SPListItem by URL. Depending on how you access the site/item, rating web service may think you are voting on two different items.

For example, the following URLs will take you to the same list item but the social DB will treat it as two different items, and the rating aggregation will seem incorrect to the end user:

http://server /Lists/Posts/Post.aspx?ID=2


Problem #2: If the alternate access mappings is not here for server.domain.com, the social rating synchronization job will fail with the following error when trying to update the rating data:

Unexpected       RatingSync: Unexpected exception processing http:// server.domain.com,/Lists/Posts/3_.000. Error:System.IO.FileNotFoundException: The Web application at http:// server.domain.com/Lists/Posts/3_.000 could not be found. Verify that you have typed the URL correctly. If the URL should be serving existing content, the system administrator may need to add a new request URL mapping to the intended application.     at Microsoft.SharePoint.SPSite..ctor(SPFarm farm, Uri requestUri, Boolean contextSite, SPUserToken userToken)     at Microsoft.SharePoint.SPSite..ctor(String requestUrl)     at Microsoft.Office.Server.SocialData.SocialRatingManager.PropagateRating(SocialRatingAverage ratingAverage)

Lesson learned:

When using the social ranking feature in SharePoint 2010, also remember to do the following:

  1. define alternate access mappings up front
  2. define public URLs
  3. communicate to the user what URL will be used to access the site