Chart big data preview / export error

1.1 Problem phenomenon

When previewing or exporting big data charts, the dashboard page cannot be accessed, and the error is as follows:

Handler processing failed, nested exception is java.lang.NoClassDefFoundError: javafx/embed/swing/JFXPanel

1.2 Screenshot of error reporting

Check the background log (the log corresponding to the web server, for example, %tomcat%/logs/catalina.log, and you can see the following detailed log error reports:

1.3 Cause analysis

JavaFX is used in many functions of FineBI5.1, but openjfx is not used in some openjdks. If FineBI5.1 is deployed using the web container under this openjdk, the big data function and export function of the chart will be affected and cannot be used, and the above JavaFX related errors will appear.

1.4 Solution

Add this openjfx function to openjdk without openjfx. Let's take RedHat openjdk under windows as an example to introduce the operation steps of how to make openjdk have openjfx function. Before operation, you need to close FineBI.

Example:

1) RedHat openjdk is a common openjdk, but it does not include openjfx. Download RedHat openjdk on this page, complete the installation and configure the environment variables.

2) Download openjfx. Openjfx for windows, Linux and MacOS systems is directly provided here for download:

3) Unzip the downloaded openjfx file. The directory structure under Windows system is as follows:

4) Unzip the files in each directory after openjfx and copy them to the directory after openjdk installation. For example, the files in the bin directory are javafxpackager.exe and javapackager.exe, as shown in the following figure:

Copy it to the openjdk installation directory bin, as shown below:

5) Similarly, copy the files in jre and lib directories to the corresponding directory of openjdk. After the operation is completed, the openjdk contains openjfx. So far, the operation of making openjdk have openjfx function is completed.

6) Start FineBI and check the dashboard that reported error before. The display will be normal after these operations.