Welcome to MSDN Blogs Sign in | Join | Help

Brian Smith's Project Support WebLog

What's new and upcoming in the world of Microsoft Office Project Support (PSS).

Browse by Tags

All Tags » Analysis Servic... » Project Server 2007   (RSS)
Sorry, but there are no more tags available to filter with.
OLAP and Data Analysis - timeouts, plan guides and tempdb
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. Read More...
Yet another OLAP error message - the longest yet!
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 Read More...
A couple more cube build error messages you might come across.
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). Read More...
RESOLVED! ActiveX Component Can't Create Object: Cube build failure against SQL Server 2005 Analysis Services
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 - Read More...
Common Error Messages when Building Cubes with Project Server 2007
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 Read More...
Microsoft Office Project Server 2007 and SQL Server 2005 Analysis Services - Building Cubes
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 Read More...
Page view tracker