When accessing calculation tab in BIDS I am getting error Unexpected error occurred
User Rating: / 26
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 (18)
18 Friday, 28 December 2012 21:14
gogosox2
thanks so much workd well ...fyi .. i had to use the program files X86 folder to get the dlls that i wanted to copy
17 Friday, 23 November 2012 20:57
daniloquio
Thank you so much!!
16 Wednesday, 03 August 2011 10:54
Rodrigo Santos
Obrigado pessoal,

funcionou na alta aqui.
15 Wednesday, 06 April 2011 05:59
Manjeet
Thanks a ton....
14 Monday, 27 December 2010 17:29
Cesaltina
Thank you very much. It solves my problem.
13 Wednesday, 22 December 2010 18:04
Jared
Worked brilliantly - thanks so much.
12 Tuesday, 26 October 2010 01:38
Mex
1.Hey man..thanks a lot for this…i have a similliar problem with this but am using Visual Studio 08 and Sql server 08, so it seems like the solution you posted here does not work in my case. Can u help me with a solution to prevent my program from crushing and automatically closing when i click on calculation tab of the cube toolbar in analysis service..
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

 

Report Portal