Recently published content for SharePoint 2013

Published the week of July 21, 2014

New article

Supported and unsupported Documentum object types and properties in SharePoint Server 2013   Learn which object types and properties the SharePoint Server 2013 Indexing Connector for Documentum supports or does not support.

Updated article

Deploy people search in SharePoint Server 2013   Added some information about UPRE.

Understanding multi-tenancy in SharePoint Server 2013   Updated a Windows PowerShell script for the Search service.

Published the week of July 14, 2014

Updated article

Hybrid for SharePoint Server 2013   Updated the table about the worksheets that are related to this article.

Published the week of July 7, 2014

Updated article

Plan user profiles in SharePoint Server 2013   Updated the information about default privacy settings.

Published the week of June 30, 2014

New articles

Plan hybrid search for SharePoint Server 2013   Plan to configure a SharePoint hybrid environment so that user searches from a Search Center display hybrid results.

Migrate OneDrive for Business document library files from on-premises SharePoint 2013 to Office 365   Learn how to help people in your organization move their OneDrive for Business files from their SharePoint Server 2013 on-premises environment to Office 365.

Applies to: SharePoint Server 2013

SharePoint 2013: Could not load type 'Microsoft.AnalysisServices.SPAddin.ReportGallery.ReportGalleryView'

Issue:  One user reported that he has removed the PowerPivot on his SharePoint 2013 PowerPivot library but still is it showing on SharePoint site and after clicking it he gets error.

Error: Could not load type 'Microsoft.AnalysisServices.SPAddin.ReportGallery.ReportGalleryView'.

Troubleshooting:

For troubleshooting any issues with the PowerPivot it is quite important to know about the how PowerPivot is deployed.

Deploy PowerPivot Solutions to SharePoint

After understanding what steps were followed to delete the Delete PowerPivot Gallery, we notices that PowerPoint gallery is still existing on the Site.  

Resolution:

Checked on the Solution deployments tab you can redeploy the Solution on your web app in order to recover the documents or can retrieve the document using Explorer view on the library.

Supporting KB article form MS of the solution is http://support.microsoft.com/kb/2752605

Other reference Article: http://msdn.microsoft.com/en-us/library/ee210607.aspx

SharePoint 2013: Please enable scripts and reload this page

Issue: We have several user reporting the issue that they suddenly started getting error when they try to open the SharePoint sites

Error: You may be trying to access this site from a secured browser on the server. Please enable scripts and reload this page.

Troubleshooting:

We did check the basic settings in IE of the users such as

Clearing the IE cookies, History and temporary files.

Resetting IE to advance settings and resetting the settings.

However, none of the above was seems to be working.

Resolution:

Searched on IE and found the MS KB which was supporting the same behavior: http://support.microsoft.com/kb/2752584.

To resolve this problem, enable the JavaScript feature in Internet Explorer. To do this, follow these steps:

Open Internet Explorer, go to the SharePoint Server 2013 site, press Alt to reveal the Menu bar, click Tools, and then click Internet Options.

On the Security tab, click Custom level.

Scroll down to the Active scripting section, and then select Enable.

We tried this method for few users and it worked.

Now the biggest challenge we have where some users were not having admin rights. We went to further investigate this and found that there were some updated ran on the user PC which basically disabled the execution of scripting on the IE of the user.

I am not sure of the team if they have done all the prior checks before rolling out the changes which affected the GPO settings of user machine and made the said change.

We had asked the team to enable the settings again to reduce the call volume.

Applies to: SharePoint 2010, SharePoint 2013.

  

SharePoint 2010: Users picture from Mysite are not reflecting in All People group.

Issue: We have some users reporting that their picture is displaying on the mysite but not displaying on SharePoint groups when added.

Error: There was no error as such, however in SharePoint group user picture is not showing as it was showing in the Mysite. 

Troubleshooting:

Have checked the user Pictures and they seem to be fine on users’ mysites

Added my id in the group and my picture does display in 5 min.

There is no issue with the file type and the image size on the mysite.

It’s just not working for those few users.

Changed my picture on the mysite and re-added the id in the group to check if Profile sync timer job has any issue but it did worked fine.

There were no issues with the Profile synchronization and Quick synchronization timer job definitions.

Resolution:

Searched on internet and found a blog http://www.21apps.com/sharepoint/user-profiles-why-do-my-changes-not-show-in-other-sites, which gave me clue for further investigation.

Why do some Team Sites not update with my details

The main reason for confusion around the updating (sync’ing) of My Profile details into team sites is that it is now based on if the user is Active. As part of the upgrade to V3 Microsoft introduced the idea of users being active in a site rather than just having access.

When you first visit a site a record is recorded in the UserInfo table of the sites Content Database. The field tp_IsActive is defaulted to false, which means you have visited but have not interacted with the site.

The Sync process uses this value to determine if the user info should be replicated from the My Profile details as edited above. 

Following on from the example above you should be able to refresh your team site that you had only visited and see the user name is still the same, it was not updated when the My Site was updated.

How to check if user active in SQL Database:

Go to Start -> Programs -> Microsoft SQL Server 2005/2008/2012 -> Click SQL Server Management Studio.

Connect to the SQL Server instance using the correct User ID and Password.

Note: If you are connecting SQL Server form your client then you may need to connect to SQL Server with special account with the correct permissions on the SQL Server. Run the SQL MS with Run as option in that case.

Expand Databases -> Choose to expand the DB in which your Site collection resides.

Expand Tables in that Database -> Right click on dbo.userinfo table. 

In the new Query editor, write the query: 

FROM [Database name].[dbo].[UserInfo]

with(nolock)

where tp_login like 'User ID’

After running the above query, it will display all the result of the sites on which that user is having the permissions.

You need to find the site against its ID, you can find the site ID using the PS commands.

PS > $mysite = Get-SPSite 

PS > $mysite.id

Next steps would be to check if the user is active on the site or not.

You need to find form the result of query the value of the field tp_IsActive is 0, which means users had visited the site in the past but had not interacted with the site much else this value had to be 1.

Steps suggested to user:

Asked user to update their new picture on the mysite. Deleted them from the All Peoples group from the site and Re-added them. After waiting sometime it worked for the user i.e. their pictures were displaying in the SharePoint groups.

If you had any issues executing the above steps do let me know.

Applies to:

• SharePoint Server 2010,
• SharePoint Server 2013.