#
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:
Open the command prompt and go to the install directory, which is by default in
C:\Program Files\OpeniT\Analysis Server\
.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:
ExampleC:\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
Take note of the service account and Exit the Install command.
Run the ProcessOlap subcommand by using the syntax:
C:\Program Files\OpeniT\Analysis Server\>OpeniT.Server.Etl.Console.exe ProcessOlap
Verify that the Running as User is the same as the service account.
ExampleC:\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
If not the same, make sure to open or run the command line as the service account.