PowerPivotGeek? Who is this mystery man?
Click on the icon to find out.
 |
By powerpivotgeek (dwickert@microsoft.com), on July 12th, 2010
Oh the joys of SharePoint again. I just responded to an internal posting where someone was raising the issue that “Path not found” errors were being reported when Excel Desktop tried to publish a workbook to SharePoint. Again, this isn’t PowerPivot directly, but it can be reported as a PowerPivot problem if the workbook contains PowerPivot data.
The issue is that on Windows Server machines (Window Server 2008 and Windows Server 2008 R2), the ‘Desktop Experience’ feature contains a required component for Excel (or any application posting content to SharePoint).
Normally you don’t see this because on a Windows client machine (Windows 7, Windows Vista, or Windows XP), Desktop Experience is turned on by default – but not for Server OS’s. The underlying component at issue here is WebDAV. Excel desktop need it for the publishing process because they post content to SharePoint as if SharePoint was a remote file share. Thus if you are going to run Excel desktop on a Windows Server OS and publish content to SharePoint – then you need ‘Desktop Experience’ turned on.
Enjoy!
By powerpivotgeek (dwickert@microsoft.com), on July 12th, 2010
So . . . here I am playing around with PowerPivot to get ready for a demo. As this is a group from the SharePoint dev team (actually SharePoint Online), I wanted to include some cool SharePoint functionality into the demo. Trying to be cool and ‘wow’ them, I decide to use a SharePoint list as a data source. I want to show the data mashup capabilities of PowerPivot so I have the bulk of my demo come from the Contoso sample database (the three product catalog tables) and the 4 million row Sales Fact table.
I create my SP list by extracting the 11 distinct manufacturers – and I assign them to a ‘shipper’ that I made up.
Continue reading: Using a SharePoint list as a data source
By powerpivotgeek (dwickert@microsoft.com), on July 12th, 2010
From time to time you run into something on SharePoint that is a known SharePoint ‘issue’, but you wouldn’t necessarily see PowerPivot being impacted. After all SharePoint is this huge juggernaut of a product and PowerPivot is just this one small little app in the corner. Well, here is one that I ran into today. We had a bug report that the incoming email setup for a PowerPivot Gallery was missing the ‘incoming emails’ link –> after some searching, I found this interesting posting:
http://blogs.msdn.com/b/malag/archive/2010/02/15/incoming-email-settings-link-disappears-from-document-library-settings.aspx
One of my customer had created a custom document library deriving from OOTB document library. They are able to create their document library from custom list definition properly without any issues. But when in the document library created using custom list definition, if you go to list settings page, it does not show "Incoming Email settings" link under "Communications" column. Incoming Email settings are setup properly and OOTB document library has got incoming email settings link and it is getting emails properly. Just libraries created from their custom list definition does not have Incoming Email settings link!
So what is causing the issue?
Digging into SharePoint, found that this is hard-coded and SharePoint will only show Incoming Email settings link for OOTB lists of type Announcements, Event, Document Library, Picture Library, XML Form, Discussion Board, Posts.
Now all is explained. Gallery derives from Document Library, but it is not Document Library. Remember, all things PowerPivot run through SharePoint!
Enjoy.
By powerpivotgeek (dwickert@hotmail.com), on June 30th, 2010
(Well, maybe you are – maybe you aren’t . . . How can you check directly?)
In an earlier post (http://powerpivotgeek.com/2010/03/04/installing-the-right-version-of-sharepoint/) I spoke about the way that PowerPivot determines if you are on the right version of SharePoint. Cory Retherford reported some errors and after investigating it for a few days we found the solution.
Here is some more info:
The SQL setup rule checks for the guid of installed SharePoint. We have two guids that correspond to the SharePoint Server Enterprise Edition SKU. If the guid in the registry doesn’t match one of our guids and a farm is configured and the bits for SharePoint exists then the rule is triggered.
What is the value of the following registry key?
SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\InstalledProducts\{90140000-110D-0000-1000-0000000FF1CE}
The installed guids we are looking for is either one of these:
"D5595F62-449B-4061-B0B2-0CBAD410BB51"
"88BED06D-8C6B-4E62-AB01-546D6005FE97"
If your guids do not match these then we believe that the installation is not SharePoint 2010 Enterprise Edition and you see a validation error.
It turns out that in Cory’s case, there is an interesting SharePoint bug that you might run into. There was a bad early SharePoint Server 2010 FIS distribution made available for download, see KB2143810 (http://support.microsoft.com/kb/2143810), that impacted the guids installed on the system. Cory installed the right ‘version’ of SharePoint 2010, but not all of the features were activated and the wrong guid was being reported.
At least now, if you get a “wrong version of SharePoint installed” error, you have something to check.
Hope that helps.
By powerpivotgeek (dwickert@microsoft.com), on June 17th, 2010
Recently ran into this situation: Customer installed the wrong PowerPivot bits on their machine. They were running on a 64-bit OS with Office 2010 x64, but installed PowerPivot for Excel 32-bit. Everything installed OK, but when they clicked on the PowerPivot tab in Excel; then the PowerPivot Window they received the following error:
Embedded Analysis Services Engine: Could not open embedded PowerPivot data
Click OK
Embedded Analysis Services Engine: Could not open embedded PowerPivot data
Unable to load the VertiPaq engine (HRESULT 0×0800A03EC)
Solution: Uninstalled PowerPivot for Excel and installed the x64 bit version of PowerPivot. Everything now works.
By powerpivotgeek (dwickert@hotmail.com), on June 17th, 2010
Attempting to use a modified version of the SharePoint v4.master page is a great way to style our SharePoint site. If you interested in doing this, then the first thing to do is to make sure that you go to the right place:
- Go to Site Settings -> Site Collection Features -> Make sure “SharePoint Server Publishing Infrastructure” is activated.
- Go to Site Settings -> Manage Site Features -> Make sure “SharePoint Server Publishing” is activated.
- Finally then on the Site settings page, you should get an entry for Master Page under the “Look and feel” section.
Modifying the master page works fine for the landing page, document libraries, calendar and other pages—but causes an error with the PowerPivot Gallery. The error is—“The referenced file ‘/_layouts/Gemini/ReportGalleryView.ascx’ is not allowed on this page." The problem is that the page cannot load because the control ReportGalleryView.ascx is not marked as a safe control. To mark report galllery view as a safe control the following like should be added to web.config on "SafeControls" (under C:\inetpub\wwwroot\wss\VirtualDirectories\<web app port#, e.g. 80), in the <SharePoint>/<SafeControls> section
<SafeControl Src="~/_layouts/powerpivot/*" IncludeSubFolders="True" Safe="True" AllowRemoteDesigner="True" SafeAgainstScript="True" />
Enjoy.
By powerpivotgeek (dwickert@microsoft.com), on June 14th, 2010
(With my thanks to Fernando Delgado, our excellent setup dev for working up this solution)
After uninstalling PowerPivot for SharePoint, Excel Services and other features in the PremiumSite feature will be disabled. At a certain level for “new server”, this makes sense since turning on and configuring of Excel Services et. al. was part of the “new server” installation. But for “existing farm”, this is a huge NO-NO and will cause considerable aggregation. Fortunately it is easy to fix. In order to re-enable the feature in all the sites in the Farm where it was previously enabled you just need to follow a simple set of steps. If there is a small number of sites, just re-enable them manually with the regular UI. If you would like an automated way, then the following step will scan through the SQL Server log file, pull out those sites that were disable and re-enable them (this is great if you have a large number of sites or if you don’t know which sites to enable manually).
Note: All these steps must be run as administrator
Continue reading: Uninstalling PowerPivot does what ?? Arg!!@@!!!
By powerpivotgeek (dwickert@microsoft.com), on June 14th, 2010
We’ve been hearing reports of this failure for several weeks, but we’ve not been able to get a good repro until a week ago. And it was the most “most reported bug” at TechEd — if there is such a category  — but it looks like we have a solution after many hours of hard work.
(With my thanks to Fernando Delgado, our excellent setup dev for working up this solution)
(RTM build 10.5.1600.1) As a picture is worth a thousand words, here is the error:
This failure occurs when installing PowerPivot (either “existing farm” or “new server”) after a previous SSAS installation has been done on the machine.
Continue reading: Installation failure: “Could not load file or assembly ‘Microsoft.AnalysisServices.SharePoint.Integration.dll’ . . .
By powerpivotgeek (dwickert@microsoft.com), on June 14th, 2010
While this is technically a pure SharePoint posting, we have found it useful in our labs. We have password resets all of the time and this cheat sheet was developed to make it as painless as possible. I hope you find it as useful as we do.
Step 1: Start Services.msc
- For each service using the machine account, update the password and start the service
Step 2: Start IIS Manager. Under Application Pools, select each of the app pools that use the account that you are changing:
- Click Advanced Settings
- Click Identity
- Set the username and password
- iisreset
Continue reading: Changing service accounts and handling password resets
By powerpivotgeek (dwickert@microsoft.com), on June 14th, 2010
If you are running PowerPivot for SharePoint on more than one backend app server, then it is a common issue that folks are seeing only one server being used. It turns out that this might be ‘by-design’ so let’s talk about it for a bit. Let’s look at the two allocation methods we support:
- Round-robin (the default) – This algorithm selects first one app server; then the next; then the next; until it loops back around. Since the actual marker for what is “the next” is kept in the proxy for the PowerPivot service application, the net-effect of this in practice is that the selection looks different from what you would expect. The behavior is a lot closer to random rather than sequential. Being random, and with a low number of servers to pick from (for example, 2), you should naturally expect that one app server might seem to be biased. Add more servers and you will see less bias.
- Health-based – This is the one that most large shops will likely choose. The idea behind health-based is that the system will decide which is the ‘best’ app server for a machine. So when the allocation appears bias, it seems like health-based isn’t working. In reality, health-based may be doing exactly what was intended. If all machines have memory available (i.e. none of them are under memory pressure), then health-based uses CPU to break any ties, i.e. which ever CPU has the most CPU free wins. Let’s take an example:Suppose you have two machines “A” and “B”. Both are running PowerPivot. They both have 32GB on them with four quad-core processors. Rather than being dedicated to PowerPivot, “A” also doubles as the backend app server for Excel Services. Likewise, “B” doubles as the backend app server for PerformancePoint Services. So long as Excel Services and PerformancePoint consume similar CPU time, then databases will be loaded back and forth between “A” and “B” as one is more lightly loaded than the other. However, if PerformancePoint is lightly used and “B” is consistently less loaded (CPU-wise), then you will see PowerPivot databases being allocated to “B” until it becomes under memory pressure, and then allocation will shift to “A”.
All-in-all, health-based is still the best algorithm for large shops. Remember that the PowerPivot engine is an in-memory system. Our first goal is to get databases allocated wherever memory is available – balancing across the farm is not a priority.
Enjoy.
|
|
Recent Comments