“Unexpected Error occured” viewing calculations tab for SSAS project
June 13th, 2007 — ¥ong¥s
Free Link Exchange Software and Automate Link Swap Service
Offers free link swap service, link trade directory, reciprocal link exchange software that auto updates your link pages and complete link exchange. |
The following error text occur in the rigth pane:
Unexpected error occured: ‘Error in application.’
When trying to view the calculations tab (of any cube, including the samples that comes with SQL Server 2005) in Visual Studio (BI Development Studio) . This may cause by different versions of msmdlocal.dll and msmgdsrv.dll in %ProgramFiles%\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ and %ProgramFiles%\Common Files\System\Ole DB\
If they are not the same, then try to update the ones in the PrivateAssemblies with the ones from ole db (Please backup the dlls just case…)

September 29th, 2007 at 4:16 am
Thats Great… It worked with me very well
Thanks alot
October 25th, 2007 at 9:50 pm
Woo hoo! thanks!
January 11th, 2008 at 2:34 am
Wow - how obscure but a fantastic fix - thanks.
March 7th, 2008 at 6:57 am
Excellent tip.. it really helped.. thank you
March 19th, 2008 at 5:34 pm
This works well with me, thanks!
March 30th, 2008 at 12:19 am
Wow, thanks for this. Solved the problem immediately. This is certainly in the guts.
April 16th, 2008 at 4:17 am
I’ve tried MS fixes that were supposed to fix the issue, but no luck. You fix is simple and the best part it works. Thanks!
April 21st, 2008 at 10:01 pm
uhoooooo Thanks!
April 22nd, 2008 at 1:47 am
Excellent! Continues to help…
June 3rd, 2008 at 3:26 pm
Спасибо!! Это реально помогло!))
July 9th, 2008 at 4:09 am
Thanks for the tip , It helps me a lot …….
July 30th, 2008 at 7:50 pm
Fantastic! Many thanks!
August 11th, 2008 at 1:56 am
Perfect! This absolutely addresses the concern.
Thanks !!!
August 17th, 2008 at 12:43 pm
[...] Read the rest of this entry (moved to http://www.bronios.com) » Posted in .Net, SQL, SSAS. [...]
August 29th, 2008 at 12:24 am
I have tried reinstalling VS and SQL Server but the error still occurred. But this solution works like a charm. Thank you very much.
Regards,
Vincent Rainardi
September 24th, 2008 at 12:46 am
Marvellous!!!
You are the star.
BTW it happened after installing Office 2007 which changed mentioned DLLs only in OleDb folder.
October 30th, 2008 at 5:34 am
Wow! What an obscure fix. Worked like a charm.
W00t W00t
March 3rd, 2009 at 1:48 am
Thats work with me too.
Thanks
April 23rd, 2009 at 1:05 pm
It worked just copy the ddl from ole db to the other folder