Migrating from Analysis Services 2000

• Isaac Spalter

  SSC Enthusiast

  Points: 101

  More actions

  January 21, 2006 at 11:59 pm

  #166720

  When migrating from Analysis Services 2000, I get the following error when validating the source databases:

  Unable to cast COM object of type 'System.__ComObject' to interface type 'Interop.Dso.IPartition90Ex'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{F82195C2-53A0-41B5-B7D8-7D087BAE32CF}' failed

     due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).

   

  Please help.

  Thanks

   

• January 24, 2006 at 8:00 am

  This was removed by the editor as SPAM

• Graham Minchin

  Grasshopper

  Points: 16

  More actions

  January 26, 2006 at 7:27 am

  #617156

  Hi

  I had exactly the same problem.  I'm using SS 2005 Standard Edition.

  I did some investigation and checked the registry of the last RTC which indicates that this class is in:

  C:\Program Files\Common Files\Microsoft\DSO\msmddo80.dll

  I re-registered the DLL and got a different class GUID missing when I re-ran the wizard, so I re-registered all the DLLs in the DSO folder.  This didn't fix the problem.

   

  Then I noticed that my DSO dll's are all version 8.0.2039... But the RTC dlls are 8.05.1054 (which I think are later).  So I have no idea why my DLL's are so old having just having installed SS 2005.

  So I copied the DSO folder from the RTC virtual PC and made a subfolder to C:\Program Files\Common Files\Microsoft\DSO\Test 

  (By the way this is a virtual PC - test environment...)

  I put the DLL's in here and registered all of them.  restarted AS 2000, and The Migration Wizard now works.

  I'm not sure of the proper way to upgrade these DLL's.  I would have thought the SS 2005 would have done it...

  Any ideas?

  Hope this helps

  Graham

  http://www.2020insight.com.au Business Intelligence for Perth Western Australia.