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
The following are a few possible cases of this issue.
This issue arises if an additional connection parameter is not specified while connecting the data source.
This issue occurs when the active warehouse is not set in the snowflake instance.
To resolve this issue, please add Warehouse=WarehouseName in the Additional connection parameters.
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.
This issue occurs when the NT AUTHORITY/SYSTEM is not added in the IIS/IIS EXPRESS to access the SQL Server Windows Authentication mode.
Please follow the instructions here to resolve this issue.
The following factors led to this type of error:
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
The above-specified error arises when the query times out before the operation is completed.
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.
Please find the steps to increase the timeout value in the following Nginx.
3. Finally, restart nginx by running the following command.
sudo systemctl restart nginx
Refer to the document provided to change nginx manually-configure-nginx
The above-specified error occurs when there is insufficient space to store temporary files requested by the MySQL server.
\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:
This error occurs when the SQL server’s date format or culture is mismatched.
Use the following commands to verify and change the settings.
SET DATEFORMAT mdy
This error occurs when Bold BI connects to a MySQL server over SSL without adding the SSL specification.
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.
Avoid using dimension columns in numerical expressions.