“Unexpected Error occured” viewing calculations tab for SSAS project

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…)

Posted in .Net, MS SQL, SSAS.

19 Responses to ““Unexpected Error occured” viewing calculations tab for SSAS project”

  1. Emad El Faramawi Says:

    Thats Great… It worked with me very well
    Thanks alot

  2. Russ Says:

    Woo hoo! thanks!

  3. Paul Says:

    Wow - how obscure but a fantastic fix - thanks.

  4. Krishna Says:

    Excellent tip.. it really helped.. thank you

  5. Fred Kwakkel Says:

    This works well with me, thanks!

  6. John Says:

    Wow, thanks for this. Solved the problem immediately. This is certainly in the guts.

  7. Ruzanna Says:

    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!

  8. Marcos Says:

    uhoooooo Thanks!

  9. LL Says:

    Excellent! Continues to help…

  10. SerLight Says:

    Спасибо!! Это реально помогло!))

  11. Néstor Elias Says:

    Thanks for the tip , It helps me a lot …….

  12. Michiel Says:

    Fantastic! Many thanks!

  13. KB Says:

    Perfect! This absolutely addresses the concern.

    Thanks !!!

  14. “Unexpected Error occured” viewing calculations tab for SSAS project « yyTech Blog on .Net, SQL, SharePoint, Collaboration and tech tips. Says:

    [...] Read the rest of this entry (moved to http://www.bronios.com) » Posted in .Net, SQL, SSAS. [...]

  15. Vincent Rainardi Says:

    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

  16. Sladjan Says:

    Marvellous!!!

    You are the star.

    BTW it happened after installing Office 2007 which changed mentioned DLLs only in OleDb folder.

  17. Wolffy Says:

    Wow! What an obscure fix. Worked like a charm.
    W00t W00t

  18. pooja Says:

    Thats work with me too.

    Thanks

  19. Manisha Says:

    It worked just copy the ddl from ole db to the other folder

Leave a Reply