Browse by Tags

My friend Carl posted this as a comment to one of the longer threads on Analysis Services and Project Server with the ActiveX Component Can't Create Object. error – but thought it worthy of top billing and a fresh post, as I know others have struggled with this one. Your mileage may vary and I...

I posted a while back about an issue where the Application Server had an alias for the SQL Server, but when the Analysis Services cube build was requested the alias was passed to the Analysis Services server and it didn’t know the SQL Server by this alias (even if it was in fact the same server as SQL...

This came out of a recent Project Server support case where a customer was trying to show the capacity of resources by department in a Data Analysis view, but found that the filter for the resources department (a resource level field) wasn’t working as expected.  If capacity wasn’t shown then the...

Mike Plumley from our UA team has done a great job in producing some walkthrough screencasts of a Project Server 2007 farm installation and also configuration of OLAP.  These follow TechNet articles but show you all the steps involved.  They are available for download as wmv files.  Installing...

This was a recent support issue with great work from Kate and Shazeb in getting to the resolution. Getting either of them to take credit was a harder job – so they get to share. The scenario is – you create a project plan, publish and create a workspace, then go to that workspace and add some issues...

This podcast is a talkthrough of the process of building a cube. I forgot to mention firewalls which can also block access to SQL/Analysis Services - so see the TechNet artilces for details. For other blog postings on this topic go to http://blogs.msdn.com/brismith/archive/tags/Analysis+Services/default...

That may seem like a strange title, but for Project Server 2007 users of the Analysis Services features this is good news indeed! Along with the release of SP3 (see Christophe’s blog for more details) is the release of the latest Feature pack for SQL Server 2005 . This includes the update to Management...

Thanks go to more of my colleagues over in EMEA for this posting - Dragos Diamandescu from our Project support team in Romania and Orsolya Gal assisting from SQL team in Germany. (***Update*** - I should also have thanked Marc Biarnes for validating the workaround and bringing it to my attention for...

****Update**** – The December 2008 release of the Feature pack for SQL Server 2005 at http://www.microsoft.com/downloads/details.aspx?FamilyID=536FD7D5-013F-49BC-9FC7-77DEDE4BB075&displaylang=en means that loading the Management Objects Collection from this release will avoid the workaround described...

****Update**** – The December 2008 release of the Feature pack for SQL Server 2005 at http://www.microsoft.com/downloads/details.aspx?FamilyID=536FD7D5-013F-49BC-9FC7-77DEDE4BB075&displaylang=en means that loading the Management Objects Collection from this release will resolve the problems outlined...

UPDATE: Be sure to see the more recent post - http://blogs.msdn.com/brismith/archive/2008/03/24/slow-olap-cube-builds-and-large-tempdb-revisited.aspx Some of this has been in previous postings or comments on postings - but thought it was time for a round-up. As a quick intro this blog will look at...

Just when I thought I'd seen nearly all of the error messages possible when building a cube along comes another one. And the longest yet! I won't bore you all with the full error message but the key piece is:- Error="Analysis Services session failed with the following error: Failed to process the...

A couple more cube build error messages I have seen recently. The first is related to a time out with Analysis Services 2005 and the clue is that failure will be just over an hour into the build (assuming the timeout is still the default 3600 seconds). The error is:- Failed to build the OLAP cubes...

The original posting is still repeated below to help with other's troubleshooting. I uninstalled the client tools to double check if the original instructions were OK. It turned out that I didn't have the SQL Server 2005 Management Objects installed - even though when I tried loading it again it told...

I am reproducing some common errors, both from the USL logs and the Application Event logs to assist with troubleshooting cube building issues. These are in a sort of order that follows my previous article - so first I will give a description of the problem and the errors you will see. Note that the...

Following on from my permissions piece with Project Server I will extend this logic to the service accounts and permissions to get a successful cube build. I'll start with an explanation of what goes on when building cubes which should help any troubleshooting you do. When you click on Build Cube...