tags:

views:

82

answers:

1
Q: 

Error when restoring SSAS cube: MemberKeyesUnique element at line xxx cannot appear under (...)/Hierarchy

Hi,

I'm getting this error when trying to restore an SSAS database from a backup:

The ddl2:MemberKeysUnique element at line 63, column 4862 (namespace http://schemas.microsoft.com/analysisservices/2003/engine/2) cannot appear under Load/ObjectDefinition/Dimension/Hierarchies/Hierarchy.

Google hasn't turned up any helpful solutions. (a lot of people found that installing SP2 made the error go away but this has always previously worked in our environment)

I don't really understand what the error means. Can somebody interpret or suggest a fix?

Thanks,

Phil

+1  A: 

I'm investigating this same issue. As far as I can tell it is because SSAS 2005 pre SP2 does not support the MemberKeysUnique property. This was a bug which was fixed in SP2.

My suggestion then would be to remove this property from the source, re-backup then restore; otherwise, upgrade to SP2 and try restore again.

Cheers

Jacob  2010-05-09 23:06:48
Jon Galloway states the problem/solution in his blog:http://weblogs.asp.net/jgalloway/archive/2007/06/21/sql-server-analysis-services-quot-errors-in-the-metadata-manager-quot-when-restoring-a-backup.aspx
Jacob  2010-05-09 23:11:59
Yeah I saw the same post during my research. Unfortunately the company I'm working at has blocked the site linked in that page. I don't think SP2 is the answer because this is a process that has only recently stopped working.
Phil  2010-05-10 08:13:28
It turns out that one of the AS instances in UAT had been upgraded to SP2 for some unknown reason which was screwing up the restore. It still scares me that the previous release worked in that environment but the current release doesn't.
Phil  2010-05-13 10:32:11
Thanks Phil. I'm glad you got it working ;)
Jacob  2010-05-13 20:38:31

related questions

SQL Server, convert a named instance to default instance?
Natural (human alpha-numeric) sort in Microsoft SQL 2005
In MS SQL Server 2005, is there a way to export, the complete maintenance plan of a database as a SQL Script?
Does ReadUncommitted imply NoLock
Query to list all tables that contain a specific column with SQL Server 2005.
Can I maintain state between calls to a SQL Server UDF?
What are the benefits of using partitions with the Enterprise edition of SQL 2005
Upgrading Sharepoint 3.0 to SQL 2005 Backend?
What's the simplest way to execute a query in Visual C++
Can you perform an AND search of keywords using FREETEXT() on SQL Server 2005?
Create a database from another database?
What's the fastest way to bulk insert a lot of data in SQL Server (C# client)
SQL 2005 Book For Optimization Techniques
How do I create a mapping table in SQL Server Management Studio?
Cannot Add a Sql Server Login
SQL Server 2005 - Export table programatically (run a .sql file to rebuild it)
Diagnosing Deadlocks in SQL Server 2005
SQL2005: Linking a table to multiple tables and retaining Ref Integrity?
How to create a new instance of Sql Server 2005
SQL Server 2008 vs 2005 Linq integration
How do you kill all current connections to a SQL Server 2005 database?
Conditional Visibility and Page Breaks with SQL Server 2005 Reporting Services
SQL Server 2005 and 2008 on same developer machine?
Paging SQL Server 2005 Results
SQL 2005 For XML Explicit - Need help formatting