Troubleshooting gateways - Bold BI

This documentation discusses common issues that may arise when using Bold BI. If you encounter an issue that is not 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 valid and that the instance has any firewall rules enabled.
2. If the SQL server has SSL enabled or if the database name has been verified, ensure that the user credentials have the proper permissions to access that database.

Error: Unable to convert MySQL datetime to System.DateTime

This issue arises when an additional connection parameter is not specified when connecting to 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 when 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 IIS/IIS EXPRESS to access the SQL Server Windows Authentication mode.

Solution

Please follow the instructions provided here to resolve this issue.

Error: Couldn’t connect to server

The following factors led to this type of error:

1. If any of the IP addresses specified in the Bold BI Cloud IP addresses addresses were not 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 the additional connection parameters when creating the data source. The 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 error specified above occurs when the query times out before the operation is finished.

Solution

This issue can be resolved by increasing the command timeout value when creating the data source.

Using Bold BI:

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

1. Provide the server with the 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 configuration.

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
   
   Please refer to the provided document for instructions on manually-configure-nginx

Error: No space left on device

The specified error occurs when there is not enough space to store temporary files requested by the MySQL server.

Solution

Check if \temp is in its own partition by using the df -h command.

If it is in its own partition and running low on 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 modifying the MySQL configuration file, the database uses a different temporary folder on a separate partition. 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 SQL Server is set to dmy, then change it to mdy and vice versa.
   
   Use the following commands to verify and change the settings.
   
   DBCC useroptions
   

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 if the person logging in can access the MySQL server.
3. This issue can be resolved by including SslMode=Required as an additional connection parameter.
   
   

Error: Invalid parameter in expression for SSAS

A measure must be used for expressions such as SUM, COUNT, and others. The issue shown in the following image may arise if a dimension is included in these expressions.

Solution
Do not use dimension columns in numerical expressions.