Service of Jedox OLAP Server

image_pdfimage_print

On Windows systems, the service JedoxSuiteMolapService represents the Jedox OLAP Server.

Startup behavior of OLAP Server

As of Jedox Version 6.0, the startup behavior of OLAP Server now implements delay loading: the OLAP Server will first load the system database, config database, and all databases of type “user info” (Internal Meta Data) at startup. After these databases are loaded, the OLAP Server will listen to incoming requests, and then proceeds to load all normal databases. These databases will be available to users after load of each individual database has finished.

Important note: on Windows, the OLAP Service is reported as running in this moment; however, during this time, users should not access the database. We recommend the following workarounds to prevent users from logging during delay loading:

  1. Display a custom logon page or MOTD message that performs a status check on the database(s) and relays that information to the users before they attempt to logon. The state of the server regarding delay load is accessible via /server/info or /server/palo_server_info API method.
  2. Stop Apache until delay loading is finished.

After completion of installation you will find this service under Start – Control Panel – Administrative Tools – Services. By default, it will be automatically started when the machine is started.

In the Windows Task Manager, you can start and stop JedoxSuiteMolapService (Jedox OLAP Server).

Note: for Jedox Web, the service JedoxSuiteTomcatService depends on JedoxSuiteMolapService.

You can also start and stop the JedoxSuiteMolapService directly via the Windows Console by using the Windows Net.exe utility. The commands to be used are:

net start JedoxSuiteMolapService
net stop JedoxSuiteMolapService

Recommendation for computer shutdown:
When a PC/server is shut down or rebooted, Windows only allows a limited amount of time for services to stop. Since Jedox OLAP does file system commit on service stop, and this commit may take longer for the large amount of (changed) data, the time granted by Windows may not be enough. For this reason, it is highly recommended to manually stop the OLAP server service before shutting down or rebooting the machine, especially if larger amounts of data were changed (e.g. large Jedox Integrator [ETL] loads).

image_pdfimage_print
Was this post helpful?
NoYes (No Ratings Yet)
Loading...