Troubleshooting gateways - Bold BI

This documentation discusses common issues when you use Bold BI. If you encounter an issue that isn’t listed here, you can create a support ticket

Error: Network related instance-specific error - SQL Server

The following are a few possible cases of this issue.

1. Please verify that the port number provided is a valid and that the instance has any fire wall rules enabled.
2. If the SQL server has any SSL enabled or verified the database name, the user credential has the proper permission to access that database.

Error: Unable to convert MySQL datetime to System.DateTime

This issue arises if an additional connection parameter is not specified while connecting the data source.

Solution

Error: No active warehouse selected in the current session - Snowflake

This issue occurs when the active warehouse is not set in the snowflake instance.

Solution
To resolve this issue, please add Warehouse=WarehouseName in the Additional connection parameters.

Error: dll not found

This error occurs if the required client dll is not installed in Bold BI. Please download the client libraries based on your environment using the following help links.

• Installing client libraries in azure app service
• Installing client libraries in linux
• Installing client libraries in windows

Error: Login failed for user - SQL Server Windows authentication

This issue occurs when the NT AUTHORITY/SYSTEM is not added in the IIS/IIS EXPRESS to access the SQL Server Windows Authentication mode.

Solution

Please follow the instructions here to resolve this issue.

Error: Couldn’t connect to server

The following factors led to this type of error:

1. If any the IP addresses specified at Bold BI Cloud IP addresses weren’t whitelisted.
2. If pooling was not defined when a data source was created in Bold BI.

Solution
This problem can be fixed by including the pooling value in additional connection parameter when creating the data source. Additional connection parameters: Pooling=True; Connection Reset=false and whitelisting the IP addresses mentioned in Bold BI Cloud IP addresses
Please refer to the following image

Error: Command Time-out issue

The above-specified error arises when the query times out before the operation is completed.

Solution
This issue is resolved by increasing the command timeout value while creating the data source.

Using Bold BI:
Please follow these steps to increase the command timeout value in Bold BI.

1. Give the server information on the page for data source connectivity.
2. Increase the command timeout value.

Using Nginx:
Please find the steps to increase the timeout value in the following Nginx.

1. Edit the boldbi-nginx-config file in the /etc/nginx/sites-enabled directory.
   
2. Edit all timeout values and save them.

3. Finally, restart nginx by running the following command.
sudo systemctl restart nginx
Refer to the document provided to change nginx manually-configure-nginx

Error: No space left on device

The above-specified error occurs when there is insufficient space to store temporary files requested by the MySQL server.

Solution
Check whether \temp is in its own partition by using df -h command.
If it is in its own partition and short of space, you can either:

• Modify /tmp so that its partition has more space (either by reallocating or moving it to the main partition – example - Link).
• By altering the MySQL configuration file, a different temporary folder on a different partition is used by the database. For example /var/temp

Error: Converting varchar to datetime datatype

This error occurs when the SQL server’s date format or culture is mismatched.

Solution

1. Please verify that the date format settings for the server and system are the same.
   
2. If the date format in sqlserver is dmy, then change it to mdy and vice versa.
   

Use the following commands to verify and change the settings.
DBCC useroptions
SET DATEFORMAT mdy

Error: Unable to connect MySQL in SSL mode

This error occurs when Bold BI connects to a MySQL server over SSL without adding the SSL specification.

Solution

1. Check if the IP addresses mentioned in the provided link Bold BI Cloud IP addresses are whitelisted.
2. Verify whether the person who logs in can access the MySQL server.
3. This issue can be resolved by including SslMode=Required in an additional connection parameter.

Error: Invalid parameter in expression for SSAS

A measure must be used for expressions like SUM, COUNT, and more. The issue in the following image may arise if a dimension was included in these expressions.

Solution
Avoid using dimension columns in numerical expressions.