error when migrating cubes

Question

error when migrating cubes

winston Smith

SSCoach

Points: 19500
More actions
November 8, 2006 at 10:12 am

#115068

i have analysis server 2000 on my server and have just installed a new instance of analysis server 2005. i tried the migration wizard but get this error:
Unable to cast COM object of type 'System.__ComObject' to interface type 'Interop.Dso.IDbGroup90Ex'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{CE55E9E9-9597-4214-B21F-30C7683467B1}' failed due
to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).

what does that mean? i have no idea how to debug that and google has yeilded no results.
November 13, 2006 at 8:00 am

This was removed by the editor as SPAM

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Donovan Hsieh Newbie Points: 3 More actions · Answer 1

I get the same error while migrating the Foodmart 2000 sample 2005 using the MigrationWizard utility provided in SSAS 2005. Guess Microsoft products are still full of bugs.

Stefan K SSCommitted Points: 1786 More actions · Answer 2

Hi,

my advice - forget the migration wizard and build up your cubes from scratch. I did a big migration of a datawarehouse (20 Cubes, 30 dimensions) this year and we tried the migration wizard just one time. The result was not needful.

For example if you used hierarchies in your SSAS 2000 Cubes they will not be migrated to one dimension with x hierarchies but to x dimensions. This is not best practice and not recommended by microsoft. Any virtual cubes will be migrated to single cubes with x linked measure groups.

You will be faster when designing all your cubes and dimensions following microsofts best practice.

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/olapdbpssas2005.mspx

Best regards,

Stefan

Kindest Regards,

SK

chris-524137 Newbie Points: 5 More actions · Answer 3

Hi Guys,

Go to add?remove Programs and find "SQL Server 2005 Backward Compability" and Click the change option on the install screen that throws up please select Repair.

THIS WILL RESOLVE YOUR ERROR

Christopher Richard

President & Founder

CRUniversity

Chandra Modem Newbie Points: 3 More actions · Answer 4

Hi,

I still get the same error despite of running the "repair" on Microsoft SQL Server 2005 Backward compatibility Setup. Any thoughts?

Thanks

Chandra M.

Vin Larkin Newbie Points: 4 More actions · Answer 5

Vin Larkin

Newbie

Points: 4

August 26, 2008 at 5:40 am

#863026

Thanks for that - worked for me!

Dscheypie SSCommitted Points: 1545 More actions · Answer 6

Works for me also, thx a lot!

Spent a lot of time on this one now...

:-/

________________________________________________________
If you set out to do something, something else must be done first.