# ProcessOlap - Catastrophic failure

# Problem

Sometimes, executing a command related to OLAP database will throw a catastrophic failure 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 the following list of suggestions to troubleshoot the issue:

# Check 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:

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

    Information about the service account should 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 @ MNL164WIN
    Olap Database: OpeniT @ MNL164WIN
    
        Service account: SVG\jplanas
            SQL server: MNL164WIN
            SQL database: OpeniT
            OLAP server: MNL164WIN
            OLAP database: OpeniT
    
  3. Take note of the service account and Exit the Install command.

  4. Run the ProcessOlap subcommand by using the 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 @ MNL023WIN
    Olap Database: OpeniT @ MNL023WIN
    
    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\jplanas
  6. If not the same, make sure to open or run the command line as the service account.

We value your feedback!

Please take a few minutes to complete our survey and share your thoughts on your recent experience with our documentation.

Take survey

Close