Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The following are basic instructions, information and some tips for flex.bi Enterprise server administrators.

...

Note

The backup files should be stored separately from the original database, ideally in a geographically remonte location.


There are many ways of backing up your databases - might have special tools or ability to make disk snapshots. The easiest, but still very reliable way is to create database dumps. For example, on a MySQL server you could do this:

  • Run the following command to connect to mysql:

    Code Block
    mysql -u <username> -p <password>


  • Run the following code to backup all flex.bi databases into an .sql file:

    Code Block
    mysqldump -u <username> -p <password> --all-databases >> <backup_file_name.sql>


    Note

    In the code examples above you have to input the username and password of a MySQL user and a backup_file_name of your choice


Backing up flex.bi installation files

To reduce the possible service downtimes, it is also recommended to back up flex.bi installation files located in the flexbi_private folder, according to your company's internal backup policy.

Note

The backup files should be stored separately from the original database, ideally in a geographically separate location.

...

Checking Log Files for Errors

There are 2 log files available in the flex.bi system, which can be found in the Troubleshooting page of the flex.bi web interface and flexbiand flexbi_private/log folder on the server.

  • eazybi-queues.log
    In this log file you can find information about data imports, including each cube import status, time, imported record count and import errors.

    Note

    This log file shows if the file upload function is started (shows up after each server restart) and if any files are being uploaded.


  • eazybi-web.log
    In this log file you can find information about processes in the web application of the live flex.bi service, including information about errors.

    Note

    In this log file you can check for potential threats, such as scanning attacks, DDOS attacks and similar malicious attempts.


...

  • Import issues e-mails that are sent from the account.
  • The following The following plan parameter which enables data import debug messages registration in messages registration in the log file eazybifile eazybi-queues.log mentioned before:
Code Block
debug_import = ["<register_name>"]

...

Assigning Account Owner Role

In the flex.bi web application:

  1. Select the account ghat you want to edit.
  2. In the Current account menu select Account users.
  3. In the list, make sure that your role is set to Owner.

Enabling the Debug Procedure

In the flex.bi web application:

  1. Select the account ghat you want to edit.
  2. In the Current account menu select Edit account.
  3. In the Update account window, enter debug_import = ["<register_name>"] (using the appropriate register name) in the Plan parameters field.
  4. Click on the Update button.
Note

Data import debug messages are shown in the log file eazybi-queues.log mentioned before, which is available in the Troubleshooting page of the flex.bi web interface and flexbi_private/log folder on the server.

Monitoring Available Space on Hard-drives

...