Thursday, May 26, 2011

SSAS: Unexpected error occured: 'Error in application.'

What happen?
I'm new to this SQL Server Analysis Services cube processing and have been working on this project for a month plus.
Gotten into this error when trying to browse the Cube Calculation tab.

Unexpected error occured: 'Error in application.'

Software: Visual Studio 2005
Operating System: Windows 7

What's the problem?
This might be caused by version mismatch between some binaries of msmdlocal.dll and msmgdsrv.dll.

The Solution?
Manage to get help from Internet Search engine and route to this page:
http://social.msdn.microsoft.com/forums/en-US/sqlanalysisservices/thread/773988a0-1767-47ed-9405-77430e7db37f/ Making sure that the ones installed into %ProgramFiles%\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ are the same as those in %ProgramFiles%\Common Files\System\Ole DB\
(if they are not then try updating the ones in the PrivateAssemblies with the ones from ole db; you might want to save the original ones as to be able to get back to original state just in case...)