Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Project Server ... » Analysis Services   (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...
Posted Thursday, February 28, 2008 7:52 PM by BriSmith | 3 Comments

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...
Posted Monday, July 16, 2007 10:14 PM by BriSmith | 9 Comments

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...
Posted Tuesday, May 29, 2007 9:33 PM by BriSmith | 2 Comments

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...
Posted Friday, March 09, 2007 11:35 PM by BriSmith | 9 Comments

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...
Posted Wednesday, February 14, 2007 9:33 PM by BriSmith | 63 Comments

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...
Posted Tuesday, February 13, 2007 10:02 PM by BriSmith | 46 Comments
 
Page view tracker