Version
1. Added the following items to System Inspection:
0119 Memory Occupied by Caching on Physical Server
0120 Estimated Maximum Memory Usage of Process with Current Configuration
2. Added the following item to System Operation Status:
0213 Deployment Method
3. Added the following items to Java VM Check:
0802 FineIO Read Memory
0903 FineIO Write Memory
0121 Memory Resource Check
0122 Node Container - Memory Resource Check
0123 Node Container - CPU Resource Check
2. Optimized the following items in System Inspection:
0108 Core Quantity
0109 Memory Size
3. Added the following item to System Operation Status:
0214 Nginx Configuration Check
4. Added the following items to Java VM Check:
0801 Off-Heap NIO Memory
0813 Code Cache Configuration
0820 On-Heap Memory
0823 Metaspace Configuration
Added the following item to System Operation Status:
0215 Inter-Node Time Consistency Check
0113 CPU Information
0114 Server Font Encoding
0115 Server Font Package
2. Added the following item to Business Inspection:
1025 Whether to enable Cloud O&M
3. Added the following item to Non-Containerized Deployment Information:
0603 Multi-process Detection
4. Added the following item to Java VM Inspection:
0822 JDK Path
1. Added the following items to Disk Inspection:
0509 Sequential Read (Non-buffer Pool)
0510 Sequential Write (Non-buffer Pool)
2. Deleted the following item in Disk Inspection:
0503 Random Read
3. Displayed "The rate is less than 100 MB/s." instead of specific values if the disk read/write speed was below 100 MB/s.
Added the following item to Business Inspection:
1026 Password Strength Limit Check
1. Supported Quick Fix for the following item of Environment Inspection:
0705 Glibc Memory Leak Configuration
2. Supported Quick Fix for the following items of Java VM Inspection:
0807 Headless Mode
0809 BytecodeRecompilationCutoff Configuration
0810 PerMethodRecompilationCutoff Configuration
0816 ZIP-Related Configuration - Dsun.zip.disableMemoryMapping
3. Added the following item to Java VM Inspection:
0823 Metadata Space Configuration
0212 Tomcat Background Running
1. Added the following item to Non-Containerized Deployment Information:
0604 File Server Solution for Cluster
2. Added the following item to Java VM Inspection:
0824 Disk Space Required for Dump Output
3. Added the following items to Business Inspection:
1027 Limit on Submitted Record Quantity
1028 Data Export Volume Limit Per Chart
1029 Template Limit Relaxation
1030 Enable Extracted Data Cache
1031 Cache Space Limit
1032 Enable Parallel Dashboard Calculation
1033 Enable Crash Handling Tool
1034 Automatic Stack Export of Auto Carsh Handling Tool
1035 Lifecycle Setting
1036 Spark Memory Ratio
1037 Update Relevant Configuration
1038 Update SQL Complexity Limit
0116 CPU Performance
0117 System OOM Configuration
0118 ProcessUnpackaged Configuration
2. Optimized the following item in Disk Check:
3. Added the following items to Environment Check:
0706 Redis Eviction Policy
0707 Maximum Number of Processes (nproc)
5. Added the following items to Business Check:
1039 Gzip Configuration
1040 Long and Short Query Configuration
1041 LogDB Configuration
1042 Memory Measurement Configuration
1043 Engine Configuration
1044 Connection Pool Configuration of External Configuration Database
Added the following items to Business Check:
1045 Consistency of Week Start Day
1046 Consistency of Text Order
Changed the name of the 0110 check item of System Inspection from Swap to Virtual Memory.
Added the following item to Business Check:
1047 Running Status of Crash Handling Tool
1048 Parameter Setting of External Configuration Database
FanRuan applications have certain system configuration requirements. If the requirements are not met, there may be risks of abnormal usage or crashes. Therefore, you need to regularly inspect the environments and configurations to ensure the healthy operation of the applications.
Meanwhile, the admin needs to monitor the application's operating status and use O&M methods to mitigate risks or locate and resolve issues in time after they occur to ensure the continuous high availability of applications.
Items of System Inspection include:
Inspection Item Number
Inspection Item
Whether Cluster Nodes Are Checked Separately
Whether Quick Fix Is Supported
Health Standards and Suggestions for Modification
0101
Operating System Information
Yes
No
It only outputs information.
0102
Server Time
0103
Time Zone
0104
Glibc/GCC Version
0105
Hostname
0106
Host File Information
0107
CPU Clock Speed
It checks whether the frequency is greater than or equal to 2.4 GHz.
You are advised to ensure that the frequency is greater than or equal to 2.4 GHz.
0108
Core Number
It checks the number of CPU cores.
For the FineBI - Application Node and Engine - Calculation Node components, the recommended maximum number of available CPU cores is at least 8.
For the FineReport, FineDataLink, and Engine - Metadata Node components, the recommended maximum number of available CPU cores is at least 4.
0109
Memory Size
FineOps-deployed projects:
The recommended upper memory limit for the bi-web, bi-engine-master, and bi-minio containers is at least 6 GB.
The recommended upper memory limit for the worker container is at least 24 GB.
Verify that the upper memory limit for the fr/fdl container is not less than 15.5 GB. Set it to a value greater than 16 GB.
Projects not deployed via FineOps:
It checks whether the total physical memory of the server hosting the project is greater than or equal to 15.5 GB.
The recommended server physical memory is at least 16 GB.
0110
Swap
It checks if virtual memory is disabled.
It outputs the swap partition size.
Disable virtual memory.
0111
Memory Used
0112
Available Memory
0113
CPU Information
0114
Server Font Encoding
0115
Server Font Package
It checks if the set heap memory is within the recommended range.
It checks if the median FGC duration in the past week is less than 10 seconds.
If either of the above conditions is not met, CPU performance is considered poor. Increase the number of CPU cores, use a CPU with better performance, or appropriately reduce the maximum heap memory (-Xmx) to avoid excessive Full GC durations that may impact system usability.
This check applies to projects not deployed via FineOps only.
It checks if the value of the Linux kernel parameter vm.panic_on_oom in /proc/sys/vm/panic_on_oom is set to 0.
You are advised to adjust the configuration by running sysctl -w vm.panic_on_oom=0 to prevent the system from panicking on out-of-memory events.
It checks the value of ProcessUnpackaged in /etc/abrt/abrt-action-save-package-data.conf.
This check applies to non-FineOps-deployed projects on Linux servers.
For FineBI - Application Node and Engine - Calculation Node components:
It calculates the total memory usage as:
Xmx value + Off-heap memory size + CodeCache value + Metaspace size + 3 GB
Ensure that this sum value is not more than the maximum available memory of the container.
For the Engine - Metadata Node component:
Xmx value + Off-heap memory size + CodeCache value + Metaspace size + 2.4 GB
It outputs the sum of the maximum available memory of all containers on the server.
It outputs the actual available memory of the server.
Ensure that the sum of the maximum available memory of all containers on the server is less than or equal to the available memory of the server. This can be achieved by reducing the maximum available memory of containers or increasing the server memory configuration.
It outputs the sum of the maximum available CPU cores of all containers on the server.
It outputs the actual number of CPU cores on the server.
Ensure that the ratio of the sum of the maximum available CPU cores of containers to the actual server CPU core count is less than or equal to 4.
Linux Server
1. Log in to the host machine.
Use an appropriate authentication method (such as SSH or Console) to log in to the host machine where the container is running.
2. Check whether the swap partition is enabled in the current system.
Use the following command to view the information of the started swap partition in the system:
sudo swapon -s
If the output result is empty, it means that the swap partition is not started currently.
3. Disable the swap partition.
Use the following command to disable the swap partition:
sudo swapoff -a
This command disables all started swap partitions.
4. Disable the swap partition permanently.
To prevent the swap partition from being automatically enabled during the next system startup, you need to modify the system configuration file correspondingly.
Taking Ubuntu as an example, you can follow these steps:
Comment out or delete the line containing swap in the fstab file of the /etc directory.
Execute the following command to update the grub bootloader:
sudo update-grub
5. Verify whether the swap partition has been disabled.
After restarting the system, you can execute the sudo swapon -s command again to see if there is a started swap partition.
If the output result is empty, it means that the swap partition has been disabled successfully.
Windows Server
1. Log in to the server and choose System Properties > Advanced > Performance> Settings.
2. Click Change under Advanced > Virtual Memory.
3. Deselect Automatically manage paging file size of all drivers.
4. Select Custom Size and set the initial size and maximum size.
You are advised to set the initial size to 1.5 times the physical memory and the maximum size to 2 times the physical memory. Modify it with caution.
System Operation Status checks include:
Health Standard
0201
Startup Duration
It only outputs information, including the time taken for this startup.
0203
Project Startup Path
It only outputs information, including the directory path.
0204
Abnormal Project Folder Size
Check the size of each folder located in the /WEB-INF path of the project.
Healthy: No folder exceeds 5 GB in size.
Unhealthy: Some folders exceed 5 GB in size.
Suggestion:
You are advised to check and clean up the contents of the folders exceeding 5 GB in size.
0205
Plugin Information
It only outputs information, including plugin name, version, and whether it is enabled or not.
0206
Registration Authorization Information
It only outputs information, including whether the project is registered.
0207
web.xml Available Under WEB-INF or Not
It only outputs information, including Yes/No.
0208
Container Version
0209
Project JAR Package Information
It only outputs information, including versions of various modules in the project and JAR package dates.
0211
Temporary Output Directory
It only outputs information, including the directory path and remaining available space in the directory.
0212
Tomcat Background Running
Check if Tomcat is running in the background using javaw.
Healthy: Tomcat is running in the background using javaw.
Unhealthy: Tomcat is running in the background not using javaw.
Suggestion: You are advised to make Tomcat run in the background using javaw.
It outputs FineOps Deployment or Non-FineOps Deployment.
It checks whether the relevant configuration in the nginx.conf file complies with the following recommended settings.
Passive Health Check
The recommended max_fails value is at least 15.
The recommended fail_timeout value is at most 5 s.
Active Health Check
The recommended value range of interval is [2000, 60000].
The recommended rise value is at most 3.
The recommended value range of fall is [5, 20].
The recommended value range of timeout is [2000, 5000].
You are advised to configure check_http_send=/webroot/decision/system/health.
You are advised to configure check_http_expect_alive=http_2xx http_3xx.
It checks the current time of all nodes in the project.
Ensure the time difference between nodes is less than 1 s.
Cleanable File
1. File path:
The default path is /webapps/webroot/backup.
If the backup folder resides in a custom path, the system will scan the custom path.
2. Purpose:
It stores project backups.
3. Cleanup risk level:
High (caution required)
The displayed files in this path have date-stamped names. You can select and clean files of the required dates.
You are advised to clean up the files older than 3 months.
Files within the last 3 months are not displayed.
/webapps/webroot/WEB-INF/schedule
It stores intermediate files generated by scheduled tasks.
3. Cleanable scope:
The system only displays files older than 12 months for cleanup.
4. Cleanup risk level:
Low (cleanup recommended)
You are advised to clean up the files older than 12 months.
Files within the last 12 months are not displayed.
/webapps/webroot/WEB-INF/assets/vcs
FineReport template version management file
The system only displays files older than 30 days for cleanup.
All historical version files older than 30 days are stored in one folder for easy selection and cleanup.
You are advised to clean up the files older than 30 days.
Files within the last 30 days are not displayed.
/webapps/webroot/WEB-INF/treasures
It stores packages of cloud O&M logs.
Tomcat installation directory/logs/fanruan.log
It is the operation log of the FanRuan project.
The system scans for exported dump files that were not cleaned up in time.
Dump file
Clean up the files older than one week.
Files within one week are not displayed.
Tomcat installation directory/logs/Catalina.log
Tomcat operation log
4. Notes
If the log is not configured to roll in Tomcat, do not clean it up.
Tomcat installation directory\logs\Catalina.out
The standard output and error log of Tomcat
If the file does not exist on the Windows system, do not clean it up.
Cleanup Method
Log in to FineOps as the admin, click a specified project, and choose Business Tool > Resource Cleanup.
Select the file types you want to scan and click Start scanning. You can tick and clean up the redundant files found during the scan.
Log in to the FanRuan system as the admin and choose System Management > Intelligent O&M > Disk O&M > Disk Cleanup.
Select the files/folders to be scanned, and click Start Scanning to immediately start scanning for redundant files eligible for manual cleanup.
In the Windows system, if the project deployed using the Tomcat container is started under window mode instead of background mode, the window may enter the edit and insert state due to accidental clicks, blocking log output and causing the project to become stuck.
For the Windows system, you are advised to start the project deployed using the Tomcat container under background mode.
Modify the default startup mode to javaw first. Prevent repeated startups by adding a script to detect startup commands. Pressing any key can end the script.
1. Modify setclasspath.bat.
Open the setclasspath.bat file in Tomcat installation directory\bin\setclasspath.bat, find set _RUNJAVA, and modify its value:
set _RUNJAVA="%JRE_HOME%\bin\javaw.exe"
2. Modify catalina.bat.
Open the catalina.bat file in Tomcat installation directory\bin\catalina.bat and add the following judgment tips at the end:
set ENV_VAR_VALUE=%_EXECJAVA%echo %ENV_VAR_VALUE% | findstr /C:"javaw" >nulif %errorlevel% equ 0 ( echo Tomcat is running in the background pause)
Items of Port Inspection include:
0301
WebSocket Port
It only outputs information, including the port number.
0302
Cluster Port
It checks whether the cluster ports are connected.
Healthy: The ports are connected.
Unhealthy: Some ports are disconnected.
Suggestion: The connectivity status of cluster ports is abnormal.
0303
Crash Detection
Inspect:
1. Whether automatic crash detection is enabled.
2. Whether the crashed ports are connected.
Suggestion: You are advised to enable Crash Detection and ensure the ports are available.
WebSocket is mainly used to refresh tokens, check users being kicked out, display platform messages, memory, and CPU, check the number of current system online users in the platform log, and determine data connection editing status. Disabling WebSocket will affect the socket communication and may result in abnormal access disconnection.
For FineOps-deployed projects, the WebSocket port resides within the container and generally cannot be occupied, so no fix is required.
For projects not deployed via FineOps, you can choose an appropriate WebSocket port configuration method based on your project conditions. For details, refer to the table below.
Solution
Scenario
Container WebSocket Solution
The container WebSocket solution does not require any user operation. The system can automatically use the WebSocket built into the Web container to connect and reuse the HTTP port.
As long as your environment meets the validation conditions, the solution will be automatically used.
If your environment does not meet the validation conditions, you can consider configuring the Socket.IO solution by yourself.
Socket.IO Solution
Log in to a FanRuan application as the admin, and choose System Management > Intelligent O&M > Cluster Configuration.
You can view the ports of each node in the cluster. The nodes that cannot be used will be highlighted in red.
The node ports are editable. You can hover the cursor over a specific node to make the Edit button appear.
The operation of the crash handling tool requires a free and available port on the server where the application resides.
For FineOps-deployed projects, the port for the crash handling tool is configured and verified for availability during deployment. Therefore, no additional port setting is required.
For projects not deployed via FineOps, you must manually set the port to be used by the crash handling tool and ensure it is available.
Projects managed by FineOps
1. Log in to FineOps as the admin, click an O&M project, and choose Availability Statistics > Crash Handling Strategy.
2. Enter the port number in Port Setting. The default port is 12100. Enter a port number between 1024 and 65535.
3. Click Test. A prompt will appear: "The port is available. After saving, the crash handling tool will restart with its port updated to the new one."
4. Click Save to apply the changes.
Projects not managed by FineOps
1. Log in to the FanRuan application as the admin and choose System Management > Intelligent O&M > Downtime Handling > Automatic Downtime Handling Tool.
Check whether the communication between the file server, external database, state server, and application is normal, whether they can be pinged, and whether there are any packet losses.
Items of Disk Inspection include:
0501
Sequential Read
It only outputs information, including the speed of sequential read (display "The rate is less than 100 MB/s." instead of specific values if the speed is below 100 MB/s).
0502
Sequential Write
It only outputs information, including the speed of sequential write (display "The rate is less than 100 MB/s." instead of specific values if the speed is below 100 MB/s).
0504
Small File Creation
It only outputs information, including the number of small files created per second.
0505
Small File Deletion
It only outputs information, including the number of small files deleted per second.
0506
Disk Space
1. For FineReport projects:
Healthy: The total disk space is not less than 100 GB.
Unhealthy: The total disk space is less than 100 GB.
Suggestion: You are advised to use the disk with over 100 GB.
2. For FineBI projects:
Healthy: The total disk space is not less than 400 GB.
Unhealthy: The total disk space is less than 400 GB.
Suggestion: You are advised to use the disk with over 400 GB.
0507
Used Disk Space
It only outputs information, including the size of the used disk space.
0508
Free Disk Space
Healthy: The free disk space is greater than 10 GB.
Unhealthy: The free disk space is less than 10 GB.
Suggestions for modification: The available disk space is less than 10 GB. Clean up large disk files to avoid affecting the use.
Healthy: The free disk space is greater than 50 GB.
Unhealthy: The free disk space is less than 50 GB.
Suggestions for modification: The available disk space is less than 50 GB. Clean up large disk files to avoid affecting the use.
0509
Sequential Read (Non-buffer Pool)
Healthy: Disk performance > 150 MB/s
Unhealthy: Disk performance < 150 MB/s
Suggestion: The disk performance is poor, which may lead to performance issues. Replace it with a disk offering better performance, such as an SSD.
0510
Sequential Write (Non-buffer Pool)
Items of Non-Containerized Deployment Information Inspection include:
0601
Process User
It only outputs information, including the user name.
0602
Server Main Folder Permissions
0603
Multi-process Detection
Unhealthy: The sum of the maximum memory required by FanRuan applications and the memory used by other processes is not less than the total physical memory.
Suggestion: You are not advised to make the FanRuan project share the server with other application services, which may cause system crashes.
0604
File Server Solution for Cluster
Healthy: File servers are used for clusters.
Unhealthy: Inter-node synchronization is used for clusters.
Suggestion: You are advised to use file servers instead of inter-node synchronization for clusters. Otherwise, performance issues and file inconsistencies may occur.
Items of Environment Inspection include:
vm.max_map_count
Healthy: The value of vm.max_map_count is not less than 262144.
Unhealthy: The value of vm.max_map_count is less than 262144.
Suggestion: You are advised to set the vm.max_map_count parameter to 262144.
0702
Maximum Number of Opened Files
Healthy: The value of open_files is not less than 65536.
Unhealthy: The value of open_files is less than 65536.
Suggestion: You are advised to set the open_files parameter to greater than 65536.
Healthy: The value of open_files is not less than 131070.
Unhealthy: The value of open_files is less than 131070.
Suggestion: You are advised to set the open_files parameter to greater than 131070.
0703
vm.overcommit_memory
Healthy: overcommit_memory=0
Unhealthy: overcommit_memory ≠ 0
Suggestion: You are advised to set the vm.overcommit_memory parameter to 0.
0704
vm.overcommit_ratio
Healthy: overcommit_ratio = 50
Unhealthy: overcommit_ratio ≠ 50
Suggestion: You are advised to set the vm.overcommit_ratio parameter to 50.
0705
Glibc Memory Leak Configuration
It checks whether the export MALLOC_ARENA_MAX parameter is configured.
Healthy: export MALLOC_ARENA_MAX = 1
Unhealthy: not configured or configured to other values
Suggestion: You are advised to configure the export MALLOC_ARENA_MAX parameter to 1.
Healthy: The Redis eviction policy is set to maxmemory-policy noeviction.
Unhealthy: The Redis eviction policy is not set to maxmemory-policy noeviction.
Suggestion: Set the Redis eviction policy to maxmemory-policy noeviction. Failure to do so may result in unpredictable consequences due to unintended key eviction.
Healthy: The maximum process count (nproc) is greater than or equal to 266240.
Unhealthy: The maximum process count (nproc) is less than 266240.
Suggestion: Set the maximum process count (nproc) to a value not less than 266240.
vm.max_map_count is a Linux kernel parameter used to control the maximum number of memory-mapped areas allowed in a process.
If the value of this parameter is too small, memory-mapping errors may occur when you use some applications.
1. Add/Modify the parameter value in /etc/sysctl.conf.
vm.max_map_count=262144
Run the command sysctl -p for the modification to take effect.
open_files refers to the maximum number of file descriptors that a process can open at the same time.
A file descriptor is the unique identifier used to access files (including pipes, sockets, and other file operations) in Unix systems.
For FineReport projects, you are advised to set the open_files parameter to greater than 65536.
For FineBI projects, you are advised to set the open_files parameter to greater than 131070.
1. Delete system-level restrictions.
Check whether there are statements related to ulimit -n xxx in /etc/profile.
If relevant statements exist, delete those statements and reload the shell environment using the source/etc/profile statement.
2. Modify user-level restrictions.
Open the software and hardware restriction file /etc/security/limits.conf on Linux and add the following code at the end of the file:
* soft nofile 65536* hard nofile 65536
In the above command, hard represents the system's hard limit, and soft represents the user's soft limit.
On some systems, replacing * with a specific username (for example, root soft nofile 128000) may be required for the changes to take effect.
3. Load the pam_limits.so module.
Open the login file (/etc/pam.d/login) and ensure it contains the following line (typically located in the session section):
If the line does not exist, add it. If it exists but is commented out (starting with #), uncomment it.
session required pam_limits.so
This operation ensures that when a user logs in to the terminal, the system loads the pam_limits.so module, thereby applying the resource limits defined in limits.conf.
4. Restart the project and log in again.
After the configuration is completed, the terminal user logs in again and restarts the Tomcat project to make the configuration effective.
You can use the ulimit -n command to confirm whether the modification is successful based on the returned value.
vm.overcommit_memory is a Linux kernel parameter used to control whether the system allows a process to allocate more memory than is available.
When the parameter value is 0, the kernel will check whether there is enough free memory to satisfy the submitted memory request. If there is enough free memory, the process is allowed to continue allocating memory. Otherwise, the allocation request will fail, and an error will be returned.
1. Add/Modify the parameter value in etc/sysctl.conf.
vm.overcommit_memory=0
2. Run the command sysctl -p for the modification to take effect.
vm.overcommit_ratio is a Linux kernel parameter that specifies the ratio of the system VMware huge page manager (Memory Ballooning) and swap space usage.
When the parameter value is 50, the kernel uses an appropriate space twice the size of the swap partition as another spare space to simulate physical memory.
vm.overcommit_ratio=50
1. Close Tomcat server.
2. Go to Tomcat installation directory/bin and open the startup.sh file.
3. Add/Modify the line at the beginning of the file: export MALLOC_ARENA_MAX = 1.
4. Save the changes to the startup.sh file and close it.
5. Run the startup.sh file in the terminal to restart Tomcat and apply the new environment variable settings.
When the Redis eviction policy is set to noeviction, Redis will not evict any existing data upon the maximum memory limit is reached, and will reject new write operations (such as write commands and data updates).
Using this policy ensures that all data is never automatically deleted, thereby maintaining data integrity and avoiding data loss due to insufficient memory.
Locate the redis.conf configuration file in the Redis installation directory, find maxmemory-policy, and set it to noeviction.
After modification, restart the Redis service to apply the change.
In Linux systems, nproc represents the maximum number of processes that a user can start. This limit is typically set at the system level but can also be configured per user.
If the nproc value is set too low, reaching the limit may prevent applications from starting new processes, affecting user experience or system functionality.
Set the maximum process count (nproc) to a value not less than 266240.
Edit the limits.conf file located in /etc/security/ or /etc/ as the root user.
Add or modify the following lines, where soft is the soft limit, which serves as the default value, and hard is the hard limit, representing the maximum allowed value.
# Set nproc limit for a specific user.Username soft nproc 266240Username hard nproc 266240# Set nproc limit for all users.* soft nproc 10240* hard nproc 266240
Items of Java VM Check include:
Check Item Code
Check Item
FineBI - Application Node: 1536 MB ≤ Configuration ≤ 2 GB
Engine - Calculation Node: Configuration ≥ max(6 GB, Xmx value * 0.4 GB)
Engine - Metadata Node: Configuration ≥ 768 MB
FineReport and FineDataLink: Configuration ≤ 2 GB
For the bi6 container, where the minor version of FineBI is V6.0.16 or later: Configuration ≥ (Xmx value * 0.4) GB
For the bi6 container, where the minor version of FineBI is older than V6.0.16: Configuration ≥ 4 GB
1. FineBI - Application Node/FineReport/FineDataLink
Use the ParallelScavenge garbage collector for the JVM.
2. Engine - Calculation Node/Engine - Metadata Node
Use the ParallelScavenge garbage collector for the JVM if JDK 8 is used.
Use the G1GC garbage collector for the JVM if JDK 11 is used.
Healthy: The DisableExplicitGC parameter is not configured.
Unhealthy: The DisableExplicitGC parameter is configured.
Suggestion: Remove the DisableExplicitGC parameter.
FineBI - Application Node/FineReport/FineDataLink: Use JDK8 with a minor version of 202 or later.
Engine - Calculation Node/Engine - Metadata Node: Use JDK11, or JDK8 with a minor version of 202 or later.
Healthy: -Djava.awt.headless=true is configured.
Unhealthy: -Djava.awt.headless=true is not configured.
Suggestion: Configure -Djava.awt.headless=true to enable the headless mode.
Healthy: HeapDumpOnOutOfMemoryError and HeapDumpPath are configured.
Unhealthy: HeapDumpOnOutOfMemoryError and HeapDumpPath are not configured.
Suggestion: Configure HeapDumpOnOutOfMemoryError and HeapDumpPath to ensure the normal dump file exports.
Healthy: -XX:PerBytecodeRecompilationCutoff = -1
Unhealthy: -XX:PerBytecodeRecompilationCutoff ≠ -1
Suggestion: Configure -XX:PerBytecodeRecompilationCutoff = -1.
Healthy: -XX:PerMethodRecompilationCutoff = -1
Unhealthy: -XX:PerMethodRecompilationCutoff ≠ -1
Suggestion: Configure -XX:PerMethodRecompilationCutoff = -1.
Healthy: The project is not deployed using an EXE file.
Unhealthy: The project is deployed using an EXE file.
Suggestion: Use FineOps for deployment.
FineReport/FineDataLink: CodeCacheSize ≥ 512 MB
bi6: -XX:ReservedCodeCacheSize ≥ 1024 MB
FineBI - Application Node:
CodeCacheSize ≥ 768 MB
If the container memory limit is between 6 GB and 8 GB, set the CodeCacheSize value to at least 768 MB.
If the container memory limit exceeds 8 GB, set the CodeCacheSize value to at least 1 GB.
Engine - Calculation Node:
If the container memory limit is between 32 GB and 64 GB, set CodeCacheSize be to at least 1 GB.
Engine - Metadata Node:
CodeCacheSize ≥ 256 MB
If the container memory limit is between 6 GB and 16 GB, set the CodeCacheSize value to at least 256 MB.
If the container memory limit is between 16 GB and 32 GB, set the CodeCacheSize value to at least 512 MB.
If the container memory limit exceeds 32 GB, set the CodeCacheSize value to at least 1 GB.
Healthy: The -Duser.country value is the code of the region where the server is located.
Unhealthy: The -Duser.country value is not the code of the region where the server is located.
Suggestion: Set -Duser.country to the code of the region where the server is located.
Healthy: The -Duser.language value is the language code of the region where the server is located.
Healthy: The -Duser.language value is not the language code of the region where the server is located.
Suggestion: Set -Duser.language to the language code of the region where the server is located.
Healthy: -Dsun.zip.disableMemoryMapping=true
Unhealthy: -Dsun.zip.disableMemoryMapping ≠ true
Suggestion: Configure -Dsun.zip.disableMemoryMapping=true
Healthy: -XX:NewRatio=2
Unhealthy: -XX:NewRatio ≠ 2
Suggestion: Set the ratio of the old generation to the young generation to 2, namely, -XX:NewRatio=2.
Healthy: -Xss value ≤ 1024 KB
Unhealthy: -Xss value > 1024 KB
Suggestion: Set the stack size per thread (Xss value) to no more than 1024 KB.
Healthy: Parameters -agentlib:jdwp and -Xrunjdwp are not configured.
Unhealthy: Parameters -agentlib:jdwp and -Xrunjdwp are configured.
Suggestion: Remove the -agentlib:jdwp and -Xrunjdwp parameters to disable the debug mode.
Healthy:
FineReport/FineDataLink/bi6: Configuration ≤ 32766 MB or ≥ 48 GB
FineBI - Application Node: 6 GB ≤ Configuration ≤ 32766 MB
Engine - Calculation Node: 12800 MB ≤ Configuration ≤ 32766 MB
Engine - Metadata Node: 2420 MB ≤ Configuration ≤ 32766 MB
To ensure application responsiveness, you are advised to set on-heap memory to 32766 MB or less.
For the bi6 container, you can set it to 48 GB to 64 GB if larger memory is required, provided that the physical machine has sufficient memory. However, this may result in degradation in responsiveness.
Healthy: Xms value = Xmx value
Unhealthy: Xms value ≠ Xmx value
Suggestion: Set the value of Xms to the same as that of Xmx.
FineReport/FineDataLink/bi6:
MaxMetaspaceSize value ≥ 2 GB
MaxMetaspaceSize value ≥ 768M
If the container memory limit is between 6 GB and 8 GB, set the MaxMetaspaceSize value to at least 768 MB.
If the container memory limit exceeds 8 GB, set the MaxMetaspaceSize value to at least 1 GB.
If the container memory limit is between 32 G and 64 GB, set the MaxMetaspaceSize value to at least 1 GB.
MaxMetaspaceSize value ≥ 256 MB
If the container memory limit is between 6 GB and 16 GB, set the MaxMetaspaceSize value to at least 256 MB.
If the container memory limit is between 16 GB and 32 GB, set the MaxMetaspaceSize value to at least 512 MB.
If the container memory limit exceeds 32 GB, set the MaxMetaspaceSize value to at least 1 GB.
Healthy: Available disk space in the dump output directory > Heap memory * 2
Unhealthy: Available disk space in the dump output directory ≤ Heap memory *2
Suggestion: Free up disk space in the dump output directory and ensure the available space is at least twice the heap memory size for normal dump file exports.
1. Recommended Value
FineReport
FineDataLink
2. Modification Method
NIO is controlled by the -XX:MaxDirectMemorySize parameter. Choose the modification method according to your project deployment methods.
This parameter is configured for FineOps-deployed projects by default. Normally, you do not need to fix it.
If any exception occurs, log in to FineOps, click the specific project, choose Health Inspection > System Inspection, and click the Quick Fix button.
If Quick Fix is unavailable, modify the project component configuration under Maintenance > Component Management.
Non-FineOps deployed projects
Operating system: Linux
Middleware type: Tomcat
If the project is managed by FineOps, you are advised to use the Quick Fix button on the System Inspection page of FineOps to resolve the issue.
If the project is not managed by FineOps, you are advised to log in to the FanRuan application, choose System Management > Intelligent O&M > Health Inspection, and use the Quick Fix button to resolve the issue.
If you do not have the required permission to create, read, or write files and therefore cannot use Quick Fix, you can manually configure the setting as follows:
1. Open the setenv.sh file in Tomcat installation directory/bin.
Create a setenv.sh file if the file does not exist.
2. Append the following line to the end:
JAVA_OPTS="$JAVA_OPTS -XX:MaxDirectMemorySize=2g"
3. Restart the project to apply the change.
Operating system: Windows
1. Open the setenv.bat file in Tomcat installation directory/bin.
Create a setenv.bat file if the file does not exist.
set JAVA_OPTS=%JAVA_OPTS% -XX:MaxDirectMemorySize=2g
Set the off-heap memory allocated for FineIO read operations to at least 2 GB in the JVM settings.
FineIO read memory is controlled by the -Dfineio.read_mem_limit parameter. Choose the modification method according to your project deployment methods.
The default unit of read memory is GB, and decimal values are supported, but g and m are not supported. You are advised to set the read memory to 2 to 3 times the write memory, and set the cache size to match the write memory size.
This parameter is configured for bi6/fr/fdl containers of FineOps-deployed projects by default. Normally, you do not need to fix it.
JAVA_OPTS="$JAVA_OPTS -Dfineio.read_mem_limit=2"
set JAVA_OPTS=%JAVA_OPTS% -Dfineio.read_mem_limit=2
Set the off-heap memory allocated for FineIO write operations to at least 1 GB in the JVM settings.
FineIO write memory is controlled by the -Dfineio.write_mem_limit parameter. Choose the modification method according to your project deployment methods.
The default unit of write memory is GB, and decimal values are supported, but g and m are not supported. You are advised to set the read memory to 2 to 3 times the write memory, and set the cache size to match the write memory size.
JAVA_OPTS="$JAVA_OPTS -Dfineio.write_mem_limit=1"
set JAVA_OPTS=%JAVA_OPTS% -Dfineio.write_mem_limit=1
Use the G1GC garbage collector for the JVM if JDK 11 is used by default.
This section introduces how to set the garbage collector type to ParallelScavenge.
If you need to set it to G1GC, change ParallelGC in the following statement to G1GC.
1. Go to the Project mounting directory/fanruanxxx/fr/mount path and open the setenv.sh file.
2. Append the following line to the end or modify it:
JAVA_OPTS="$JAVA_OPTS -XX:+UseParallelGC"
set JAVA_OPTS=%JAVA_OPTS% -XX:+UseParallelGC
The -XX:+DisableExplicitGC parameter disables System.gc() calls. System.gc() serves as a safeguard mechanism, which can, for example, clean up heap-internal reference objects when off-heap memory is exhausted.
You are advised not to configure the DisableExplicitGC parameter, as enabling it disables System.gc() and may affect system stability.
This section introduces how to remove the DisableExplicitGC parameter.
This parameter is not configured for FineOps-deployed projects by default. Normally, you do not need to fix it.
1. Open the catalina.sh and setenv.sh files in Tomcat installation directory/bin.
2. Delete the XX:+DisableExplicitGC configuration (if any).
3. Save the change and restart the project to apply the change.
1. Open the catalina.bat and setenv.bat files in Tomcat installation directory/bin.
FanRuan application components (FineBI - Application Node/FineReport/FineDataLink)
Use JDK8 with a minor version of 202 or later.
FineBI calculation engine component ( Engine - Calculation Node/Engine - Metadata Node)
JDK11 is used by default and recommended.
JDK8 with a minor version of 202 or later is supported.
2. Check Method
This section only introduces how to check the JDK version. If your version does not meet the requirements, refer to the documents of the relevant products to upgrade/reinstall the JDK product.
FineOps-deployed projects
Projects deployed using the server deployment package provided by FanRuan
Command:
java -version
The headless mode is a working mode of the system. If the system property java.awt.headless is set to true, the headless toolkit is used.
You are advised to configure -Djava.awt.headless=true to enable the headless mode.
This section introduces the steps of enabling the headless mode.
JAVA_OPTS="$JAVA_OPTS -Djava.awt.headless=true"
set JAVA_OPTS=%JAVA_OPTS% -Djava.awt.headless=true
Configure HeapDumpOnOutOfMemoryError and HeapDumpPath for normal dump file exports.
The -XX:+HeapDumpOnOutOfMemoryError parameter causes the JVM to automatically generate a dump file when an OutOfMemoryError occurs. ·
The -XX:HeapDumpPath=${Directory} configuration specifies the path where the dump file will be generated. You can also specify a file name, for example, -XX:HeapDumpPath=${Directory}/java_heapdump.hprof.
If no file name is specified, the default name is java_<PID>_<Date>_<Time>_heapDump.hprof.
This section introduces the configuration for dump file exports.
2. Append the following line to the end.
JAVA_OPTS="$JAVA_OPTS -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=/Heap dump storage directory"
set JAVA_OPTS=%JAVA_OPTS% -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=/Heap dump storage directory
This parameter should be modified together with PerMethodRecompilationCutoff. For details, see the next section.
If the RecompilationCutoff-related parameters are not configured or their values are set too low, the spider engine may experience slow data updates.
You are advised to set the value of RecompilationCutoff-related parameters to -1.
This section introduces how to configure recompilationCutoff-related parameters.
JAVA_OPTS="$JAVA_OPTS -XX:PerMethodRecompilationCutoff=-1 -XX:PerBytecodeRecompilationCutoff=-1"
set JAVA_OPTS=%JAVA_OPTS% -XX:PerMethodRecompilationCutoff=-1 -XX:PerBytecodeRecompilationCutoff=-1
Deploying FineBI projects via FineOps is preferred. For details, see New Project Deployment.
The ReservedCodeCacheSize parameter is used to adjust the memory size, directly affecting the Code Cache size.
If the Code Cache space is insufficient, the JVM may fail to operate properly, leading to sustained performance degradation.
You are advised to configure -XX:ReservedCodeCacheSize based on the system inspection results.
This section introduces how to modify the ReservedCodeCacheSize configuration.
JAVA_OPTS="$JAVA_OPTS -XX:ReservedCodeCacheSize=512m"
set JAVA_OPTS=%JAVA_OPTS% -XX:ReservedCodeCacheSize=512m
This parameter should be modified together with the - Duser.language parameter. For details, see the next section.
Configure it according to the server location.
JAVA_OPTS="$JAVA_OPTS -Duser.country=Country code -Duser.language=Language code"
set JAVA_OPTS=%JAVA_OPTS% -Duser.country=Country code -Duser.language=Language code
Configuring this parameter can prevent JVM crashes.
You are advised to configure -Dsun.zip.disableMemoryMapping=true.
2. Add the following code to the file:
JAVA_OPTS="$JAVA_OPTS -Dsun.zip.disableMemoryMapping=true"
set JAVA_OPTS=%JAVA_OPTS% -Dsun.zip.disableMemoryMapping=true
The recommended ratio of the old generation to the new generation is 2. (-XX:NewRatio value defaults to 2 for JVM.) For the NewRatio setting to take effect properly, the young generation size cannot be explicitly limited.
Add the NewRatio value in the same location where the -Xmx and -Xms parameters are set. This section describes the steps to configure NewRatio.
2. Add the NewRatio value in the same location where the -Xmx and -Xms parameters are set. For example:
JAVA_OPTS="$JAVA_OPTS -Xms2048M -Xmx8196M -XX:NewRatio=2"
set JAVA_OPTS=%JAVA_OPTS% -Xms512M -Xmx1024M -XX:NewRatio=2
Set the stack size per thread to no more than 1024 KB. That is, the -Xss value should not exceed 1024.
Add the -Xss value in the same location where the -Xmx and -Xms parameters are set. This section describes the steps to configure -Xss.
2. Add the -Xss value in the location where the -Xmx and -Xms parameters are set. For example:
JAVA_OPTS="$JAVA_OPTS -Xms2048M -Xmx8196M -Xss1024K"
set JAVA_OPTS=%JAVA_OPTS% -Xms512M -Xmx1024M -1024K
The debug mode is controlled by -agentlib:jdwp and -Xrunjdwp parameters. Removing these two parameters disables the debug mode.
You are advised to disable the debug mode.
This section introduces how to disable the debug mode.
2. Remove the relevant configuration of -agentlib:jdwp and -Xrunjdwp parameters (if any).
This parameter should be modified together with Xms. For details, see the next section.
1. Parameter Description
-Xmx: Maximum on-heap memory size
-Xms: Initial memory size
1. Do not include a space between -Xmx/-Xms and their values.
2. You are advised to set the values of Xms and Xmx to the same value to prevent memory expansion failures.
If you do not have the required permission to create, read, or write files and therefore cannot use Quick Fix, you can manually modify the memory settings by referring to Modifying Memory Settings.
Middleware type: Others
Memory Modification for the WebLogic Server
Memory Modification for the WebSphere Server
Memory Modification for the Resin Server
Memory Modification for the JBoss Server
1. Parameter Introduction
Metaspace is the region in the JVM used to store class metadata. In the JVM, metadata includes class structure information, method information, field information, and so on.
The MaxMetaspaceSize parameter is used to set the maximum size of Metaspace. If Metaspace exceeds this limit, the JVM triggers garbage collection to release metadata that is no longer in use.
2. Recommended Configuration
Configure -XX:MaxMetaspaceSize based on the system inspection results.
3. Modification Method
This section introduces how to configure the MaxMetaspaceSize parameter.
JAVA_OPTS="$JAVA_OPTS -XX:MaxMetaspaceSize=2G"
set JAVA_OPTS=%JAVA_OPTS% -XX:MaxMetaspaceSize=2G
Items of Service Connection Inspection include:
0901
Redis Connection
It checks whether the project and the redis component are connected.
0902
File Server Connection
It checks whether the project and the file server component are connected.
0903
FineDB Connection
It checks whether the project and the FineDB database are connected.
Items of Business Inspection include:
finedb
It checks the type of the FineDB database.
Healthy: The FineDB database is migrated to an external database.
Unhealthy: The FineDB database uses the built-in HSQL database.
Suggestion: You are advised to migrate FineDB to a more stable external database.
Log Level
It checks System Log Level under System Management > Intelligent O&M > Platform Log > Global Setting.
Healthy: The log level is higher than the DEBUG level.
Unhealthy: The log level is the DEBUG level.
Suggestion: You are advised to set the log level to INFO.
Log Cleanup
It checks the Clearance Frequency under System Management > Intelligent O&M > Platform Log > Global Setting > Auto Cleanup.
Healthy: Auto Cleanup is configured and logs older than three months are automatically cleaned up.
Unhealthy: Auto Cleanup is not configured.
Suggestion: You are advised to enable the automatic cleaning of platform logs and set a cleaning cycle of less than six months.
Limit of Disk Space Occupied by Automatic Backup
It checks the value of Maximum Disk Space Occupied by Automatic Backup Records Per Module under System Management > Intelligent O&M > Backup & Restoration > Global Setting.
Healthy: The value of Maximum Disk Space Occupied by Automatic Backup Records Per Module is no more than 1024 MB.
Unhealthy: The value of Maximum Disk Space Occupied by Automatic Backup Records Per Module is more than 1024 MB.
Suggestion: You are advised to set the value of Maximum Disk Space Occupied by Automatic Backup Records Per Module to no more than 1024 MB.
Quantity Limit of Automatic Backup Records Retained
It checks the value of Maximum Number of Successful/Failed Automatic Backup Records Per Module under System Management > Intelligent O&M > Backup & Restoration > Global Setting.
Healthy: The value of Maximum Number of Successful/Failed Automatic Backup Records Per Module is no more than 5 records.
Unhealthy: The value of Maximum Number of Successful/Failed Automatic Backup Records Per Module is more than 5 records.
Suggestion: You are advised to set the value of Maximum Number of Successful/Failed Automatic Backup Records Per Module to no more than 5 records.
Scheduled Task Cleanup Configuration
It checks the settings of File Processing under Task Schedule > Schedule Object.
Healthy: Retain Only Latest 1 Times or Clear Upon Task End.
Unhealthy: other file processing methods
Suggestion: You are advised to set the scheduling object file processing of scheduled tasks to Retain Only Latest 1 Times.
Row Quantity Limit of Memory Data
It checks the value of the Data Access Volume parameter under System Management > System Setting > BI Parameter > Restriction Parameter.
Healthy: The value of Data Access Volume is no more than 1000000.
Unhealthy: The value of Data Access Volume is more than 1000000.
Suggestion: You are advised to set the value of Data Access Volume to no more than 1000000.
Cell Quantity Limit for Quick Calculation
It checks the value of the spider_fast_compute_limit_unit parameter.
Healthy: The value of the DistributedOptimizationConfig.spiderConfig.spider_fast_compute_limit_unit parameter is no more than 10000000.
Unhealthy: The value of the DistributedOptimizationConfig.spiderConfig.spider_fast_compute_limit_unit parameter is more than 10000000.
Memory Limit for Quick Calculation
It checks the value of the spider_fast_compute_limit_memory parameter.
Healthy: The value of the DistributedOptimizationConfig.spiderConfig.spider_fast_compute_limit_memory parameter is no more than 500000000.
Unhealthy: The value of the DistributedOptimizationConfig.spiderConfig.spider_fast_compute_limit_memory parameter is more than 500000000.
Updated Cell Quantity Limit for Quick Calculation
This item is only inspected for FineBI projects.
It checks the value of the spider_update_fast_compute_limit_cell parameter.
Healthy: the value of the DistributedOptimizationConfig.spiderConfig.spider_update_fast_compute_limit_cell parameter is no more than 100000000.
Unhealthy: the value of the DistributedOptimizationConfig.spiderConfig.spider_update_fast_compute_limit_cell parameter is more than 100000000.
Row Quantity Limit for Quick Calculation
Healthy: The value of the DistributedOptimizationConfig.spiderConfig.spider_fast_compute_limit_row parameter is no more than 10000000.
Unhealthy: The value of the DistributedOptimizationConfig.spiderConfig.spider_fast_compute_limit_row parameter is more than 10000000.
Memory Limit of Spark Calculation Result
It checks the value of the spiderConfig.spark_driver_maxResultSize parameter.
Healthy: The value of the DistributedOptimizationConfig.spiderConfig.spark_driver_maxResultSize parameter is no more than 10000000.
Unhealthy: The value of the DistributedOptimizationConfig.spiderConfig.spark_driver_maxResultSize parameter is more than 10000000.
1013
Memory Limit of Spark
It checks the value of the spark_memory_fracrtion parameter.
Suggestion: You are advised to set the value of spark_memory_fraction to no more than 0.3 * 1/8 of the on-heap memory and no more than 0.6.
Encoding/Character Set of External Database
It includes the encoding/character set of the FineDB external database.
For details about configuring the external database, see External Database Configuration.
Cluster Parameter Configuration
It checks the values of Internal Forwarding Parameter under System Management > Intelligent O&M > Cluster Configuration > Parameter Configuration.
Unlimited Period Configuration for Resource Update
It checks the value of the Update High Performance Time Interval parameter under System Management > System Setting > BI Parameter > Data Update Configuration.
For details about configuring BI parameters, see BI/Spider Parameter.
Second-Level Cache Enabling Status
It checks whether the system is configured with the second-level cache.
For details about enabling and configuring the second-level cache, see Specifying the Ehcache Cache Path.
SQL Execution Period Limit
It checks the value of SQL Execution Period Limit under System Management > Intelligent O&M > Load Management > Template Limit > General Limit.
Healthy: SQL Execution Period Limit is enabled.
Unhealthy: SQL Execution Period Limit is not enabled.
Suggestion: You are advised to enable SQL Execution Period Limit under System Management > Intelligent O&M > Load Management > Template Limit > General Limit.
Cell Quantity Limit Per Template
It checks the value of Template Cell Limit under System Management > Intelligent O&M > Load Management > Template Limit > General Limit.
Healthy: Template Cell Limit is enabled.
Unhealthy: Template Cell Limit is not enabled.
Suggestion: You are advised to enable Template Cell Limit under System Management > Intelligent O&M > Load Management > Template Limit > General Limit.
Cell Quantity Limit During Excel Import
It checks the value of Excel Import Limit under System Management > Intelligent O&M > Load Management > Template Limit > General Limit.
Healthy: Excel Import Limit is enabled.
Unhealthy: Excel Import Limit is not enabled.
Suggestion: You are advised to enable Excel Import Limit under System Management > Intelligent O&M > Load Management > Template Limit > General Limit.
Row Quantity Limit Per Dataset
It checks the value of Dataset Row Limit under System Management > Intelligent O&M > Load Management > Template Limit > General Limit.
Healthy: Dataset Row Limit is enabled.
Unhealthy: Dataset Row Limit is not enabled.
Suggestion: You are advised to enable Dataset Row Limit under System Management > Intelligent O&M > Load Management > Template Limit > General Limit.
Load Alert Enabled
It checks whether Intelligent Alert under System Management > Intelligent O&M > Load Management > Load Surveillance is enabled.
Dirty Data Detection
It checks whether there is dirty data.
Healthy: There is 0 piece of dirty data.
Unhealthy: There are x piece(s) of dirty data.
Suggestion: If there are x piece(s) of dirty data, you are advised to choose BI Tool > Detection > Dirty Data to check and clean them up.
Whether to enable cloud operation and maintenance
It checks whether the system enables cloud operation and maintenance.
Password Strength Limit Check
It checks whether Password Strength Limit under System Management > System Setting > Login is enabled.
Healthy: Password Strength Limit is enabled.
Unhealthy: Password Strength Limit is not enabled.
Suggestion: Password Strength Limit is not enabled, which may cause your account to be vulnerable to attack due to weak password strength and incur security problems. You are advised to enable Password Strength Limit under System Management > System Setting > Login.
1027
Limit on Submitted Record Quantity
It checks whether Record Submission Limit under System Management > Intelligent O&M > Load Management > Template Limit is enabled.
Healthy: Record Submission Limit is enabled.
Unhealthy: Record Submission Limit is not enabled.
Suggestion: You are advised to enable Record Submission Limit under System Management > Intelligent O&M > Load Management > Template Limit > General Limit.
1028
Data Export Volume Limit Per Chart
It checks whether Data Export Volume Limit Per Chart under System Management > Intelligent O&M > Load Management > Template Limit is enabled.
Healthy: Data Export Volume Limit Per Chart is enabled.
Unhealthy: Data Export Volume Limit Per Chart is not enabled.
Suggestion: You are advised to enable Data Export Volume Limit Per Chart under System Management > Intelligent O&M > Load Management > Template Limit > General Limit.
1029
Template Limit Relaxation
It checks whether Limit Relaxation under System Management > Intelligent O&M > Load Management > Template Limit is configured.
Healthy: No individual limit is relaxed.
Unhealthy: Limits are relaxed for some templates.
Suggestion: You are not advised to relax the limit on templates as they may take up excessive system resources and cause crashes.
1030
Enable Extracted Data Cache
It checks whether Enable Cache is turned on under System Management > Extracted Data Cache.
Healthy: Enable Cache is turned on.
Unhealthy: Enable Cache is not turned on.
Suggestion: You are advised to turn on Enable Cache under System Management > Extracted Data Cache.
1031
Cache Space Limit
It will be checked only after Extracted Data Cache mentioned in the previous step is enabled.
It checks the value of Cache Memory Limit under System Management > Extracted Data Cache.
1032
Enable Parallel Dashboard Calculation
It checks whether Parallel Calculation of Report Block under System Management > System Setting > General is enabled.
Healthy: Parallel Calculation of Report Block is enabled.
Unhealthy: Parallel Calculation of Report Block is not enabled.
Suggestion: You are advised to enable Parallel Calculation of Report Block under System Management > System Setting > General > Global Setting of Dashboard Calculation.
1033
Enable Crash Handling Tool
It checks whether Auto Crash Handling under System Management > Intelligent O&M > Crash Handling > Auto Crash Handling Tool is enabled.
Healthy: Auto Crash Handling is enabled.
Unhealthy: Auto Crash Handling is not enabled.
Suggestion: You are advised to enable Auto Crash Handling under System Management > Intelligent O&M > Crash Handling > Auto Crash Handling Tool.
1034
Automatic Stack Export of Auto Carsh Handling Tool
It checks whether Auto Memory Stack Export under System Management > Intelligent O&M > Crash Handling > Auto Crash Handling Tool is enabled.
Healthy: Auto Memory Stack Export is enabled.
Unhealthy: Auto Memory Stack Export is not enabled.
Suggestion: You are advised to enable Auto Memory Stack Export under System Management > Intelligent O&M > Crash Handling > Auto Crash Handling Tool.
1035
Lifecycle Setting
1036
Spark Memory Ratio
It checks the value of the following parameter in the system:
DistributedOptimizationConfig.spiderConfig.spark_memory_fraction.
1037
Update Relevant Configuration
It checks the value of the following parameters in the system:
SystemOptimizationConfig.spiderConfig.threadPoolStrategy
SystemOptimizationConfig.tableLoadThreadPoolNum
DistributedOptimizationConfig.spiderConfig.spider_high_performance_resource_time
SystemOptimizationConfig.baseTableLoadDynamicThreadCoreSizeStr
SystemOptimizationConfig.fastTableLoadDynamicThreadCoreSizeStr
1038
Update SQL Complexity Limit
systemOptimizationConfig.optimizeSqlMaxComplexity.
For FineReport of versions earlier than V11.0.21 and FineBI of versions earlier than V6.0.15, Gzip compression is disabled.
For FineReport of V11.0.21 and later versions and FineBI of V6.0.15 and later versions, the status is healthy regardless of whether Gzip compression is enabled.
Unhealthy:
For FineReport of versions earlier than V11.0.21 and FineBI of versions earlier than V6.0.15, Gzip compression is enabled.
Disable Gzip compression or upgrade the project to FineReport V11.0.21/FineBI V6.0.15 or later versions. Otherwise, system crashes may occur.
DistributedOptimizationConfig.spiderConfig.spider_query_timeout_open
ExecuteRecordConfiguration.asyncRecord
DistributedOptimizationConfig.spiderConfig.spark_sql_constraintPropagation_enabled
DistributedOptimizationConfig.spiderConfig.spider_restrictions_column_long_text
DistributedOptimizationConfig.spiderConfig.spider_query_condition_count_restriction
SystemOptimizationConfig.shutdownCacheEngine
Healthy: The default connection pool size of the external configuration database is greater than or equal to 100.
Unhealthy: The default connection pool size of the external configuration database is less than 100.
Suggestion: Set the default connection pool size of the external configuration database to 100. (For specific configuration instructions, refer to the help document of the corresponding database product.)
It checks whether the week start settings are consistent across all FineBI - Application Node, Engine - Calculation Node, and Engine - Metadata Node components.
Healthy: Chinese sorting settings are consistent.
Unhealthy: Chinese sorting settings are inconsistent.
It checks whether the Chinese sorting settings are consistent across all FineBI - Application Node, Engine - Calculation Node, and Engine - Metadata Node components.
Healthy: Week start settings are consistent.
Unhealthy: Week start settings are inconsistent.
FineOps relies on the built-in crash handling tool to perform operations such as automatic project restarts and automatic dump generation upon crashes.
Therefore, you must ensure that the crash handling tool is running normally. Otherwise, related functions may be unavailable.
It checks the specified parameter values in the db.properties file of the external configuration database.
If the parameter values do not meet the requirements, it is judged as unhealthy.
In FanRuan applications, administrators typically set up users, mount directories, assign the permission, and configure timed scheduling on the platform. The configuration is stored in the configuration database.
In a production environment, you can prepare a database and connect it with the FanRuan application for configuration storage. A stable external database ensures the stable operation of the FanRuan application under high load.
The database types, versions, and connection methods supported for use as the configuration storage component are listed in the following table.
MySQL 5: 5.1.73, 5.5.31, 5.5.46, 5.5.56, 5.5.62, 5.6.22, 5.6.28, 5.6.31, 5.6.35, 5.6.37, 5.6.44, 5.7.16, 5.7.23, 5.7.26, and 5.7.33
MySQL 8: 8.0.11, 8.0.16, 8.0.20, 8.0.21, and 8.2 (8.0.19 is not supported.)
RDS MySQL: All versions
Oracle standalone: 10g (10.2), 10.2.0.1.0, 11g (11.0.2.1), 11g (11.0.2.4), 11.0.2.4, 11.2.0.2.0, 12c, 12c V12.2, and 19c
Oracle cluster: 11g and 12c
Log in to a FanRuan application as the admin, and choose System Management > Intelligent O&M > Platform Log > Global Setting.
Select INFO from the drop-down list under System Log Level and click Save
Enable Auto Cleanup under Log Cleanup and configure Clearance Frequency to less than 6 Months.
Log in to a FanRuan application as the admin, and choose System Management > Intelligent O&M > Backup & Restoration > Global Setting.
You are advised to set the value of Maximum Disk Space Occupied by Automatic Backup Records Per Module under Auto Backup to no more than 1024 MB. For details, see Backup and Restoration.
You are advised to set the value of Maximum Number of Successful/Failed Automatic Backup Records Per Module under Auto Backup to no more than 5 Record(s). For details, see Backup and Restoration.
Log in to a FanRuan application as the admin, choose System Management > Task Schedule > Schedule Object, and select Retain Only Latest 1 Times under File Processing.
For details, see Task Schedule Setting.
Log in to a FanRuan application as the admin, and choose System Management > System Setting > BI Parameter.
You are advised to set the value of Data Access Volume to no more than 1000000. For details about configuring BI parameters, see BI/Spider Parameter.
Configuration information of Cell Quantity Limit for Quick Calculation is recorded in the fine_conf_entity table of the FineDB database.
Configure the value of the DistributedOptimizationConfig.spiderConfig.spider_fast_compute_limit_unit parameter to no more than 10000000 through the FINE_CONF_ENTITY Visualization Configuration plugin.
Click Save and restart the FineBI project for the configuration to take effect.
Configuration information of Memory Limit for Quick Calculation is recorded in the fine_conf_entity table of the FineDB database.
Configure the value of the DistributedOptimizationConfig.spiderConfig.spider_fast_compute_limit_memory parameter to no more than 500000000 through the FINE_CONF_ENTITY Visualization Configuration plugin.
Configuration information of Updated Cell Quantity Limit for Quick Calculation is recorded in the fine_conf_entity table of the FineDB database.
Configure the value of the DistributedOptimizationConfig.spiderConfig.spider_update_fast_compute_limit_cell parameter to no more than 100000000 through the FINE_CONF_ENTITY Visualization Configuration plugin.
Configuration information of Row Quantity Limit for Quick Calculation is recorded in the fine_conf_entity table of the FineDB database.
Configure the value of the DistributedOptimizationConfig.spiderConfig.spider_fast_compute_limit_row parameter to no more than 10000000 through the FINE_CONF_ENTITY Visualization Configuration plugin.
Configuration information of Memory Size Limit of Spark Calculation Result is recorded in the fine_conf_entity table of the FineDB database.
Configure the value of the DistributedOptimizationConfig.spiderConfig.spark_driver_maxResultSize parameter to no more than 10000000 through the FINE_CONF_ENTITY Visualization Configuration plugin.
Log in to a FanRuan application as the admin, and choose System Management > Intelligent O&M > Load Management > Template Limit > General Limit.
You are advised to enable SQL Execution Period Limit. For details, see Template Limit.
You are advised to enable Template Cell Limit. For details, see Template Limit.
You are advised to enable Excel Import Limit. For details, see Template Limit.
You are advised to enable Dataset Row Limit. For details, see Template Limit.
Log in to a FanRuan application as the admin, and choose BI Tool > Detection > Dirty Data.
Detect, check, and clean up the dirty data in the system.
Log in to a FanRuan application as the admin, and choose System Management > System Setting > Login.
You are advised to enable Password Strength Limit under Password Policy Setting and customize the password strength.
Log in to a FanRuan application as the admin, and choose System Management > Intelligent O&M > Load Management.
You are advised to enable Record Submission Limit under Template Limit.
For details, see Template Limit.
You are advised to enable Data Export Volume Limit Per Chart under Template Limit.
You are not advised to enable Limit Relaxation under Template Limit for some templates.
Log in to a FanRuan application as the admin, and choose System Management > Extracted Data Cache. You are advised to turn on Enable Cache.
For details, see Extracted Data Cache.
Log in to a FanRuan application as the admin, and choose System Management > System Setting.
You are advised to enable Parallel Calculation of Report Block under General.
Log in to a FanRuan application as the admin, and choose System Management > Intelligent O&M > Crash Handling.
You are advised to enable Auto Crash Handling under Automatic Crash Handling Tool.
For details, see Downtime Handling.
You are advised to enable Auto Export Memory Stack under Automatic Crash Handling Tool.
1. The preferred solution is to upgrade the project to FineReport V11.0.21/FineBI V6.0.15 or later versions. After the upgrade, you can decide whether to enable Gzip compression as needed.
2. If an upgrade is impossible, log in to the FanRuan application, choose System Management > System Setting > General, disable Gzip Compression, and click Save.
Operation logs of FanRuan applications are stored in LogDB (swift) by default.
In a cluster environment with three or more nodes, if the project’s average daily visits in the current month exceed 10,000, you are advised to use Elasticsearch instead of LogDB for operation log storage to avoid performance issues and crashes.
Premium users should prepare their own Elasticsearch and contact FanRuan technical support for assistance with the migration. For details about how to contact technical support, see Technical Support Channel Introduction.
It checks whether the week start settings are completely consistent across all FineBI - Application Node, Engine - Calculation Node, and Engine - Metadata Node components in FineBI of V6.1 and later versions.
1. Modifying the Week Start Day for FineBI - Application Node
Log in to FineBI as the admin, choose System Management > System Setting > General.
Set Week Start from to Sunday or Monday.
2. Modifying the Week Start Day for Engine - Calculation Node
Log in to FineOps as the admin and click the required project. Choose Maintenance > Component Management.
Locate the Engine - Calculation Node component, click the Modify Configuration button, and set Week Start Day to sunday or monday.
It checks whether the Chinese sorting settings are consistent across all FineBI - Application Node, Engine - Calculation Node, and Engine - Metadata Node components in FineBI of V6.1 and later versions.
1. Modifying the Chinese Sorting Setting for FineBI - Application Node
Log in to FineBI as the admin, and choose System Management > System Setting > BI Parameter.
You can enable/disable Chinese sorting in Basic Function Configuration.
Disabled: Sorting is performed based on the binary representation (byte values) of the characters.
Enabled: Sorting is performed by converting Chinese characters to their phonetic spelling and then sorting the text in alphabetical order.
2. Modifying the Chinese Sorting Setting for Engine - Calculation Node and Engine - Metadata Node.
Locate the corresponding component, click the Modify Configuration button, and modify Sort Setting.
bytes: It disables Chinese sorting. Sorting is performed based on the binary representation (byte values) of the characters.
pinyin: It enables Chinese sorting. Sorting is performed by converting Chinese characters to their phonetic spelling and then sorting the text in alphabetical order.
If the crash handling tool is detected to be running abnormally, see Ensuring Availability of the Crash Handling Tool.
It checks the specified parameter values in the db.properties file of the external configuration database. If the parameter values do not meet the requirements, the status is considered unhealthy.
1. Health Standard
1. The parameter names listed in the following table generally do not include the hibernate. prefix. The parameters are supported for reading whether or not the prefix is present. If both forms coexist, the one without the prefix takes precedence.
2. traceSessionLeak and -DtraceSessionLeak refer to the same parameter. The value of -DtraceSessionLeak is read first when both are present.
Minimum number of idle connections in the connection pool
Idle connection recycler validation
With the validation enabled, if the number of idle connections in the connection pool is within the minimum count, and the idle time of connections exceeds the minEvictableIdleTimeMillis value, a keepAlive operation will be performed.
Test before connection
With it enabled, the system validates the connection before acquiring it, which reduces performance.
Validation before returning connections
With it enabled, the system validates the connection before returning it, which reduces performance.
Timeout for validation queries, in seconds
It prevents indefinite waiting when a connection validation times out.
Regular check for idle connection availability
It ensures that connections intended to be kept are usable, addressing scenarios where the database or firewall actively closes long-idle connections.
2. Modification via the db.properties File
You may need to manually modify parameter values in the db.properties file to fix issues.
1. Back up the project.
For FineOps-deployed projects, see Project Backup.
For projects not deployed via FineOps, see Project Backup and Restoration.
2. Stop the project.
For FineOps-deployed projects, see Component Management.
For projects not deployed via FineOps, see Closing or Restarting the FineBI Project.
3. Modify the db.properties file.
Open the db.properties file in Project installation directory/webroot/WEB-INF/config, and change the parameter values based on the table above. Save the changes after modification.
For cluster projects, synchronize the db.properties file for each project node.
4. Start the project.
3. Modification via JVM Parameters
If the -DtraceSessionLeak parameter is detected to be incorrectly set, you need to modify the relevant Tomcat configuration files.
2. Search for the -DtraceSessionLeak parameter. If it exists, modify its value to false.
滑鼠選中內容,快速回饋問題
滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy