Common Chart Export Issues and Troubleshooting

If this document is helpful to you, you can click Helpful at the bottom, which can help us identify the content that is truly required. Your comments are also welcome if you find any problem or missing content in the document.

1. Platform setting: You can customize the maximum number of data records exported per chart. See Template Limit. 

2. Using the export, task schedule, and in-designer chart display functions of FineReport requires loading the libj2v8_linux_x86_64.so file in J2V8 if FineReport is deployed in a Linux environment and the JDK version is below 1.8. Pay attention to the GCC version. If the GCC version is low, the following problems may occur.

a. The exported chart is blank, and the template reports an error saying "C library and JDK version do not meet the requirements, Please upgrade GBLIC to 2.17 And GLIBCXX to 3.4.19 or JDK to 1.8."

b. The exported chart is blank during a scheduled task. The system prompts operation failure, and there is an error message in the log saying "C library and JDK version do not meet the requirements. Please upgrade GBLIC to 2.17 and GLIBCXX to 3.4.19 or JDK to 1.8."

Note:

Even if the user's JDK version is above 1.8, prioritizing upgrading the GCC is advised for better export performance.

Reference document: Chart Export Upgrade Instructions. 

JDK-related Issues

1. The edge of exported charts a jagged on an ARM platform.

Problem description: The edge of the exported chart is jagged.

Cause analysis: Some versions such as Oracle JDK 1.8 for ARM may result in jagged edges in the exported charts. Replace the JDK, where the installation package can be downloaded from the Amazon official website.

2. The shape of exported charts is abnormal.

Problem description: The exported charts have abnormal shapes, such as partially missing bars in bar charts and abnormal jagged edges in graphs, as shown in the following figures.

Cause analysis: Some versions of JDK may have bugs, causing abnormal rendering. (The bar chart problem in the above figure happens to JDK 1.8.0_212. JDK 1.8.0_251 also has such problems, but they are resolved after the JDK is updated to 1.8.0_351, as shown in the following case. The jagged edge in the line chart occurs in JDK 1.8.0_171.)

Solution: Try reproducing the issue in the local project using the customer's JDK. If it can be reproduced, update the customer's JDK.

Setting-related Issues

1. The exported chart is deformed.

Problem description: The pie chart changes from circular to elliptical when exported as Excel. Deformation also occurs in chart export tests on local. 

Cause analysis: The issue lies in the coefficient settings in fine_conf_entity that control the width and height of the exported Excel. Increasing the width coefficient CustomConfig.excelAdjustWidth can widen the exported pie chart.

Solution: Modify the CustomConfig.excelAdjustWidth field in the fine_conf_entity table of finedb from the default value of 34.742 to 40.242.

2. Partial data in a chart with a large data volume is missing after export.

Problem description: Data in the exported chart is missing compared with that in the previewed chart, as shown in the following figures.

Cause analysis: Refer to Template Limit to see if the data export volume limit per chart is enabled.

3. The exported chart displays "com.fr.chart.chartattr.ChartPainter".

Problem description: The exported chart is displayed as a string "com.fr.chart.chartattr.ChartPainter".

Cause analysis: The Display Content in chart cell attributes is set to Display by HTML, which should be changed to Default.

4. The size of the exported chart is 1kB, and the content is blank.

Problem description: A customer uses the built-in export button to export a bar chart and gets a blank PNG file with a size of only 1kB.

Cause analysis: After troubleshooting with the dichotomy method, it is found that this problem is caused by abnormal data of a category.  Editing the field data in the database and saving it can solve this issue.

5. Custom label text in the chart is exported abnormally.

Problem description: A customer customizes the radius under Style > Series, with the label settings following the template theme. The donut chart in the exported Word file is inconsistent with that in the previewed report.

Cause analysis: This issue lies in the browser resolution settings.

Solution: Zooming out to 50% can solve this issue.

6. Failed to export charts.

Problem description: CPT reports can be exported as Excel/PDF files using the toolbar. But when reports are exported using the URL, the chart cannot be exported. Adding &format=excel&extype=simple&isExcel2003=true or op=export&format=excel does not work, and this issue is unrelated to the exported Excel format (XLS or XLSX).

Cause analysis: Charts cannot be exported during pagination preview if the row engine is enabled.

Solution: Adding op=write to the URL can solve this issue.