An Informal Compendium of SSAS Errors, Part 3: Unresolved Errors

This is the second in a series of posts on some SQL Server Analysis Services (SSAS) errors for which there is apparently little, if any, documentation anywhere on the planet. For an introduction to the compendium, see https://multidimensionalmayhem.wordpress.com/2011/09/21/an-informal-compendium-of-ssas-errors-part-1-introduction-and-data-mining-errors/. Check back Saturday, Oct. 8 for the next installment, An Informal Compendium of SSAS Errors, Part 4: SSAS Object Design.

This post contains information in a table format that may not render clearly if viewed at SQL Server Central because of the wider column style used at that site. If you have problems viewing the table, please check out the original post at https://multidimensionalmayhem.wordpress.com.

Error Cause/Solution
1. Errors in the Metadata Manager – You receive the following message, possibly after adding a data mining dimension: “Errors in the metadata manager. The server failed to create the processing schedule due to an object dependency loop.” I received this error after adding a data mining dimension in the cube relationships. I have not been able to find any reference to this error message on any search engine (let alone Microsoft’s own documentation).
2. GetAttributeScores – When using the Mining Model Viewer or Mining Accuracy Chart you receive the following message, particularly in association with the Neural Network or Logistic Regression algorithms: “Execution of the managed stored procedure GetAttributeScores failed with the following error: Exception has been thrown by the target of an invocation.” There is a hotfix available here http://support.microsoft.com/kb/913854 for SSAS 2005 and here http://support.microsoft.com/kb/960864 for SSAS 2008. Unfortunately, I’ve seen the error frequently in SSAS 2008 R2 but haven’t found a hotfix for it yet. The 2008 hotfix page states this occurs mainly when “The mining model uses nested tables, or it contains a prediction that is based on negative values.” Only about 20 webpages indexed in Google mention the error and of those, all of them mention in it in association with the Neural Network model, although it can also occur with Logistic Regression. Except for the two hotfix pages, all of these discussions end quickly without answers being posted. The cause of this error continues to be a mystery, so if the two hotfixes don’t work for you, or you’re running R2, your guess is as good as anyone else’s.
3. GetAfterObjects Error in File mdschedobjects – “Internal error: An unexpected error occurred (file ‘mdschedobjects.cpp’, line 1638, function ‘MDSchedDimension::GetAfterObjects’).” I can’t even find a reference to any of these files or functions anywhere on any search engine, let alone Microsoft’s own documentation.
4. End Scope/Opening Scope Mismatch – When you try to use a Scope including a calculated measure, you receive this erro: “The end scope statement does not match the opening scope statement.” This is apparently a mystery. For an in-depth discussion, see this page at Chris’ BI Blog: http://cwebbbi.wordpress.com/2007/08/30/scope-and-calculated-members/.
5. Ragged Hierarchy Is Not Supported In This Version – “An error occurred when trying to find the ancestors of the filtered member ‘[MyDate].[Hierarchy].[Date].&[1929-08-02T00:00:00].&[1929]’. This may have been caused by the use of a ragged hierarchy which is not supported in this version or by setting filtering on the wrong level.” I have not been able to duplicate this problem since I first received it several months ago, nor have I had any luck searching for webpages for a discussion of this issue. A couple of foreign language hits come up for these terms, but there is no discussion of the issue on the referenced pages. A hierarchy is ragged when its members don’t consistently descend to the same level. For example, as Books Online (BOL) puts it so concisely, in a geographic dimension both France and the Vatican would be considered nations, but France has provinces which in turn have cities, while the Vatican is a city with no provinces. This issue is a bit of a mystery to me, since SSAS does support ragged hierarchies through the use of the HideMemeberIf property.
Advertisements

About Stevan Bolton

I am a VB programmer and SQL Server DBA with an interest in MDX and multidimensional applications. I have an alphabet's soup of certifications: * 3 MCTS certifications in SQL Server 2008 R2, including a recent exam in MDX and Analysis Services * an MCDBA in SQL Server 2000 * an MCSD in VB6. I've kept up with each version of VB since then but haven't taken the newer exams * I also have a Master's in American history with a concentration in foreign affairs, as well as some work towards a doctorate in Latin American history * My B.S. is in print journalism I'll be posting whatever code I can to help out the SQL Server and VB developer communities. There is always someone out there more knowledgeable, so if you're a guru, feel free to correct any information I might post. I haven't yet been paid professionally to work with some of the technologies I've been trained in and enjoy, like MDX, so the word of those who have ought to carry more weight. There's a shortage of information on some of the topics I'll be posting on, such as the arcane error messages in Analysis Services (SSAS), so users might still find some value in my posts. If you learn of any job openings for MDX, SSAS, SQL Server and VB, feel free to E-mail me.

Posted on October 2, 2011, in An Informal Compendium of SSAS Errors and tagged , , , , , , . Bookmark the permalink. 1 Comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: