Wednesday, January 25, 2012

PowerPivot: Could not load type ‘Microsoft.AnalysisServices.SharePoint.Integration.ReportGalleryView’


I have got this issue when i create PowerPivot library in my New Site collection.
Site_ReportGalleryView_LoadFailure
The error occurs when you try to select a Document Library of type PowerPivot Gallery (sometimes referred to as Report Gallery). After installing Power Pivot for SharePoint, all new site collections you create have the option to create a new document library of this type and if you use the PowerPivot Site template when creating the site collection, we automatically add a library of this type (that is the main thing we do in this template). The ability to add this type of library in all new site collections is there because we defined the library in a feature which is subsequently stapled to all sites. This means it is automatically activated on all site collections. The problem is that the page which is loaded when you click on the library as its default view uses an ASP.Net control whose code behind is found in a dll which is not being found. So when does this happen. Every case I have seen so far, this occurs when the user creates a new Web Application and does not deploy our WebApp solution to the new Web Application. Because of how we reference the classes for our pages, we need to have the associated assembly in the <vdir>\bin directory. This assembly is Microsoft.AnalysisServices.SharePoint.Integration.dll. The dll is “pushed” to the web applications on every WFE in the farm via the SharePoint solution infrastructure.

Ignoring any of the questions around “how should we have done this to avoid this error” .. to fix this situation, you simply need to deploy our web app solution to the Web Application you just created. To do this, go first to the System Settings page in Central Admin
CentralAdmin_SystemSettings
Under Farm Management, select Manage farm solutions.
CentralAdmin_ManageFarmSolutions
Click on the powerpivotwebapp.wsp solution to see its properties
CentralAdmin_SolutionProperties
On the properties page, you will see the “Deployed To” list and notice that your new web application is not on this list. Select the “Deploy Solution” link at the top of this page
CentralAdmin_DeploySolution
You can now chose to deploy our solution to the new Web Application you have created (and you can chose to do it “Now”).

Happy SharePointing.

PowerPivot The referenced file is not allowed on this page.

After installing PowerPivot for SharePoint 2010 for the first time, I added a PowerPivot Gallery to one of my existing sites and I was presented with the following error message:
“The referenced file ‘/_layouts/PowerPivot/ReportGalleryView.ascx’ is not allowed on this page.”
PowerPivot Error

After doing some research. For whatever reason, Microsoft missed a step for the feature activation of the PowerPivot controls that adds the controls to the Safe Controls in the Web.Config file of your web application. You have to do this manually. For each Web.Config file on each server for each web application, you have to add the following Safe Control:

<SafeControl Src="~/_layouts/powerpivot/*" IncludeSubFolders="True" Safe="True" AllowRemoteDesigner="True" SafeAgainstScript="True" />

After adding that to your Safe Controls in each web.config, do an IISRESET and you are all set.

Wednesday, January 11, 2012

SharePoint redirect for site collections

SharePoint redirect for site collection is possible with IIS virtual site creation. This is not possible with AAM Configuration.

If you want users to use http://intranet.domain.com/ and have it forwarded to http://intranet.domain.com/sites/portal, there are several ways you can do it.

One easy way is to use IIS directly and not involve Sharepoint at all.

Create a new virtual server in IIS Manager (New Web Site) and give it a descriptive name like "Sharepoint Redirect".--> choose the default settings when running the wizard and select a local directory (any path is fine). -> after the virtual server is created, edit the properties, open the "Home Directory" tab and click "A redirection to a URL", then type your Sharepoint URL in the "Redirect to:" box.

http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=48

Happy SharePointing.

Configuring Kerberos Authentication in SharePoint 2010