Could not load file or assembly 'Microsoft.DataWarehouse, version 9.0.242.0, Culture=neutral,pu

Could not load file or assembly 'Microsoft.DataWarehouse, version 9.0.242.0, Culture=neutral,publicKeyToken=89845dcd8080cc91' - the system cannot find the file specified.

I get this message when I try to do a forcast from the Data Mining - Forecast menu.

Forecast from Table Tools, Analyse, Forecast works perfect.

Running Vista and using the DMAddins_SampleData workbook.

Any ideas ?

Trond

This previous thread apparently covered the same problem. Does the answer work for you?

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1105206&SiteID=1

|||

Sorry, but this didn't help to much.

Seems like I've got an issue with the installer !

C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin>gacutil /u Microsoft.Ana
lysisServices.Controls
Microsoft (R) .NET Global Assembly Cache Utility. Version 2.0.50727.42
Copyright (c) Microsoft Corporation. All rights reserved.

Assembly: Microsoft.AnalysisServices.Controls, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91, processorArchitecture=MSIL
Unable to uninstall: assembly is required by one or more applications
Pending references:
SCHEME: <WINDOWS_INSTALLER> ID: <MSI> DESCRIPTION : <Windows Installer>
Number of assemblies uninstalled = 0
Number of failures = 0

|||

Should have read the complete posting, but the problem remains still.

I've installed every single CTP and then some on my machine. Uninstall/install with gacutil /u in between does not help either.

Any other way to remove it from the gac ?

Trond

|||

It seems that you installed a previous CTP version of SQL Server Service Pack 2, most likely November 2006, and then upgraded only the DM Add-ins. If this is correct, you will need to

- uninstall the DM Add-ins

- install the SQL Server SP 2 (http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx)

- install the version of add-ins coming with SP2 (http://www.microsoft.com/downloads/details.aspx?FamilyId=7c76e8df-8674-4c3b-a99b-55b17f3c4c51&DisplayLang=en)

|||

I got a similar issue solved following these steps:

- Close excel

- Open a command prompt

- Go to the Add-ins installation folder (typically, C:\Program Files\Microsoft SQL Server 2005 DM Add-Ins)

- Run “gacutil -if Microsoft.DataWarehouse.DLL”

- IF gacutil.exe is not in the path You should find it somewhere in the Program Files folder (either somewhere under C:\Program Files\Microsoft.Net\SDK\v2.0\Bin or C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin\gacutil.exe)

But may be a solution particular for my machine (W2003 R2 SP2)

Jorge|||

I was having the same problem. 'gacing' the Microsoft.DataWarehouse.DLL fixed the problem.

Thanks

|||this worked for me too!