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.
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.
Click to download the plugin: FINE_CONF_ENTITY Visual Configuration.zip.
For details, see Plugin Management.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Note: It is only applicable to mobile terminals.
false (default value): The function is disabled.
true: The function is enabled.
MobileConfig.appMsgProxy
Provides the proxy service for messages in the DataAnalyst app.
Note:It is only applicable to mobile terminals.
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.
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.
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.
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. Parameter value (N) > 0: Timeout is N seconds. The loading is canceled if requests of data entry, form data, and component data does not return results after N seconds. For the timeout of data entry and form data requests, a prompt pops up indicating that requests are timed out and you need to contact the admin to increase request times.
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)).
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.
RemoteDesignConfig.avoidTempAuthValid
Determines whether the digital signature preview function is supported in the remote design.
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.
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.
Note: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.
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.
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.
SystemConfig.hideVersion
Determines whether to hide the version information in the system information.
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.
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.
false: The function is disabled.
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.
false: All data in direct connection databases is available.
true (default value): All data in direct connection databases is unavailable.
SystemOptimizationConfig.excelExtractDataBase
Determines whether direct connection Excel files can be configured with association tables. Due to the limits of selectable association tables in direct connection databases, only the system parameter is SystemOptimizationConfig.excelExtractDataBase, can Excel files be configured with association tables.
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.
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.
SystemOptimizationConfig.groupUseColumnarCompress
Determines whether the column zipping function for group tables is enabled.
SystemOptimizationConfig.inheritPermissionAndRelation
Determines the default status for the Permission Inheritance function.
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.
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.
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.
true (default value): The function is enabled.
SystemOptimizationConfig.queryConditionCountRestriction
Determines the condition number of detail filtering.
SystemOptimizationConfig.readRelationFromDbSource
Determines whether the association relationship between tables in databases can be read during the database table editing.
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.
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). static: The thread number is fixed. In this case, this parameter is used with the parameter TableloadThreadPoolNum.
SystemOptimizationConfig.treeCacheHeap
Determines the cache number of tree structures.
SystemOptimizationConfig.treeCacheSeconds
Determines the cache duration of tree structures.
SystemOptimizationConfig.useColumnarCompress
SystemOptimizationConfig.useAllVisibleDataForSentinel
Determines whether to retain template filtering conditions for data alerts.
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.
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:The source addresses of the tags (<object>, <embed>, and <applet>) are limited and only the specified URL of these tags can be loaded.
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. SAMEORIGIN (default value): The addresses of frame pages can only be the ones from the same domain names. ALLOW-FROM origin: Frame pages can load page addresses.
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.
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.
ClusterRedirectConfig.enableSessionIDGenerationStrategy
Determines whether the session ID generation policy is enabled in the cluster environment.
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.
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.
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).
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.
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).Example: Strategy 1 is to clear data before March at 4:20 A.M. every 2 days. Strategy 2 is to clear data before January at 2:50 A.M. every 30 days. The parameter value is 1:3,4,20,172800;2:1,2,50,2592000.
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.
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.
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.
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.
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.
DistributedOptimizationConfig.spiderConfig.spark_master_host
Determines the host name of the master in Spark.
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.
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.
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.
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.
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.
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.
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.
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.
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.
DistributedOptimizationConfig.spiderConfig.spider_engine_use_page
Determines whether pagination engine can be used.
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.
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.
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.
DistributedOptimizationConfig.spiderConfig.spider_etl_no_order
Determines whether ETL is orderly.
true: ETL is orderly.
false (default value): ETL is not orderly.
DistributedOptimizationConfig.spiderConfig.spider_etl_output_use_bitmap
Determines whether ETL generates indexes.
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.
DistributedOptimizationConfig.spiderConfig.spider_fast_etl_cache
Determines whether the used cache size is calculated quickly.
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
Integer ranging from 0 to 6 (default value: 1).
DistributedOptimizationConfig.spiderConfig.spider_float_dictionary_max_key_size
Determines the maximum dictionary number of float.
DistributedOptimizationConfig.spiderConfig.spider_generate_join_cache_in_query
Determines whether association cache can be generated in query.
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.
DistributedOptimizationConfig.spiderConfig.spider_ignore_base_update
Determines whether the basic table upgrade function is skipped.
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.
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.
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.
DistributedOptimizationConfig.spiderConfig.spider_int_dictionary_max_key_size
Determines the maximum dictionary number of int.
DistributedOptimizationConfig.spiderConfig.spider_int_distinct_structure
Note:This parameter is added in 5.1.12 and later versions.
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.
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.
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.
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.
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.
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.
DistributedOptimizationConfig.spiderConfig.spider_load_data_buffer_row_size
Determines the buffer row size of extract data.
DistributedOptimizationConfig.spiderConfig.spider_load_use_bitmap
Determines whether extract data generates indexes.
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.
DistributedOptimizationConfig.spiderConfig.spider_long_dictionary_max_key_size
Determines the maximum dictionary number of long.
DistributedOptimizationConfig.spiderConfig.spider_low_performance_small_pool_size
Determines the resource pool size generated by association tables when calculation performance is guaranteed.
DistributedOptimizationConfig.spiderConfig.spider_max_rowstream_memory_size
Determines the ETL rowstream memory limit.
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.
DistributedOptimizationConfig.spiderConfig.spider_merge_forbidden_time
Merges prohibition time.
DistributedOptimizationConfig.spiderConfig.spider_number_set_dictionary_max_key_size
Determines whether the maximum dictionary number can be set for numerical type dictionary encoding.
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.
DistributedOptimizationConfig.spiderConfig.spider_partition_merge_policy
Determines the merger policy of Partition.
DistributedOptimizationConfig.spiderConfig.spider_partition_row_size
Determines the row number of Partition.
DistributedOptimizationConfig.spiderConfig.spider_partition_slice_size
Determines the row number of each slice in data extract of Partition.
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.
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.
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.
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.
DistributedOptimizationConfig.spiderConfig.spider_spark_driver_use_random_port
Determines whether the driver of Spark uses random port numbers.
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.
DistributedOptimizationConfig.spiderConfig.spider_sparksql_filter_pushdown
Determines whether the predicate pushdown is performed in SparkSQL.
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.
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.
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.
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.
DistributedOptimizationConfig.spiderConfig.spider_use_fast_etl_local_optimize
Determines whether local optimization is used in the quick calculation.
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.
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.
Determines time periods in which high performance resources can be occupied in updates.
Positive integer. Example: 19:00:00-8:00:00.
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.
滑鼠選中內容，快速回饋問題
滑鼠選中存在疑惑的內容，即可快速回饋問題，我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy