Error in Excel Exporting

After exporting the component as Excel, you may find an error occurs when opening this file: "errorCode:500, errorMsg: java.lang.NullPointerException."

View the FineBI log in %FineBI%/logs/fanruan.log, and you may find the corresponding error displayed as follows.

java.lang.NullPointerException
at sun.awt.FontConfiguration.getVersion(FontConfiguration.java:1264)
at sun.awt.FontConfiguration.readFontConfigFile(FontConfiguration.java:219)
at sun.awt.FontConfiguration.init(FontConfiguration.java:107)
at sun.awt.X11FontManager.createFontConfiguration(X11FontManager.java:774)
at sun.font.SunFontManager$2.run(SunFontManager.java:431)
at java.security.AccessController.doPrivileged(Native Method)
at sun.font.SunFontManager.<init>(SunFontManager.java:376)
at sun.awt.FcFontManager.<init>(FcFontManager.java:35)
at sun.awt.X11FontManager.<init>(X11FontManager.java:57)
at sun.reflect.GeneratedConstructorAccessor654.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at java.lang.Class.newInstance(Class.java:442)
at sun.font.FontManagerFactory$1.run(FontManagerFactory.java:83)
at java.security.AccessController.doPrivileged(Native Method)
at sun.font.FontManagerFactory.getInstance(FontManagerFactory.java:74)
at java.awt.Font.getFont2D(Font.java:491)
at java.awt.Font.canDisplayUpTo(Font.java:2060)
at java.awt.font.TextLayout.singleFont(TextLayout.java:470)
at java.awt.font.TextLayout.<init>(TextLayout.java:531)
at com.fr.third.v2.org.apache.poi.ss.util.SheetUtil.getDefaultCharWidth(SheetUtil.java:254)

This error is caused by the lack of related font resources in the Linux system, and a font manager needs to be installed.

Execute the following command to install the font manager in Linux.

yum install fontconfig

If using Docker to create a base image, execute the following command.

RUN yum -y install fontconfig
RUN fc-cache --force

After exporting the component as Excel, you may find an error occurs when opening this file.

Sheet naming in Excel follows the following rules.

1. The sheet name cannot exceed 31 characters (the character includes English letters, |, (), etc., but does not include \, /, ? , *, [], etc.). When using the POI tool in the program, if you input a string greater than 31 characters, it will be automatically truncated to two substrings whose names are the same, resulting in an error.

2. The sheet name cannot be empty, otherwise an error will be reported.

Modify the component name and its corresponding length to comply with Excel naming rules.

Fail to export Excel in Linux, and the following error occurs when you check the log or press F12 to go to the console: Could not initialize class sun.awt.X11GraphicsEnvironment.

In Linux, when exporting the component as Excel, the Java image package is used to process images. Local X-server is required when you use the Java virtual machine to process images, otherwise this error will occur.

Solution:

Directly Installed FineBI

Find the file finebi.vmoption in the path %FineBI5.1%\bin, add -Djava.awt.headless=true into the file, and save the file. 

Go to the directory %Tomcat%/bin, find the configuration file catalina.sh, and add the parameter -Djava.awt.headless=true parameterinto the file.

After exporting the component as Excel, you may find an error occurs when opening this file.

The exported Excel data exceeds the limit.

Reduce the amount of exported Excel data through filtering and other methods.

When exporting the component as Excel, the error message "Export Column Out Of Limit! Contact the administrator." is displayed.

The number of exported columns exceeds 100.

Modify parameters in the external database by entering insert into fine_conf_entity(id,'value') values ('SystemOptimizationConfig.crossExportColumnLimit','value'). You are not advised to modify the value to be very large.