Linkage Error

Problem:

When clicking Component Linkage on the dashboard, an error message "Comparison method violates its general contract" is displayed.

Cause:

The error is caused by an incompatible sorting in the JDK after the JAR upgrading, resulting in a Java sorting exception error.

Solution:

Go to the FineBI directory %FineBI%/bin, open FineBI.vmoptions, open it with Notepad, and add the following parameters into it.

Djava.util.Arrays.useLegacyMergeSort=true

Save it and restart FineBI.

Problem:

Go to %FineBI%/logsto check fanruan.log, and you may find that the number of filtering conditions where the query has increased greatly.

Cause:

You have performed header filtering and set the component linkage with other components, leading to a massive increase in the number of filtering conditions in where query. The request with an excessively long list of filtering conditions has blocked the engine.

Solution:

Download Fine_conf_entity Visual Configuration Plugin to add the parameter SystemOptimizationConfig.queryConditionCountRestriction. You can obtain the plugin at Welcome to FineReport Community!.

The parameter means the limitation quantity of filtering conditions when you perform querying.

Default value: null(no restriction)

Recommended value: 30. The value can be smaller, which depends on your filtering scenario.

Effect: A query with the number of filtering conditions exceeding the limit will be interrupted, and an error will be reported: condition count out of restriction: xxxx.