Dashboard Errors

This document introduces the errors and solutions related to the dashboard.

Description

An error message "Templates Missing" occurs when you create a dashboard, as shown in the following figure.

Cause

1. A lack of file permissions. After configuring FTP or migrating projects, you need to configure the corresponding file permissions, otherwise, an error will occur when you create a dashboard.

Click Test Connection in the file server already set on the platform. An error message will occur, as shown in the following figure.

2. Network security settings intercept system requests. Common interception tools include WAF and NGINX.

Solution

1. Assign permissions to the folder.

chmod -R 777 /home/ftpuser # Assign write permission to the ftpuser folder.

2. Remove network security interception.

Job aborted due to stage failure

Description

After the data is extracted to the local machine, an error occurs when you preview the dashboard created with the corresponding data.

Job aborted due to stage failure: Total size of serialized results of 154 tasks (1026.5 MB) is bigger than spark.driver.maxResultSize (1024.0 MB)

Cause

This error is caused by the spark driver. Spark V1.2 added a new feature that limits the amount of data that can be returned to the driver program. If the data is too large during querying, the driver will trigger a protection mechanism. To avoid this situation, the amount of queried data should not be greater than the default maximum result size (spark.driver.maxResultSize) set by Spark.

Solution

Add the parameter DistributedOptimizationConfig.spiderConfig.spark_driver_maxResultSize to the table FINE_CONF_ENTITY and set the value of this parameter to an appropriate maximum data size.

Note:

The value cannot be too large, as it may cause a memory overflow.

sql{...}is wrong, please check

Description

Enable Direct-Connected Data to directly connect to the database, and use the data to create a dashboard. An error occurs when you preview the dashboard.

The SQL：{...}is wrong, please check...

Cause

This error is the feedback from the database, which is caused by sending SQL to the database during dashboard preview.

Solution

You need to adjust the data based on the error reason after please check in the feedback, and then preview the dashboard. For instance, the error in the above example is Data conversion error converting "Yes". To address this error, you can delete the Yes field or adjust the field type before previewing the dashboard again.

no such file or directory and file info: xxx

Problem

When you view the dashboard, an error message "no such file or directory and file info: xxx" occurs.

Cause

Insufficient disk space.

Solution

Use the command df -h to check the disk usage, clear disk space as needed, and then restart the project.