Overview
Version
FineBI Version | FINE_CONF_ENTITY Visual Configuration Plugin | Functional Change |
---|---|---|
6.0 | V1.9.8 | / |
6.0.12 | V1.9.18 | Added the MobileConfig.modulesConfigAvailable parameter, which can determine whether to enable the mobile platform module configuration function. |
V1.9.19 | / | |
V1.9.20 | Added the SystemOptimizationConfig.useAllVisibleDataForSentinel parameter, which can determine whether to retain the effects of data alerts on template filtering. |
Function Description
Some platform configuration information is recorded in the fine_conf_entity table of FineDB and can be modified only through table fields.
In this case, FineBI provides the FINE_CONF_ENTITY Visual Configuration plugin for you to safely modify relevant configurations.

Example
Plugin Installation
You can obtain the plugin at https://community.finereport.com/plugin/?id=107.
For details, see Plugin Management.
System Tool
After installation, log in to the FineBI system as the super admin and choose System Management > System Tool (added automatically), as shown in the following figure.

Parameter Configuration
Two configuration methods are supported:
Select Parameter Configuration: allows you to select configurable fine_conf_entity parameters listed in the drop-down box of System Parameter Name (key) and configure the parameter value.
Customize Parameter Configuration: allows you to enter the configurable fine_conf_entity parameter name in System Parameter Name (key) and modify the automatically-displayed parameter value (true). After completion, click Save.
The configurable parameters are the same for the two configuration methods. The following table shows modifiable configuration parameters and their values in the fine_conf_entity table with the FINE_CONF_ENTITY Visual Configuration plugin V1.9.8 and later versions.
Parameter Name | Description | Parameter Value |
---|---|---|
BackupConfig.customKeyLength | Backs up the conf table and customizes the id field length. | Positive integer (default value: 1500). |
BackupConfig.customValueLength | Backs up the conf table and customizes the value field length. | Positive integer (default value: 65536). |
CacheConfig.maxMemSize | Determines the upper limit of the shared dataset cache space. | Non-negative integer (default value: 4194304). |
ClusterTimeMonitorConfig.permitCount | Determines the minimum success times after multiple deviation analyses in a single time deviation detection task of the cluster environment. | Positive integer (default value: 1). |
ClusterTimeMonitorConfig.permitError | Determines the allowed time deviation value (unit: millisecond(s)) in a single time deviation detection task of the cluster environment. | Positive long integer (default value: 10000). |
ClusterTimeMonitorConfig.sumCount | Determines the total times of deviation analysis attempts in a single time deviation detection task of the cluster environment. | Positive integer (default value: 3). |
ConfigVersion.versionOrdinal | Configures the version number. | Default value: the current version number. |
CustomConfig.absPositionOfFloat | Determines whether the floating elements are displayed in absolute positions (namely, not affected by the cell expansion). | Boolean. false (default value): The floating elements are not displayed in absolute positions (namely, not affected by the cell expansion). true: The floating elements are displayed in absolute positions (namely, affected by the cell expansion). |
CustomConfig.columnMatchRuleForWidgetValue | Determines whether data fields are case-sensitive. | case_ignore or case_sensitive. case_ignore (default value): Data fields are case-insensitive. case_sensitive: Data fields are case-sensitive. |
CustomConfig.dataTransType | Defines the transmission type of the frontend template data in the data entry submission and validation requests. | xml or json. xml (default value): The frontend template data is transmitted in the xml string format. json: The frontend template data is transmitted in the json string format. |
CustomConfig.excelAdjustHeight | Determines the row height of the exported data (as Excel files). | Non-negative single precision and floating-point value (default value: 20.1). |
CustomConfig.excelAdjustWidth | Determines the column width of the exported data (as Excel files). | Non-negative single precision and floating-point value (default value: 34.742). |
CustomConfig.exportFullImg4Excel | Determines whether the complete images can be exported when you export data as Excel files. | Boolean. false (default value): The complete images are not exported when you export data as Excel files. true: The complete images are exported when you export data as Excel files. |
CustomConfig.printWidget | Determines whether you can export/print widgets. Currently, only checkbox and checkbox group widgets can be printed. | Boolean. false (default value): You cannot export/print widgets. true: You can export/print widgets. |
CustomConfig.screenScaleEnabled | Determines whether the designer screen scaling function is enabled. | Boolean. false: The designer screen scaling function is disabled. true (default value): The designer screen scaling function is enabled. |
CustomConfig.wordAdjustHeight | Adjusts the row height when you export data as Word files and avoids blank pages if the content height reaches certain threshold value. | Non-negative integer (default value: 2). |
FSConfig.authorizeAttr.postAuthority | Determines whether the function of assigning permissions based on positions is enabled. | Boolean. false (default value): The function of assigning permissions based on positions is disabled. true: The function of assigning permissions based on positions is enabled. |
FSConfig.loginConfig.forceRedirectAfterLogin | Determines whether to forcibly jump to the path http://IP address:Port number/webroot/decision after login. | Boolean. false (default value): The forced jump is not performed after login. true: The forced jump is performed after login. |
FileServerMonitorConfig.messageInterval | Determines the notification frequency of FTP abnormal messages (unit: hour(s)). | Positive long integer (default value: 1). |
FineFocusPointConfig.allowRecordFitInfo | Determines whether the adaptive tracking events can be recorded. | Boolean. false: The adaptive tracking events cannot be recorded. true (default value): The adaptive tracking events can be recorded. |
GcConfig.gcThreshold | Determines the maximum number of storable versions for the template version control (unit: number of files). | Non-negative integer (default value: 300). |
HotBackConf.master | Performs hot backups for the master node configurations. | hostname of the main node. |
HotBackConf.slave | Performs hot backups for the backup node configurations. | hostname of the backup node. |
IntelliLogConfig.expired | Determines the template cache expiration time. | Long integer (default value: 18000). |
IntelliReleaseConfig.defaultCellCount | Determines the default base value of the cell number in pending termination sessions. | Long integer (default value: 1000000). |
IntelliReleaseConfig.highInterruptAgainRate | Kills sessions with the quantity (namely, the default cell number * the parameter value, such as 1000000 * 0.6) in the second intelligent release during the high load. | Non-negative double precision and floating-point value (default value: 0.6). |
IntelliReleaseConfig.highInterruptRate | Kills sessions with the quantity (namely, the default cell number * the parameter value, such as 1000000 * 0.8) in the first intelligent release during the high load. | Non-negative double precision and floating-point value (default value: 0.8). |
IntelliReleaseConfig.highKillRate | Determines whether to trigger the second intelligent release. If the session rate exceeds the parameter value in the first intelligent release during the high load, the second intelligent release is not triggered. | Non-negative double precision and floating-point value (default value: 0.1). |
IntelliReleaseConfig.interruptRate | Determines the default rate of the cell number for the sessions to be killed. | Non-negative double precision and floating-point value (default value: 0.3). |
IntelliReleaseConfig.jvmSupport | Determines whether the Intelligent Release function is supported in the current JDK version. | Boolean. false: The Intelligent Release function is not supported in the current JDK version. true (default value): The Intelligent Release function is supported in the current JDK version. |
IntelliReleaseConfig.releaseSessionInteval | Determines the intervals when the intelligent release is triggered. | Positive integer (default value: 20). |
IntelliReleaseConfig.terribleInterruptAgainRate | Kills sessions with the quantity (namely, the default cell number * the parameter value, such as 1000000 * 0.4) in the second intelligent release during the extremely high load. | Non-negative double precision and floating-point value (default value: 0.4). |
IntelliReleaseConfig.terribleInterruptRate | Kills sessions with the quantity (namely, the default cell number * the parameter value, such as 1000000 * 0.6) in the first intelligent release during the extremely high load. | Non-negative double precision and floating-point value (default value: 0.6). |
IntelliReleaseConfig.terribleKillRate | Determines whether to trigger the second intelligent release. If the session rate exceeds the parameter value in the first intelligent release during the extremely high load, the second intelligent release is not triggered. | Non-negative double precision and floating-point value (default value: 0.2). |
IntelliReleaseConfig.waitInLineRate | Determines the rate of each session being queued during the high load. | Double precision and floating-point value (default value: 0.9). |
JarConsistenceConfig.messageInterval | Determines the notification frequency of abnormal messages due to inconsistent JAR packages (unit: hour(s)). | Positive long integer (default value: 6). |
LoadConfig.majorExtremeTerribleThreshold | Determines whether the system is in the extreme load status. If the ratio of the remaining old generation object size to the old generation size exceeds the parameter value after a major GC (Garbage Collection), the system is in the extreme load status. | Non-negative double precision and floating-point value (default value: 0.95). |
LoadConfig.majorHighThreshold | Determines whether the system is in the high load status. If the ratio of the remaining old generation object size to the old generation size exceeds the parameter value after a major Garbage Collection (hereinafter referred to as GC), the system is in the high load status. | Non-negative double precision and floating-point value (default value: 0.7). |
LoadConfig.majorTerribleThreshold | Determines whether the system is in the extremely high load status. If the ratio of the remaining old generation object size to the old generation size exceeds the parameter value after a major GC, the system is in the extremely high load status. | Non-negative double precision and floating-point value (default value: 0.85). |
LoadConfig.minorHighThreshold | Determines whether the system is in the high load status. If the ratio of the object (promoting to the old generation) rate to the Eden space size exceeds the parameter value after a minor GC, the system is in the high load status. | Non-negative double precision and floating-point value (default value: 0.04). |
LoadConfig.minorMidThreshold | Determines whether the system is in the moderate load status. If the ratio of the object (promoting to the old generation) rate to the Eden space size exceeds the parameter value after a minor GC, the system is in the moderate load status. | Non-negative double precision and floating-point value (default value: 0.02). |
LoadConfig.minorTerribleThreshold | Determines whether the system is in the extremely high load status. If the ratio of the object (promoting to the old generation) rate to the Eden space size exceeds the parameter value after a minor GC, the system is in the extremely high load status. | Non-negative double precision and floating-point value (default value: 0.06). |
MobileConfig.modulesConfigAvailable | Determines whether the mobile platform module configuration function is enabled. ![]() | Boolean. false (default value): The function is disabled. true: The function is enabled. |
MobileConfig.appMsgProxy | Provides the proxy service for messages in the DataAnalyst app. ![]() | Non-empty string (default value: __EMPTY__). Format of the proxy server address: http://IP address:Port number/mobile/push/message/send. |
MobileConfig.disableEncryptPassword | Determines whether the password for mobile login is encrypted. ![]() | Boolean. false (default value): The password is not encrypted. true: The password is encrypted. |
MobileConfig.persistedAttach | Determines whether to perform persistent processing for images in scheduled tasks upon server startup. ![]() | Boolean. The parameter value in the first startup is false by default and true in the subsequent startups. false: The persistent processing for images in scheduled tasks is performed upon server startup. true: The persistent processing for images in scheduled tasks is not performed upon server startup. |
MobileConfig.productPlan | Determines whether you can join the developer program. ![]() | Boolean. false: You cannot join the developer program. true (default value): You can join the developer program. |
MobileConfig.templateFetchTimeout | Determines the template timeout. ![]() | Integer (default value: -1). Parameter value < 0: Requests of data entry, form data, and component data are never time-out. |
MobileConfig.requiredDisplayDeviceType | Determine the display type of mobile devices. | default or phone. default (default value): Mobile phones and tablets display their own effects. phone: Mobile phone effect is displayed in both mobile phones and tablets. |
QuartzConfig.maxConnections | Determines the maximum connection number in the task schedule module. This parameter is supported in versions after August 16, 2019. | Positive integer (default value: 50). |
QuartzConfig.threadCount | Determines the maximum thread number in the task schedule module. This parameter is supported in versions after August 16, 2019. | Positive integer (default value: 100). |
RedisClusterConfig.maxConnection | Determines the maximum total number of instances in the Redis Cluster connection pool. | Positive integer (default value: 200). |
RedisClusterMonitorConfig.messageInterval | Determines the abnormal message notification frequency of the Redis node (unit: hour(s)). | Positive long integer (default value: 6). |
RedisConfig.database | Determines the designated Redis database. | Integer (default value: 0). |
RedisConfig.expireStateRemoveInterval | Determines the deletion interval of the state server expired keys (unit: millisecond(s)). | Positive integer (default value: 300000). |
RedisConfig.maxConnection | Determines the maximum total number of instances in the Redis connection pool. | Positive integer (default value: 200). |
RemoteDesignConfig.avoidTempAuthValid | Determines whether the digital signature preview function is supported in the remote design. | Boolean. false: The function is not supported in the remote design. true (default value): The function is supported in the remote design. |
ScheduleSettingConfig.taskTimeout | Determines the timeout (5 minutes by default) of the scheduled tasks. | Positive long integer (default value: 300000). |
ScheduleSettingConfig.timeoutRemind | Determines whether the timeout prompt function for monitoring logs in scheduled tasks is enabled. | Boolean. false (default value): The function is disabled in scheduled tasks. true: The function is enabled in scheduled tasks. |
SecurityConfig.frontSeed | Provides encryption keys for the front-end encryption. | String with 16 uppercase and lowercase letters. The initial value is a random string with 16 uppercase and lowercase letters, which can be modified as needed. |
ServerConfig.cookiePath | Determines the Cookie path. ![]() Configure this parameter during the project deployment, especially when multiple projects are deployed on the same server and when they use same domain names. Otherwise, multiple cookies are stored in the browser. Users need to manually clear these cookies for successful login. | Non-empty string (default value: /). |
ServerConfig.tokenFromCookie | Determines whether the function of retrieving tokens from cookies is enabled. If the function is enabled, the backend can retrieve tokens from cookies during the token validation, which can prevent backend single sign-on and cross-domain single sign-on failures caused by HttpOnly. | Boolean. false (default value): Tokens cannot be retrieved from cookies during the backend token validation. true: Tokens can be retrieved from cookies during the backend token validation. |
ServerPreferenceConfig.useOptimizedUPM | Determines whether the new plugin management function is enabled. | Boolean. false (default value): The function is disabled. true: The function is enabled. |
SystemConfig.hideVersion | Determines whether to hide the version information in the system information. | Boolean. false (default value): The version information is not hidden. true: The version information is hidden. |
SystemOptimizationConfig.ClientMasterId | Displays all nodes with data in Web clusters. | String (namely, ID of the machine with designated data requests, updates, and data in Web clusters). |
SystemOptimizationConfig.biClusterMasterNodeHostName | Displays hostnames of main nodes in FineBI clusters. | String (default value: __EMPTY__). |
SystemOptimizationConfig.bigDataModeThreshold | Determines the threshold value in the FineBI big data mode, where the group number is greater than the parameter value. | Positive integer (default value: 5000). |
SystemOptimizationConfig.cacheHeap | Determines the cache number (namely, the number of caches except associate dimension table caches and pagination caches). | Non-negative integer (default value: 100 for big datasets caches and 10000 for small datasets). If the parameter value is set to 0, the cache number is unlimited. The modification takes effect after startup. |
SystemOptimizationConfig.cacheIdleSeconds | Determines the cache expiration time. | Positive long integer (default value: 300). |
SystemOptimizationConfig.cacheLargeMemPercent | Determines the memory proportion of the big cache pool. | Non-negative double precision and floating-point value (default value: 0.2). |
SystemOptimizationConfig.cacheMiddleMemPercent | Determines the memory proportion of the middle cache pool. | Non-negative double precision and floating-point value (default value: 0.05). |
SystemOptimizationConfig.cacheSmallMemPercent | Determines the memory proportion of the small cache pool. | Non-negative double precision and floating-point value (default value: 0.01). |
SystemOptimizationConfig.cacheStrategy | Provides cache strategies. | String (default value: mem). |
SystemOptimizationConfig.chartBigDataNum | Determines the number of big data charts and tables. | Integer (default value: 3). |
SystemOptimizationConfig.chartDataThreadPoolNum | Determines the thread pool number of charts and tables. | 1. For versions earlier than 5.1.11: Positive integer (default value: 8). 2. For 5.1.11 and later versions: Non-negative integer (default value: 8). If the parameter value is 0, the thread pool is closed. Threads starting with "chart-group-data-pool" will not appear in FineBI's thread stacks. This parameter is meaningless if FineBI uses direct connection databases. |
SystemOptimizationConfig.confLockTimeOutTime | Configures the lock timeout (unit: second(s)). | Positive long integer (default value: 30). |
SystemOptimizationConfig.dashboardEditLimit | Determines the row number during the dashboard editing. | Integer (default value: 10000). |
SystemOptimizationConfig.detailUseColumnarCompress | Determines whether the zipping function for detail tables is enabled. | Boolean. false: The function is disabled. true: The function is enabled. |
SystemOptimizationConfig.directMemoryEngineLimitRows | Determines the row number of the cache data for new memory engines in direct connection databases. | Integer (default value: 100000). |
SystemOptimizationConfig.directUseAllData | Determines whether all data in direct connection databases is available. | Boolean. false: All data in direct connection databases is available. true (default value): All data in direct connection databases is unavailable. |
SystemOptimizationConfig.excelExtractDataBase |
| Boolean. false (default value): Excel files in direct connection databases cannot be configured with association tables. true: Excel files in direct connection databases can be configured with association tables. |
SystemOptimizationConfig.excelExtractMaxLimitRows | Determines the row number of temporary tables generated by Excel files in direct connection databases. | Integer (default value: 10000). |
SystemOptimizationConfig.fieldInfoTimeoutSeconds | Determines the timeout for retrieving field information from the data source. | Long integer (default value: -1). |
SystemOptimizationConfig.firstDayofWeek | Determines the first day of a week. | Integer (default value: 0). |
SystemOptimizationConfig.groupUseColumnarCompress | Determines whether the column zipping function for group tables is enabled. | Boolean. false: The function is disabled. true: The function is enabled. |
SystemOptimizationConfig.inheritPermissionAndRelation | Determines the default status for the Permission Inheritance function. | Boolean. false: The function is disabled by default. true (default value): The function is enabled by default. |
SystemOptimizationConfig.memManagerPercent | Determines the proportion of the global memory management size. | Non-negative double precision and floating-point value (default value: 0.6). |
SystemOptimizationConfig.memoryWarningSize | Determines the data volume alert value in SQL datasets. | Integer (default value: 100000000). |
SystemOptimizationConfig.needTreatRedMark | Determines whether self-service datasets marked in red are restored. | Boolean. false (default value): Self-service datasets marked in red are not restored. true: Self-service datasets marked in red are restored. |
SystemOptimizationConfig.optimizeSqlAlias | Determines whether the SQL alias optimization function is enabled. If the function is enabled, all aliases in SQL are reset. | Boolean. false: The function is disabled. true (default value): The function is enabled. |
SystemOptimizationConfig.queryConditionCountRestriction | Determines the condition number of detail filtering. | Integer (default value: -1). |
SystemOptimizationConfig.readRelationFromDbSource | Determines whether the association relationship between tables in databases can be read during the database table editing. | Boolean. false: The association relationship cannot be read. true (default value): The association relationship can be read. |
SystemOptimizationConfig.reportShareType | Determines whether the creator permission is used during the template sharing. | Integer (default value: 0). |
SystemOptimizationConfig.schedulerMergeTimeSeconds | Determines the time for merging scheduled tasks (unit: second(s)). | Integer (default value: 5). |
SystemOptimizationConfig.tableLoadThreadPoolNum | Upgrades the thread number. | Integer (default value: 20). |
SystemOptimizationConfig.threadPoolStrategy | Upgrades the thread pool strategy. | dynamic or static. dynamic (default value): The thread number is calculated based on the memory size (1 GB = 1 thread). |
SystemOptimizationConfig.treeCacheHeap | Determines the cache number of tree structures. | Integer (default value: -1). |
SystemOptimizationConfig.treeCacheSeconds | Determines the cache duration of tree structures. | Long integer (default value: -1). |
SystemOptimizationConfig.useColumnarCompress | Determines whether the column zipping function for group tables is enabled. | Boolean. false: The function is disabled. true: The function is enabled. |
SystemOptimizationConfig.useAllVisibleDataForSentinel | Determines whether to retain template filtering conditions for data alerts. | Boolean. false: The dashboard filtering conditions are retained by default. Users can use only the dashboard data displayed by default for alert. The filtering conditions adjusted during preview will not take effect. true (default value): The full-volume dashboard data (data visible to users is available) is applied.
|
SystemOptimizationConfig.usePagingCache | Determines whether the pagination cache function is enabled. | Boolean. false: The function is disabled. true (default value): The function is enabled. |
TemplateAuthConfig.digitalAuthAvailable | Determines whether the digital signature function in Template Authentication is available. | Note: This parameter is supported in FineBI V5.1.11 and later versions. false: Admins cannot use the digital signature function in Template Authentication. true (default value): Admins can use the digital signature function in Template Authentication. |
WebSecurityConfig.cacheControlExpiresHeader | Determines the value of the header Expires prohibited by the browser cache. | 0 or <http-date>. 0 (default value): This value represents a past date. That is, the cached resources are expired. <http-date>: The value represents a date later than the designated date. That is, the response is expired. |
WebSecurityConfig.cacheControlHeader | Determines the value of the header Cache-Control prohibited by the browser cache. | no-cache or max-age=<seconds>. no-cache (default value): Requests are forced to be submitted to the original server for validation (namely, cache negotiation). max-age=<seconds>: The maximum period for cache storage is set. The cache is considered as expiration after the period (unit: second(s)). |
WebSecurityConfig.cacheControlPragmaHeader | Determines the value of the header Pragma prohibited by the browser cache. | no-cache. |
WebSecurityConfig.contentSecurityPolicyHeader | Determines the value of the header Content-Security-Policy in CSP (Content Security Policy). | object-src 'self', object-src uri, or default-src https. 1. object-src 'self' (default value): The source addresses of the tags (<object>, <embed>, and <applet>) are limited and can only be matched with the current source, rather than its subdomains. 2. object-src uri: 3. default-src https: The unsafe inline/dynamic execution is prohibited. Resources (like images, fonts, and scripts) can only be loaded through HTTPS. |
WebSecurityConfig.contentTypeOptionsHeader8 | Determines the value of the header X-Content-Type-Options in content sniffing attack prevention. | nosniff. |
WebSecurityConfig.fileInspectorType | Determines the file upload verification type after File Upload Verification in Security Management is enabled. | 0, 1, or 2. 0: Comprehensive list. Requests with extensions not in the whitelist are passed, otherwise, the header is verified. 1 (default value): Whitelist. Requests with extensions in the whitelist and matched headers are passed. 2: Blacklist. Requests with extensions not in the blacklist are passed. |
WebSecurityConfig.frameOptionsHeader | Determines the value of the header X-Frame-Options in ClickJacking. | DENY, SAMEORIGIN, or ALLOW-FROM origin. DENY: Browsers do not allow the current page to load any frame pages. |
WebSecurityConfig.hstsHeader | Determines the value of the HTTP Strict Transport Security response header. | max-age=<expire-time>, max-age=<expire-time>; includeSubDomains, and max-age=<expire-time>; preload. 1. max-age=<expire-time>: All requests under this domain name are transformed into HTTPS requests within N seconds after the browser receives the request. 2. max-age=<expire-time>; includeSubDomains (default value: max-age=31536000; includeSubDomains): All requests under this domain name are transformed into HTTPS requests within N seconds after the browser receives the request. This rule also applies to all subdomain names of the website. 3. max-age=<expire-time>; preload: All requests under this domain name are transformed into HTTPS requests within N seconds after the browser receives the request. In this case, HSTS is preloaded. |
WebSecurityConfig.loginValidateStrict | Determines the use of cross-domain login interfaces and CAS backend login interfaces. | Boolean. false (default value): Cross-domain login interfaces and CAS backend login interfaces can be used. true: Cross-domain login interfaces and CAS backend login interfaces cannot be used. |
WebSecurityConfig.xssProtectionHeader | Determines the value of the header X-XSS-Protection in XSS Attack Protection. | 0, 1, 1; mode=block, or 1; report=<reporting-uri>. 0: The XSS filtering is prohibited. 1 (default value): The XSS filtering is enabled. The browser will clear pages and remove unsafe parts if XSS attacks are detected. 1; mode=block: The XSS filtering is enabled. The browser will not clear pages but block the page loading if attacks are detected. 1; report=<reporting-uri>: The XSS filtering is enabled. The browser will clear pages and send violation reports through the CSP reporting-uri function if cross-site scripting attacks are detected. |
WebSocketConfig.port | Displays the WebSocket server listening port number. | Port number arrays ["Port number 1", "Port number 2"] (default value: ["38888","39888"]). All port numbers belong to the range [1024, 65535]. |
WebSocketConfig.trustStore | Determines the file storage path of trust certificates. | Non-empty string (default value: __EMPTY__). It is better to use absolute paths. |
WebSocketConfig.trustStoreFormat | Determines the trust certificate type. | JKS or PKCS12. PKCS12: It is suitable for PFX certificates. JKS: It is the default value. |
WebSocketConfig.trustStorePassword | Provides the application key for using trust certificates. | Non-empty string (default value: __EMPTY__). It is better to use absolute paths. |
ClusterRedirectConfig.enableSessionIDGenerationStrategy | Determines whether the session ID generation policy is enabled in the cluster environment. | Boolean. false (default value): The session ID generation policy is disabled in the cluster environment. true: The cluster's node ID is appended to the end of session ID in the cluster environment. |
FineClusterConfig.params.encrypt | Determines whether the cluster communication encryption function is enabled. | Boolean. false (default value): The cluster communication encryption function is disabled. true: The cluster communication encryption function is enabled. |
FineClusterConfig.params.ipStackType | Determines the cluster communication method. | ipv4 (default value) or ipv6. |
Html5Config.isJoinProductPlan | Determines whether the developer program can be disabled in HTML5 mode. Users can manually choose whether to join the product improvement program, thus further protecting their privacy security. | Boolean. false: The developer program is disabled. true (default value): The developer program is enabled. |
LanguageConfig.locale | Determines the language displayed in the platform. | zh_CN (default value): Simplified Chinese. zh_TW: Traditional Chinese. en_US: English. ja_JP: Japanese. ko_KR: Korean. |
MarketConfig.cloudOperationMaintenanceId | Resets the application ID in Cloud O&M. | User's application ID (default value). |
MobileConfig.emptyDirVisible | Determines whether empty directories are displayed on mobile terminals (the DataAnalyst app and the HTML5 end). ![]() | Boolean. true: Empty directories are displayed. false (default value): Empty directories are not displayed. |
ParseCheckConfig.allowDrawing | Determines whether HTML can be converted into images if errors (such as unsupported tags and attributes in various export scenarios) occur in HTML parsing. | Boolean. false: HTML cannot be converted into images. true (default value): HTML can be converted into images. |
ServerPreferenceConfig.errorTemplate | Allows you to customize FineBI template error pages. For details, see FineBI official help documents. | Links of custom error pages (default value: __EMPTY__). |
SystemOptimizationConfig.clearEntityStrategy | Provides clearance strategies for custom FineDB tables. | Default value: __EMPTY__. Parameter value format: Strategy number:Month of to-be-cleared data,Clearance time (unit: hour),Clearance time (unit: minute),Clearance time (unit: second). |
WebSocketConfig.hostName | Determines the listening IP setting in WebSocket. | IP number of the server network interface controller or external IP number. Default value: 0.0.0.0. |
WebSocketConfig.webSocketTokenInHeader | Determines the token transmission method for WebSocket communication. | Boolean. true: Token is transmitted from the request header. false (default value): Token is transmitted from URL. |
WorkflowAuthorityConfig.compatible | Determines whether the prompt can still pop up afterward. During the first login of independent links for multi-level reporting, a prompt pops up, indicating that there are permission configurations related to reporting pages in directory permissions, and whether to synchronize the permission configurations from the directory permissions. | Boolean. true: The prompt cannot pop up. false (default value): The prompt can pop up. |
DistributedOptimizationConfig.spiderConfig.local_file_delete_retry_mode | Determines whether the retry mechanism can be deleted by local files. | Boolean. true (default value): The retry mechanism can be deleted by local files. false: The retry mechanism cannot be deleted by local files. |
DistributedOptimizationConfig.spiderConfig.local_file_delete_retry_period | Determines whether the retry period can be deleted by local files. | Positive integer (default value: 10). |
DistributedOptimizationConfig.spiderConfig.local_file_delete_retry_time | Determines whether the retry times can be deleted by local files. | Positive integer (default value: 3). |
DistributedOptimizationConfig.spiderConfig.max_slice_memory_size | Determines the maximum memory size of Slice. | Positive integer (default value: 52428800). |
DistributedOptimizationConfig.spiderConfig.spark_blockManager_port | Determines the port number of BlockManager in Spark. | Positive integer ranging from 1001 to 65535 (default value: 17778). |
DistributedOptimizationConfig.spiderConfig.spark_driver_host | Determines the host name of the driver in Spark. | String (empty by default). |
DistributedOptimizationConfig.spiderConfig.spark_driver_maxResultSize | Determines the maximum result set size (returned from Spark) in the driver end. | String (default value: 1 GB). |
DistributedOptimizationConfig.spiderConfig.spark_driver_port | Determines the port number of the driver in Spark. | Positive integer ranging from 1001 to 65535 (default value: 17777). |
DistributedOptimizationConfig.spiderConfig.spark_executor_cores | Determines the core number of Executor in Spark. | Positive integer (default value: 12). |
DistributedOptimizationConfig.spiderConfig.spark_executor_memory | Determines the memory size of Executor in Spark. | String (default value: 6 GB). |
DistributedOptimizationConfig.spiderConfig.spark_local_dir | Determines Spark temporary file directories and calculates the disk directory throughput. | String (empty by default). |
DistributedOptimizationConfig.spiderConfig.spark_master_host | Determines the host name of the master in Spark. | String (empty by default). |
DistributedOptimizationConfig.spiderConfig.spark_master_port | Determines the port number of the master in Spark. | Positive integer ranging from 1001 to 65535 (default value: 7077). |
DistributedOptimizationConfig.spiderConfig.spark_scheduler_allocation_file | Determines the scheduling allocation files of Spark. | String (empty by default). |
DistributedOptimizationConfig.spiderConfig.spark_scheduler_mode | Determines the Spark scheduling mode. | String (default value: CAPACITY) |
DistributedOptimizationConfig.spiderConfig.spark_shuffle_service_enabled | Determines whether data external sorting is performed during shuffle process. | Boolean. true (default value): Data external sorting is performed during shuffle process. false: Data external sorting is not performed during shuffle process. |
DistributedOptimizationConfig.spiderConfig.spark_sql_adaptive_enabled | Determines whether the adaptive calculation function is enabled. | Boolean. true (default value): The adaptive calculation function is enabled. false: The adaptive calculation function is disabled. |
DistributedOptimizationConfig.spiderConfig.spark_sql_adaptive_shuffle_targetPostShuffleInputSize | Calculates the adaptive target block size. | String (default value: 200 MB). |
DistributedOptimizationConfig.spiderConfig.spark_sql_broadcastTimeout | Determines the broadcast timeout. | String (default value: 12000). |
DistributedOptimizationConfig.spiderConfig.spark_sql_shuffle_partitions | Determines the shuffle concurrent block number in Spark. | String (empty by default). |
DistributedOptimizationConfig.spiderConfig.spark_sql_sortMergeJoinExec_buffer_in_memory_threshold | Determines the maximum data volume of the operator memory in SortMergeJoin. | String (default value: 100000). |
DistributedOptimizationConfig.spiderConfig.spark_sql_sortMergeJoinExec_buffer_spill_threshold | Determines the operator throughput threshold value in SortMergeJoin. | String (default value: 100000). |
DistributedOptimizationConfig.spiderConfig.spider_array_group_map_function_threshold | Determines the array grouping algorithm threshold. | Positive integer (default value: 5000000). |
DistributedOptimizationConfig.spiderConfig.spider_base_update_thread_proportion | Determines the basic table thread proportion. | Positive integer (default value: 30). |
DistributedOptimizationConfig.spiderConfig.spider_build_field_index_cores | Builds the field index core number. | Positive integer (default value: 8). |
DistributedOptimizationConfig.spiderConfig.spider_build_index_cores | Builds the index core number. | Positive integer (default value: 4). |
DistributedOptimizationConfig.spiderConfig.spider_column_max_load_dictionary_key_size | Determines the maximum loading dictionary number of data columns. | Positive integer (default value: 10000). |
DistributedOptimizationConfig.spiderConfig.spider_compress_slice_size | Determines the row number of each slice in data extract. | Positive integer (default value: 100000). |
DistributedOptimizationConfig.spiderConfig.spider_core_limit_fraction | Limits the core task ratings in Spark. | Non-negative double precision and floating-point value (default value: 0.67). |
DistributedOptimizationConfig.spiderConfig.spider_create_satellite_async | Determines whether satellite tables can be created asynchronously. | Boolean. true (default value): Satellite tables can be created asynchronously. false: Satellite tables cannot be created asynchronously. |
DistributedOptimizationConfig.spiderConfig.spider_deletion_criteria_size_per_execution | Incrementally deletes the maximum calculation size per time. | String (default value: 128 MB). |
DistributedOptimizationConfig.spiderConfig.spider_detail_formula_use_page | Determines whether pagination can be used in detail formulas. | Boolean. true (default value): Pagination can be used in detail formulas. false: Pagination cannot be used in detail formulas. |
DistributedOptimizationConfig.spiderConfig.spider_distinct_median_threshold | Deduplicates or calculates the median of the memory threshold value. | Positive integer. Default value: 100 (for versions of earlier than 5.1.12) or 25 (for 5.1.12 and later versions). |
DistributedOptimizationConfig.spiderConfig.spider_double_dictionary_max_key_size | Determines the maximum dictionary number of double. | Positive integer (default value: 10000). |
DistributedOptimizationConfig.spiderConfig.spider_engine_use_page | Determines whether pagination engine can be used. | Boolean. true (default value): Pagination engine can be used. false: Pagination engine cannot be used. |
DistributedOptimizationConfig.spiderConfig.spider_etl_coalesce_size | Determines the ETL maximum block number. | Positive integer (default value: 10). |
DistributedOptimizationConfig.spiderConfig.spider_etl_compute_limit_unit | Determines the limits for ETL cell calculation. | Positive integer (default value: 50000000). |
DistributedOptimizationConfig.spiderConfig.spider_etl_core_limit | Determines whether core is limited in ETL. | Boolean. true: Core is limited in ETL. false (default value): Core is not limited in ETL. |
DistributedOptimizationConfig.spiderConfig.spider_etl_iterator_repartition_size | Determines the ETL repartition size. | Positive integer (default value: 20). |
DistributedOptimizationConfig.spiderConfig.spider_etl_no_order | Determines whether ETL is orderly. | Boolean. true: ETL is orderly. false (default value): ETL is not orderly. |
DistributedOptimizationConfig.spiderConfig.spider_etl_output_use_bitmap | Determines whether ETL generates indexes. | Boolean. true (default value): ETL generates indexes. false: ETL does not generate indexes. |
DistributedOptimizationConfig.spiderConfig.spider_etl_preview_row_count | Determines the ETL preview row number. | String (default value: 5000). |
DistributedOptimizationConfig.spiderConfig.spider_etl_writer_lock_wait | Determines the wait time of ETL exclusive locks. | Integer greater than -1 (default value: 60000). |
DistributedOptimizationConfig.spiderConfig.spider_fast_compute_limit_memory | Quickly calculates the memory limit byte size. | Positive long integer (default value: 500000000). |
DistributedOptimizationConfig.spiderConfig.spider_fast_compute_limit_row | Quickly calculates the row limit number. | Positive integer (default value: 10000000). |
DistributedOptimizationConfig.spiderConfig.spider_fast_compute_limit_unit | Quickly calculates the cell limit number. | Positive integer (default value: 10000000). |
DistributedOptimizationConfig.spiderConfig.spider_fast_etl_cache | Determines whether the used cache size is calculated quickly. | Boolean. true (default value): The used cache size is calculated quickly. false: The unused cache is calculated quickly. |
DistributedOptimizationConfig.spiderConfig.spider_file_max_mmap_size | Determines the maximum size of memory-mapped files. | Positive integer (default value: 2147483647). |
DistributedOptimizationConfig.spiderConfig.spider_file_mmap_size | Determines the memory-mapped file size. | Positive integer (default value: 1073741823). |
DistributedOptimizationConfig.spiderConfig.spider_first_day_of_week | Determines the first day of a week. | Integer ranging from 0 to 6 (default value: 1). |
DistributedOptimizationConfig.spiderConfig.spider_float_dictionary_max_key_size | Determines the maximum dictionary number of float. | Positive integer (default value: 10000). |
DistributedOptimizationConfig.spiderConfig.spider_generate_join_cache_in_query | Determines whether association cache can be generated in query. | Boolean. true (default value): Association cache can be generated in query. false: Association cache cannot be generated in query. |
DistributedOptimizationConfig.spiderConfig.spider_high_performance_pool_size | Determines the resource pool size of association and analysis tables if calculation performance cannot be guaranteed. | Positive integer (default value: 1000). |
DistributedOptimizationConfig.spiderConfig.spider_high_performance_resource_time | Determines the occupancy time of high performance resources. | String (empty by default). |
DistributedOptimizationConfig.spiderConfig.spider_ignore_base_update | Determines whether the basic table upgrade function is skipped. | Boolean. true: The basic table upgrade function is skipped. false (default value): The basic table upgrade function is skipped. |
DistributedOptimizationConfig.spiderConfig.spider_index_build_bitmap_dataset | Determines whether index can generate and use datasets. | Boolean. true: Index can generate and use datasets. false (default value): Index cannot generate and use datasets. |
DistributedOptimizationConfig.spiderConfig.spider_index_build_bitmap_external | Determines whether index can generate and use external sorting. | Boolean. true (default value): Index can generate and use external sorting. false: Index cannot generate and use external sorting. |
DistributedOptimizationConfig.spiderConfig.spider_index_build_bitmap_external_buffer_path | Determines the index cache file path. | String (default value: /root/temp/spark). |
DistributedOptimizationConfig.spiderConfig.spider_index_build_bitmap_external_buffer_size | Determines the index cache size. | Positive integer (default value: 100000). |
DistributedOptimizationConfig.spiderConfig.spider_int_dictionary_max_key_size | Determines the maximum dictionary number of int. | Positive integer (default value: 10000). |
DistributedOptimizationConfig.spiderConfig.spider_int_distinct_structure | ![]() Determines the data structure of the deduplicate record number. | Specific value. 0 (default value): The data structure is KolobokeIntSet, which runs fast but occupies large memory space (1 int key for 8 bytes). 1: The data structure is RoaringBitmap, which occupies small memory space but runs slowly. |
DistributedOptimizationConfig.spiderConfig.spider_join_always_use_sql | Determines whether SQL calculation is always used in association tables. | Boolean. true: SQL calculation is always used in association tables. false (default value): SQL calculation is always not used in association tables. |
DistributedOptimizationConfig.spiderConfig.spider_join_build_index | Determines whether association tables can generate indexes. | Boolean. true (default value): Association tables can generate indexes. false: Association tables cannot generate indexes. |
DistributedOptimizationConfig.spiderConfig.spider_join_cache_delete_direct | Determines whether associate caches are deleted immediately. | Boolean. true (default value): Associate caches are deleted immediately. false: Associate caches are not deleted immediately. |
DistributedOptimizationConfig.spiderConfig.spider_join_dot_constant | Determines the associate point constant. | String (default value: .). |
DistributedOptimizationConfig.spiderConfig.spider_join_equal_constant | Determines the associate equals sign constant. | String (default value: =). |
DistributedOptimizationConfig.spiderConfig.spider_join_huge_table_size | Determines the associate big table size. | Non-negative integer (default value: 0). |
DistributedOptimizationConfig.spiderConfig.spider_join_left_bracket_constant | Determines the associate left parenthesis constant. | String (default value: (). |
DistributedOptimizationConfig.spiderConfig.spider_join_left_square_bracket_constant | Determines the associate left square bracket constant. | String (default value: [). |
DistributedOptimizationConfig.spiderConfig.spider_join_name_simple | Determines whether associate tables use simple names. | Boolean. true: Associate tables use simple names. false (default value): Associate tables do not use simple names. |
DistributedOptimizationConfig.spiderConfig.spider_join_right_bracket_constant | Determines the associate right parenthesis constant. | String (default value: )). |
DistributedOptimizationConfig.spiderConfig.spider_join_right_square_bracket_constant | Determines the associate right square bracket constant. | String (default value: ]). |
DistributedOptimizationConfig.spiderConfig.spider_join_use_relation | Determines whether associate caches are used. | Boolean. true (default value): Associate caches are used. false: Associate caches are not used. |
DistributedOptimizationConfig.spiderConfig.spider_load_data_buffer_queue_size | Determines the buffer queue size of extract data. | Positive integer (default value: 100). |
DistributedOptimizationConfig.spiderConfig.spider_load_data_buffer_row_size | Determines the buffer row size of extract data. | Positive integer (default value: 1000). |
DistributedOptimizationConfig.spiderConfig.spider_load_use_bitmap | Determines whether extract data generates indexes. | Boolean. true (default value): Extract data generates indexes. false: Extract data does not generate indexes. |
DistributedOptimizationConfig.spiderConfig.spider_local_compute_cores | Determines the local computing core number. | Positive integer (empty by default). |
DistributedOptimizationConfig.spiderConfig.spider_local_default_db | Determines the default database of data. | String (default value: db). |
DistributedOptimizationConfig.spiderConfig.spider_local_root_path | Determines the storage path of extract data. | String (default value: ../spider). |
DistributedOptimizationConfig.spiderConfig.spider_lock_wait_time | Determines the default lock wait time. | Positive integer (default value: 1000). |
DistributedOptimizationConfig.spiderConfig.spider_long_dictionary_max_key_size | Determines the maximum dictionary number of long. | Positive integer (default value: 10000). |
DistributedOptimizationConfig.spiderConfig.spider_low_performance_small_pool_size | Determines the resource pool size generated by association tables when calculation performance is guaranteed. | Positive integer (default value: 4). |
DistributedOptimizationConfig.spiderConfig.spider_max_rowstream_memory_size | Determines the ETL rowstream memory limit. | Positive integer (default value: 52428800). |
DistributedOptimizationConfig.spiderConfig.spider_mem_filer_datamodel_ratio | Determines the memory evaluation ratio after filtering. | Non-negative double precision and floating point value (default value: 0.3). |
DistributedOptimizationConfig.spiderConfig.spider_memory_check_frequency_group | Determines the memory statistics frequency of grouping algorithm. | Positive integer (default value: 100000). |
DistributedOptimizationConfig.spiderConfig.spider_merge_forbidden_time | Merges prohibition time. | String (empty by default). |
DistributedOptimizationConfig.spiderConfig.spider_number_set_dictionary_max_key_size | Determines whether the maximum dictionary number can be set for numerical type dictionary encoding. | Boolean. true: The maximum dictionary number can be set. false (default value): The maximum dictionary number cannot be set. |
DistributedOptimizationConfig.spiderConfig.spider_page_summary_concurrent_threads | Determines whether pagination indicators calculate multiple threads. | Boolean (empty by default). true: Pagination indicators calculate multiple threads. false: Pagination indicators do not calculate multiple threads. |
DistributedOptimizationConfig.spiderConfig.spider_partition_limitation | Determines the row limits of Partition. | Positive integer (default value: 1000). |
DistributedOptimizationConfig.spiderConfig.spider_partition_merge_policy | Determines the merger policy of Partition. | String (empty by default). |
DistributedOptimizationConfig.spiderConfig.spider_partition_row_size | Determines the row number of Partition. | Positive integer (default value: 10000000). |
DistributedOptimizationConfig.spiderConfig.spider_partition_slice_size | Determines the row number of each slice in data extract of Partition. | Positive integer (default value: 5000). |
DistributedOptimizationConfig.spiderConfig.spider_query_condition_count_restriction | Determines the condition number in the engine query. | Integer ≥ -1 (default value: -1). |
DistributedOptimizationConfig.spiderConfig.spider_reduce_row_key_ratio | Determines the dictionary usage ratio of reduce. | Non-negative double precision and floating point value (default value: 1.0). |
DistributedOptimizationConfig.spiderConfig.spider_relation_column_strategy | Determines the generation strategy of associate columns. | String (default value: SectionShrink). |
DistributedOptimizationConfig.spiderConfig.spider_relation_matcher_policy | Determines association match rules. | String (default value: HeadTail). |
DistributedOptimizationConfig.spiderConfig.spider_restrictions_column_long_text | Determines the maximum text length. | Positive integer (default value: 1000). |
DistributedOptimizationConfig.spiderConfig.spider_retry_max_times | Determines the maximum number of retries. | Positive integer (default value: 2). |
DistributedOptimizationConfig.spiderConfig.spider_row_index_strategy | Determines whether row indexes of analysis table are optimized. | Boolean. true: Row indexes of analysis table are optimized. false (default value): Row indexes of analysis table are not optimized. |
DistributedOptimizationConfig.spiderConfig.spider_satellite_creation_step | Determines the creation step length of satellite tables. | Positive integer (default value: 10000000). |
DistributedOptimizationConfig.spiderConfig.spider_section_merge_large_section_count | Determines the merged large block number of section. | Positive integer (default value: 6). |
DistributedOptimizationConfig.spiderConfig.spider_section_merge_policy | Determines the merger policy of section. | String (default value: grouping). |
DistributedOptimizationConfig.spiderConfig.spider_section_merge_row_threshold_factor | Determines the merger row threshold value of section. | Positive long integer (default value: 1000000). |
DistributedOptimizationConfig.spiderConfig.spider_section_merge_small_section_count | Determines the merged small block number of section. | Positive integer (default value: 4). |
DistributedOptimizationConfig.spiderConfig.spider_spark_driver_use_random_port | Determines whether the driver of Spark uses random port numbers. | Boolean. true: The driver of Spark uses random port numbers. false (default value): The driver of Spark does not use random port numbers. |
DistributedOptimizationConfig.spiderConfig.spider_spark_local_threads | Determines the local thread number of Spark. | Positive integer (empty by default). |
DistributedOptimizationConfig.spiderConfig.spider_sparksql_filter_pushdown | Determines whether the predicate pushdown is performed in SparkSQL. | Boolean. true (default value): The predicate pushdown is performed in SparkSQL. false: The predicate pushdown is not performed in SparkSQL. |
DistributedOptimizationConfig.spiderConfig.spider_sql_merge_table | Determines whether SQL merger tables are used. | Boolean. true (default value): SQL merger tables are used. false: SQL merger tables are not used. |
DistributedOptimizationConfig.spiderConfig.spider_stream_partition_estimated_byte | Estimates the size of streaming partitions. | Positive integer (default value: 2000000000). |
DistributedOptimizationConfig.spiderConfig.spider_submit_spark_thread_count | Submits the Spark thread number. | Positive integer (default value: 5). |
DistributedOptimizationConfig.spiderConfig.spider_table_estimate_strategy | Determines the strategy of table size estimation. | String (SAMPLE). |
DistributedOptimizationConfig.spiderConfig.spider_temp_folder_path_for_spark | Determines Spark temporary file paths. | String (default value: /root/temp/spark). |
DistributedOptimizationConfig.spiderConfig.spider_update_fast_compute_limit_cell | Analyzes the disk size occupied by users' self-service datasets. | Positive integer (default value: 100000000). |
DistributedOptimizationConfig.spiderConfig.spider_updated_background | Determines whether incremental update merger is executed in the backend. | Boolean. true: Incremental update merger is executed in the backend. false (default value): Incremental update merger is not executed in the backend. |
DistributedOptimizationConfig.spiderConfig.spider_updated_partition_num | Determines the update partition number triggering merger. | Positive integer (default value: 2). |
DistributedOptimizationConfig.spiderConfig.spider_use_fast_etl_local_optimize | Determines whether local optimization is used in the quick calculation. | Boolean. true: Local optimization is used in the quick calculation. false (default value): Local optimization is not used in the quick calculation. |
DistributedOptimizationConfig.spiderConfig.spider_use_pin_yin_sort | Determines whether Chinese Pinyin sorting is used. | Boolean. true: Chinese Pinyin sorting is used. false (default value): Chinese Pinyin sorting is used. |
FSConfig.loginConfig.fWords | Customizes username login search field in the LDAP authentication. | Parameter format: ["Value 1","Value 2"]. Parameter value requirements: not empty and non-zero length. Default value: ["sAMAccountName","cn","userPrincipalName","uid","displayName","name","sn"]. |
UpdateConfig.launchSwitchMap.plugins | Determines whether the plugin automatic startup update function is enabled. | true (default value): The plugin automatic startup update function is enabled. false: The plugin automatic startup update function is disabled. |
CronUpdateConfig.typeMap.plugins | Determines whether the plugin automatic scheduled update function is enabled. | true (default value): The plugin automatic scheduled update function is enabled. false: The plugin automatic scheduled update (at 23:00 P.M. every night in external networks) function is disabled. |
DelayUpdateConfig.delaySwitchMap.plugins | Determines whether the plugin automatic delay update function is enabled. | true (default value): The plugin automatic delay update function is enabled. false: The plugin automatic delay update function is disabled. |
DistributedOptimizationConfig.spiderConfig.spider_high_performance_resource_time | Determines time periods in which high performance resources can be occupied in updates. | Positive integer. Example: 19:00:00-8:00:00. |
Restarting the Server
Click Save after modifying configurations based on relevant rules. A prompt appears: "The parameters you modified will take effect after restart. Restart the server first."
Configurations take effect after re-startup.
