Missing Activity Feeds in Activity Feeds Web Part

Everybody has seen the out of the box Activity Feeds web part displayed on default page of SharePoint 2010 my sites.



Don't be surprised if the number of activity updates being displayed are less than the number you set through "Number of items to show" property.

I had this problem in a project and Microsoft was contacted. Well, according to them, this is by design. Following is Microsoft's response in their own words:

Disclaimer: Following content is being published as is with no guarantees regarding the accuracy.


*************************Microsoft's Response**************************************

Root cause:

================

5 activity types(as listed below) will go through security trim. For these types of activities, as long as it contains an external URL link(the url other than mysite root and mysite’s layouts pages, the activity will be trimmed.


BlogUpdate

SharingInterest

SocialTaggingByColleague

NoteboardPosts

SocialRatings

Conclusion:

======================

This is the by design.

The news feed page retrieves the user’s activities from database, with the number limit set in the web part.

But not all activities can be displayed on the page for security concern. So after security trimming, sometimes you would find some activity is missing.

However, the reason why we design it this way is based on the performance perspective from SQL side. Let me give you an example, then you could understand this design:

1. We set the display item to 20, then SharePoint will go to SQL to query out 20 items (query 1)

2. Then SharePoint will security trim these 20items, let’s assume 10 remains

3. If we do not stop here, then SharePoint will go to SQL to query out 10 more items (query 2)

4. Then, security trim these 10, assume 1 remains

5. Then go to SQL to query out 9 more(query 3)

6. …. (repeat 4-5, until it get 20 results)

7. You can see, at some extreme scenario, SharePoint will send unlimited query to SQL server, it will definitely bring down the SQL performance. So that’s why we only design SharePoint to query only once.

********************************************************************************

Comments

Post a Comment

Popular posts from this blog

PowerApps Form for SharePoint and Access Denied Errors

Image
Error When using SharePoint's Online's customise form option to create PowerApps forms, we may encounter the error below: An error occurred on the server. Server Response: Access denied. You do not have permission to perform this action or access this resource.  This is often caused by lack of permissions on underlying lists. Scenario I was using multiple list data sources in a single PowerApps list form. Form had staged input screens for related data and a group of end users was not allowed access to the list corresponding to the last stage of input. Nonetheless, when the form opened for any user, PowerApps was trying to load all the data sources resulting in above error. The Fix I could conveniently fix the error by granting at least read-only access to end users on all lists. However, the list causing error had confidential data only restricted to few users.    An easy fix is to add an empty folder, break it's inheritance and assign less privi...
Read more

Prevent site owners from creating subsites in SharePoint 2010

Image
If your users are naughty enough and you want to keep them from adding new sub sites for a specific web application. Just follow the steps below: This is specially useful when the naughty users are site owners such as in case of My Sites. 1. From Central Administration, Go to “Manage Web Application” screen. 2. Select a web application and click the “Permission Policy” button from the ribbon. 3. A screen will pop up with all existing permission levels. 4. Select “Add Permission Policy Level” link from the screen. 5. On “Add Permission Policy Level” screen, name the permission level appropriately. 6. Under Site Permissions category, select the “Deny” option for “Create Subsites” permission and save it. 7. You will see a new Permission Policy Level in the list of existing ones. 8. From the ribbon, click “User Policy” button. 9. A screen will pop up with all existing user policies. 10. Click “Add Users” link from Policy For Web Application screen. 11. A wizard will open, allowing you to s...
Read more

Getting Page Field Value in custom publishing page layout

I wanted to create a custom publishing page layout which should render certain UI elements based on the page metadata. For e.g. a page metadata field called "Page Type" being used to display different links on pages (created with the page layout). Surprisingly, first step in the process i.e. reading the page field using SharePoint Javascript API proved to be rather painful as my good friend google wasn't willing to put it on my plate. Finally came up with some code to get this done so sharing below:---- Include this code into your custom publishing page layout to query page metadata fields within the layout: /**************************************************************************************/ var pageItem; //variable for list item of page being displayed (which uses this page layout) var pageFieldNameVar = '[internal name of a custom page field]' ; //variable for page field to be retrieved var context; // This variable will cont...
Read more