Diagnostics and troubleshooting

The article describes troubleshooting issues that may occur during the installation of the BI module. The error cause is displayed in the interface and saved to the /usr/local/mgr5/var/bi_installer.log file on the server with the module.

Errors occurred during installation

Connect to the server with the BI module via SSH. For more information about connecting via SSH, see the article Workstation setup.

View the installation log file:

cat /usr/local/mgr5/var/bi_installer.log

Resolve the issue and repeat the module installation until you receive a success notification.

Caused by: response error: Captcha check failed, try again

Disable ReCAPTCHA.

Caused by: response error: Access from this IP denied

Check the IP address restrictions for the employee under whom the integration is performed.

Add the external server address where the BI system module is installed to the employee's IP address list.

Error: Type: already_exists

If you cannot enable administrator access in the BI module settings, check that there are no users with two identical email addresses. Change the duplicate email address and enable the required permissions for the user.

The BI module did not appear in the BILLmanager interface

Connect to the server with the BI module via SSH. For more information about connecting via SSH, see the article Workstation setup.
Check the log files /usr/local/mgr5/ etc/business_intelligence/ansible/logs/install_[date]-*.log for the following entry:
```
TASK [Start BI app] ************************************************************

changed: [bi-host]
```

Run the commands:

docker ps -a
docker network inspect bi-net

The installation was successful if the response contains the bi-app, data-warehouse, etl containers.

To display the BI module in the BILLmanager interface, specify the following parameters in the configuration file /usr/local/mgr5/ etc/billmgr.conf:

BIHost — the address of the server with the BI module;
BIPassword — the password for the BI administrator account.

Error "Mysql error: Failed to connect"

Error description: The module cannot connect to the BILLmanager database.

If the BI module is installed on a server with a private network IP address (for example, with access via VPN), BILLmanager will have two IP addresses: public and private. During the BI module installation, the public IP address of BILLmanager will be used. The ETL component will use the public IP address instead of the private one to connect to the BILLmanager database.

To fix the database connection error, change the public IP address to a private one in the settings:

Connect to the server with the platform via SSH. For more information about connecting via SSH, see the article Workstation setup.

Change the rule in firewalld:

firewall-cmd --zone=bi --add-source=<приватный_ip_адрес>

Remove the public IP address from the rule:

firewall-cmd --zone=bi --remove-source=<публичный_ip_адрес>

Restart firewalld:
```
systemctl restart firewalld
```
Change the host value for the BI user in mysql:
Open the mysql console
```
mysql
```
Change the host value for the BI user
```
UPDATE mysql.user SET host = '<приватный_ip_адрес>' WHERE user = 'bi' ;
FLUSH PRIVILEGES;
```
Close the mysql console
```
exit
```
In the /usr/local/mgr5/etc/business_intelligence/ansible/vars.json file, replace the value of the bill_db_host parameter from localhost to the private IP address.
Run the installation script from the /usr/local/mgr5/ directory:
```
./etc/business_intelligence/ansible/run.sh install
```

In the logs, instead of the Mysql error: Failed to connect error, there will be a successful connection message Datasource 'billmgr_db' added.

Error "iptables: No chain/target/match by that name"

To fix the error:

Connect to the server with the BI module via SSH. For more information about connecting via SSH, see the article Workstation setup.

Stop the containers:

docker stop etl
docker stop bi-app
docker stop data-warehouse

Remove the containers:

docker rm etl
docker rm bi-app
docker rm data-warehouse

Remove the docker network:
```
docker network rm bi-net
```
Restart docker:
```
systemctl restart docker
```
Install the BI module from the BILLmanager web interface. For more information, see the article Installing the BI module and configuring user permissions.