SSAS/MDX FAQ Management FAQ When accessing calculation tab in BIDS I am getting error Unexpected error occurred
When accessing calculation tab in BIDS I am getting error Unexpected error occurred
User Rating: / 20
PoorBest 
Written by Vidas Matelis   
Wednesday, 05 December 2007 19:34

Q: When accessing calculation tab in Business Intelligence Development Studio (BIDS) I am getting error "Unexpected error occurred:Error in application".

A: Most likely this error is caused by mismatched SSAS dlls: msmdlocal.dll and msmgdsrv.dll. To fix this move copy this 2 dlls from folder:

c:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\

To folder:

c:\Program Files\Common Files\System\Ole DB\

Note: Before replacing any dll make sure you backup them to safe location.

Additional info here.

 
Comments (11)
11 Tuesday, 20 July 2010 09:46
Jason Orphanidis
Thanks for the tip.

Worked like a charm!

J
10 Friday, 02 July 2010 10:57
Juvvi Pramod
This worked for me.............
9 Wednesday, 12 May 2010 01:16
VidasMatelis
Scott,

Good point - I updated article using word "copy".
8 Tuesday, 11 May 2010 15:27
Scott L Holmes
In my case, it was not "move" but "copy"
7 Monday, 12 April 2010 17:49
Dean
Spot on. Thank you.
6 Wednesday, 31 March 2010 12:51
Dan7
Brilliant, that has been bugging me for ages.
5 Thursday, 25 March 2010 12:01
maruthiprasad
thanks i helped me a lot
4 Thursday, 11 March 2010 12:54
Nate
Thank you so much. You save my life!
3 Saturday, 05 December 2009 23:12
Esther
Error:unexpected error ocurred error in the application
in tab Calculation in analysis services

if you have visual studio 2005 and 2008 installed in your pc. you must copy the dlls:
msmdlocal.dll and msmgdsrv.dll

from %ProgramFiles%\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\
or
from %ProgramFiles%\Microsoft Visual Studio 2005\Common7\IDE\PrivateAssemblies\


to %ProgramFiles%\Common Files\System\Ole DB\
2 Wednesday, 26 August 2009 17:23
Debbie
Thanks so much for this post! I ran into this same trouble yesterday when I had Office upgraded. This seemed like a much simpler solution than figuring out how to reinstall BIDS, so I tried it. Voila!
1 Saturday, 10 January 2009 18:25
Rajeev
Thank you very much,
this is really helpful. I've been looking for solution since 2 months

Quick Poll - Please vote

What is the most important feature for you in the BIDS Helper utility?