Skip to main content

ProcessOlap - Catastrophic Failure

Problem​

Sometimes, executing a command related to the OLAP database will throw a catastrophic failure exception.

Catastrophic Failure: Type Initializer Exception
There were errors during execution:
 The type initializer for 'Microsoft.AnaysisServices,NamespaceMgr; threw an exception.
    Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED))

Resolution​

Use any of the following suggestions to troubleshoot the issue.

Check The User Running the Command Line​

Follow these instructions to check if the user running the command line is the service account:

  1. Open the command prompt and go to the install directory, which is by default in C:\Program Files\OpeniT\Analysis Server\.

  2. Run the Install subcommand by using the syntax:

    Command Syntax
    C:\Program Files\OpeniT\Analysis Server\>OpeniT.Server.Etl.Console.exe Install

    Information about the service account will be displayed:

    Example
    C:\Program Files\OpeniT\Analysis Server>OpeniT.Server.Etl.Console.exe install

    Open iT Analysis Server, <version>. Copyright 2008 Open iT, Inc. All rights reserved. http://www.openit.com

    Sql Database: OpeniT @ DESKTOP123WIN
    Olap Database: OpeniT @ DESKTOP123WIN

        Service account: SVG\jdoe
            SQL server: DESKTOP123WIN
            SQL database: OpeniT
            OLAP server: DESKTOP123WIN
            OLAP database: OpeniT

  3. Take note of the service account and Exit the Install command.

  4. Run the ProcessOlap subcommand by using the syntax:

    Command Syntax
    C:\Program Files\OpeniT\Analysis Server\>OpeniT.Server.Etl.Console.exe ProcessOlap`

  5. Verify that the Running as User is the same as the service account.

    Example
    C:\Program Files\OpeniT\Analysis Server>OpeniT.Server.Etl.Console.exe processolap
    Open iT Analysis Server, 9.13.1. Copyright 2008 Open iT, Inc. All rights reserved. http://www.openit.com

    Sql Database: OpeniT @ DESKTOP123WIN
    Olap Database: OpeniT @ DESKTOP123WIN

    2021-02-22 22:43:09,979 +08:00 INFO Config - License file is valid. "core" valid until 2022-12-15 (660 days), "server_license" valid until 2022-12-15 (660 days), "server_olapreports" valid until 2021-12-15 (295 days)
    2021-02-22 22:43:10,092 +08:00 INFO SsasPartitionManagerJob - Open iT Analysis Server Version: 9.13.1 (e712f84c)
    2021-02-22 22:43:10,096 +08:00 INFO SsasPartitionManagerJob - Job started. Running as SVG\jdoe

  6. If not the same, make sure to open or run the command line as the service account.