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:
- Select the account ghat you want to edit.
- In the Current account menu select Account users.
- In the list, make sure that your role is set to Owner.
Enabling the Debug Procedure
In the flex.bi web application:
- Select the account ghat you want to edit.
- In the Current account menu select Edit account.
- In the Update account window, enter debug_import = ["<register_name>"] (using the appropriate register name) in the Plan parameters field.
- 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
...