In Business Intelligence Development Studio for SQL Server 2005 analysis services, when we click on ‘Calculation’ Tab to define some calculated measures & all, we can get the following error:
‘Unexpected error occurred: ‘Error in application.’
Also having this error visual studio IDE will crash & will be closed automatically.
This issue may not get resolved by applying SP2 or other hot fixes. And you may also not find this error logged into the event viewer.
This problem occurs due to the compatibility issue i.e. version difference between the binaries/ DLLs.
These DLLs are 1. Msmdlocal.dll & 2. Msmgdsrv.dll
Version of the assemblies ‘msmdlocal.dll’ & ’Msmgdsrv.dll’ must be the same of the ones installed into “%ProgramFiles%\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\” and the ones installed into “%ProgramFiles%\Common Files\System\Ole DB” location.
If it is not same for any or both of these DLLs, then replace the ones in ‘PrivateAssemblies’ with the ones from ‘ole db’.
Happy SSAS Cube Designing..!