none
“Internal error: An unexpected exception has occurred“ error message displayed when browsing a cube.

    Question

  • “Internal error: An unexpected exception has occurred“ error message displayed when browsing a cube.

    The error behaviour is quite irregular and does not occur for specific condition.

    Will cumulative update 9 for SQL Server 2008 R2 (SP1) installation help to fix the issue which is provided on the below link:

    (http://support.microsoft.com/kb/2152148)

    The current version of SQL Server I am using is as below:

    Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)   Jun 17 2011 00:54:03   Copyright (c) Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

    Thanks in advance for the help!

    Tuesday, September 02, 2014 7:24 AM

Answers

  • Hi Mon,

    The hotfix you said is for Microsoft SQL Server 2008. So it will not work on your scenario since you are using SQL Server 2008 R2.

    Based on the limited information, we cannot give you the exact reason that cause this issue. In order to narrow down this issue, you can apply the latest Service Pack and Cumulative Update as GregGalloway said. Besides, you can troubleshoot this issue by using the Windows Event logs and msmdsrv.log.

    • You can access Windows Event logs via "Administrative Tools" --> "Event Viewer".  SSAS error messages will appear in the application log.
    • The msmdsrv.log file for the SSAS instance that can be found in \log folder of the instance. (C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Log)

    Here is a blog about data collection for troubleshooting Analysis Services issues, please see:
    Data collection for troubleshooting Analysis Services issues

    Regards,


    Charlie Liao
    TechNet Community Support

    Wednesday, September 03, 2014 7:18 AM
    Moderator