FineOps Version
Functional Change
Some configurations of FanRuan applications are recorded in the fine_conf_entity table in the FineDB configuration database and can be modified only through modifying field values.
You can modify the configuration safely through Business Configuration Modification.
1. Log in to FineOps as the admin, select the project for which you need to modify the configuration, and choose Business Tool > Business Configuration Modification.
2. Configure the parameter using the following two methods:
Select Parameter: You can select configurable parameters in the fine_conf_entity table from the drop-down list of System Parameter Name (key) and configure System Parameter Value (value).
Customize Parameter: You can enter the name of a configurable parameter in the fine_conf_entity table in System Parameter Name (key). The parameter value will be automatically displayed in System Parameter Value (value). You can modify and save the parameter value.
Click Save after modifying the configuration following the parameter rules. A prompt will appear saying "The parameters you modified will take effect after restart. Restart the server first."
3. Choose Maintenance > Component Management. Find the bi6/fr/fdl component and click Restart. The configuration will take effect after a successful restart.
The following table shows the configurable parameters in the fine_conf_entity table.
Customizes the key length for backing up the conf table
Positive integer
Default value: 1500
Customizes the value length for backing up the conf table
Default value: 65536
Determines the maximum cache size of the shared dataset
Non-negative integer
Default value: 4194304
Determines the minimum success times in multiple error analyses per time error detection task in the cluster environment
Default value: 1
Determines the allowable time error value (unit: ms) per time error detection task in the cluster environment
Long positive integer
Default value: 10000
Determines the total number of error analysis attempts per time error detection task in the cluster environment
Default value: 3
Determines whether the floating elements are displayed at absolute positions (whether affected by the cell expansion)
Boolean (default value: false)
false: not display floating elements at absolute positions (not affected by the cell expansion)
true: display floating elements at absolute positions (affected by the cell expansion)
Determines whether data fields are case-sensitive
The following lists the parameter values (default value: case_ignore):
case_ignore: case-insensitive
case_sensitive: case-sensitive
Defines the transmission format of frontend template data during filling submission and request verification
The following lists the parameter values (default value: xml:
xml: transmit data in XML string format
json: transmit data in JSON string format
Determines the row height coefficient of the exported Excel
Non-negative single-precision floating point number
Default value: 20.1
Determines the column width coefficient of the exported Excel
Default value: 34.742
Determines whether to include full images in the exported Excel file
false: not include full images in the exported Excel file
true: include full images in the exported Excel
Determines whether to export/print widgets. (Currently, checkbox and checkbox group widgets can be printed)
false: not export/print widgets
true: export/print widgets
Determines whether to enable the designer zoom
Boolean (default value: true)
false: Designer zoom is disabled
true: Designer zoom is enabled
Default value: 2
Determines whether to enable assigning permissions by position
false: enable assigning permissions by position
true: disable assigning permissions by position
Determines whether there is a forcible redirection to http://IP address:Port number/webroot/decision after login
false: no forcible redirection after login
true: perform forcible redirection after login
Determines the notification frequency of FTP abnormal messages (unit: hour)
Determines whether to allow adaptive record tracking
false: Adaptive record tracking is not allowed
true: Adaptive record tracking is allowed
Default value: 300
Configures the hostname of the hot standby master node
Configures the hostname of the slave node
Long integer
Default value: 18000
Default value: 1000000
Default value: 0.6
Non-negative double-precision floating point number
Default value: 0.8
Default value: 0.1
Determines the default quantity rate of cells in sessions to be killed
Default value: 0.3
false: Smart release is not supported in the JDK of the current version.
true: Smart release is supported in the JDK of the current version.
Default value: 20
Default value: 0.4
Specifies the session release rate during ultra-high load conditions for the first release attempt (During ultra-high load, if the number of sessions to be released exceeds the product of the default number of slots and this ratio, the first release attempt will be triggered.)
Default value: 0.2
Double-Precision Float
Default value: 0.9
Default value: 6
Default value: 0.95
Specifies the threshold of high load after Major GC. If the ratio of the size of objects remaining in the old generation to the size of the old generation exceeds this threshold after Major GC, high load is deemed to occur
Default value: 0.7
Default value: 0.85
Default value: 0.04
Default value: 0.02
Sets the App message proxy
Non-Empty String
Default value: __EMPTY__
Format of the proxy server address:
http://IP address:Port number/mobile/push/message/send
Determines whether the password for mobile login is encrypted
false: The password for mobile login is not encrypted.
true: The password for mobile login is encrypted.
Determines whether to persist scheduled images during server startup
Boolean (defaulting to false for the first startup; true for later startups)
false: Scheduled images are not persisted during server startup.
true: Scheduled images are persisted during server startup.
Determines whether to join the developer plan
false: You are not enrolled in the developer plan.
true: You are enrolled in the developer plan.
Determines the template timeout
Integer
Default value: -1
If the parameter value < 0, requests of data entry, form data, and component date never time out.
If the parameter value (n) > 0, the timeout threshold is n seconds. Requests (of data entry, form data, and component date) with no returned result after n seconds will be canceled . For the timeout of data entry and form data requests, a prompt pops up saying "Request timed out, please contact the administrator to extend the request."
Determines the display type on mobile devices
The following lists the parameter values (default value: default):
default: mobile effect on the mobile terminal and pad effect on the pad.
phone: mobile effect on both the mobile terminal and pad.
Default value: 50
Default value: 100
Determines the maximum number of instances in the Redis Cluster connection pool
Default value: 200
Determines the notification frequency of Redis node exception messages (unit: hour)
Determines the Redis-specified database
Default value: 0
Determines the time interval at which expired keys are deleted from the state server (unit: ms)
Default value: 300000
false: Digital signature preview is not supported during remote design.
true: Digital signature preview is supported during remote design.
Determines task schedule timeout (defaulting to five minutes)
Default value: 30000
false: Monitoring log timeout reminders is disabled for scheduled tasks.
true: Monitoring log timeout reminders is enabled for scheduled tasks.
16-bit Uppercase and Lowercase Letter String
The initial secret key is a random 16-bit uppercase & lowercase letter string, which can be modified by yourself.
Determines the Cookie path.
The initial path is /
false: Tokens cannot be retrieved from cookies during background verification.
true: Tokens can be retrieved from cookies during background verification.
false: New plugin management is disabled.
true: New plugin management is enabled.
Determines whether to hide version information in system info
false: Version information is not hidden in system info.
true: Version information is hidden in system info.
The following lists the parameter values (default value: success):
success: Platform initialization is complete.
fail: Platform initialization is not complete.
Determines the node with data in the web cluster
String
ID of the node with request data and updata data in the cluster environment
Determines the cache count (excluding dimension table cache and other caches associated with page break cache)
When not configured by default, the big data set is cached by 100 and the small data set is cached by 10,000.
The cache count has no limitation when it is set to 0. You need to restart the component after modification.
Determines the percentage of memory in large buffer pool
Default value: 0.05
Default value: 0.01
Default value: mem
Limits the number of big data charts
Default value: 8
The parameter value is 0 suggests that the thread pool is closed, and threads starting with chart-group-data-pool will not appear in FineBI's thread stacks.
This parameter is meaningless if FineBI uses directly connected databases.
Default value: 30
false: Column compression is disabled for detail table
true: column compression is enabled for detail table
Determines the row quantity limit of cache data in directly connected memory engines
Determines whether all data in directly connected databases is available
false: All data in directly connected databases is available.
true: All data in directly connected databases is unavailable.
Determines Excel data extraction (Associated tables for directly connected Determines whether directly connected Excel files can be configured with association tables. Due to the limits of selectable association tables in directly connected databases, only the system parameter is true, can Excel files configure association.)
false: Directly connected Excel files cannot configure association.
true: Directly connected Excel files can configure association.
Determines the timeout for retrieving field information from data sources
Determines the first day of a week
false: Column compression for group tables is disabled.
true: Column compression for group tables is enabled.
Determines the default status for permission inheritance
false: Permission inheritance is disabled by default.
true: Permission inheritance is enabled by default.
Default value: 100000000
false: Self-service datasets marked in red will not be restored.
true: Self-service datasets marked in red will be restored.
false: SQL aliases are not be optimized.
true: SQL aliases are optimized.
Determines the count limit of detail filtering conditions
Determines whether to read associations in the database when adding database tables
false: Associations are not read when adding database tables.
true: Associations are read when adding database tables.
Determines whether to use creator permission during the template sharing
Determines the time interval for the merge of scheduled tasks (unit: second)
Default value: 5
Determines the number of update threads
Determines the update thread pool strategy
The following lists the parameter values (default value: dynamic):
dynamic: The thread number is calculated based on the memory size (1 GB = 1 thread).
Determines the cache number of tree structures
Determines whether column compression for group tables is enabled
Determines whether pagination cache is enabled
false: Pagination cache is disabled.
true: Pagination cache is enabled.
Determines whether digital signature in template authentication is available
This parameter is supported in FineBI V5.1.11 and later versions.
The following lists the parameter values (default value: true):
false: The admin cannot use digital signature in template authentication.
true: The admin can use digital signature in template authentication.
Determines the value of Expires in the header for disabling browser cache
The following lists the parameter values (default value: 0):
0: This value represents a past date, which indicates the resource has been expired.
<http-date>: The value indicates the resources will be expired after the specified date.
Determines the value of Cache-Control in the header for disabling browser cache
The following lists the parameter values (default value: no-cache):
no-cache: Before releasing a cached copy, requests are forced to be submitted to the original server for validation (namely, negotiation cache validation).
max-age=<seconds>: The value set the maximum period for cache storage. After the period, cache is considered expired (unit: second).
Determines the value of Pragma in the header for disabling browser cache
Determines the value of Content-Security-Policy in the header for CSP (Content Security Policy)
The following lists the parameter values (default value: object-src 'self'):
1. object-src 'self': Restricts the source address of the <object>, <embed>, and <applet> tags and only allows matching with the current origin (not its subdomains).
2. object-src uri: Restricts the source addresses of the <object>, <embed>, and <applet> tags and only the specified URL in these tags can be loaded.
3. default-src https: Disables insecure inline/dynamic execution and only allows these resources (images, fonts, scripts, etc.) to be loaded via HTTPS.
Determines the value of X-Content-Type-Options in the header for content sniffing attack prevention
The following lists the parameter values (default value: 1):
0: Comprehensive. Files with extensions not in the whitelist are passed, otherwise, the header is verified.
1: Whitelist. Files with extensions in the whitelist and with matched headers are passed.
2: Blacklist. Files with extensions not in the blacklist are passed.
Determines the value of X-Frame-Options for clickjacking attack protection
The following lists the parameter values (default value: SAMEORIGIN):
DENY: All frame pages on the current web page will be denied from loading by the browser.
SAMEORIGIN: Only when the addresses of frame pages are the same as the ones of the current page.
ALLOW-FROM origin: Frame pages on these web pages can be loaded.
Determines the value of Strict-Transport-Security in the hsts header
The following lists the parameter values (default value: max-age=31536000; includeSubDomains):
1. max-age=<expire-time>:
Set the browser to use HTTPS for all requests to this domain for XXX seconds after receiving this request.
2. max-age=<expire-time>; includeSubDomains:
Set the browser to use HTTPS for all requests to this domain for XXX seconds after receiving this request. This setting also applies to all the subdomains of this website.
3. max-age=<expire-time>; preload:
Set the browser to use HTTPS for all requests to this domain for XXX seconds after receiving this request and preload HSTS.
false: The cross-domain login interface and the CAS backend login interface are not restricted.
true: The cross-domain login interface and the CAS backend login interface are restricted.
Determines the value of X-XSS-Protection for XSS attack protection
The following lists the parameter values (default value: 1; mode=block):
0: XSS filtering is prohibited.
1: XSS filtering is enabled. The browser clears the page and remove unsafe information if XSS attacks are detected.
1; mode=block: XSS filtering is enabled. Instead of page clearing, the browser prevents the page from loading if XSS attacks are detected.
1; report=<reporting-uri>: XSS filtering is enabled. The browser clears the page and use reporting-uri in CSP to send violation reports if attacks are detected.
Determines the listening port number of the WebSocket server
["Port number 1", "Port number 2"]
All port numbers belong to the range (1024, 65535].
Default value: ["38888", "39888"]
Determines the file storage path of the trust certificate
Non-Empty String (absolute path is strongly recommended)
The parameter value is JKS or PKCS12.
Default value: JKS
If the certificate is of PFX format, the parameter value should be changed to PKCS12.
Determines the application password for using trust certificate
Determines whether to enable the session ID generation policy in the cluster environment
false : 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.
Determines whether the cluster communication encryption is enabled
false: Cluster communication is not encrypted.
true: Cluster communication is encrypted.
Determines the communication method in the cluster environment
Default value: IPv4
IPv6 is also supported.
false: The developer plan is closed.
true: The developer plan is enabled.
Determines the global platform language setting
Default value: en_US
en_US: English
zh_CN: Simplified Chinese
zh_TW: Traditional Chinese
ja_JP: Japanese
ko_KR: Korean
Determines whether empty directories are displayed on mobile terminals (the DataAnalyst app and the HTML5 end)
true: Empty directories are displayed.
false: Empty directories are not displayed.
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 if errors occur in HTML parsing.
true: HTML can be converted into images if errors occur in HTML parsing.
The parameter value is the link of the customized error reporting page.
Allows you to customize the clearance strategy for FineDB tables
Parameter value format: {Strategy number}:{Month of to-be-cleared data},{Clearance time (unit: hour)},{Clearance time (unit: minute)},{Clearance cycle (unit: second)}
For example,
strategy 1: clean up data before March, execute every 2 days at 4:20,
strategy 2: clean up data before January, execute every 30 days at 2:50,
then the parameter value should be 1:3,4,20,172800; 2:1,2,50,2592000.
Determines the listening IP setting in WebSocket
The parameter value is the server's built-in NIC (network interface controlleror) IP or external IP
Default value: 0.0.0.0
Determines the token transmission method for WebSocket communication
true: Token is transmitted from the request header.
false: Token is transmitted from URL.
Determines whether to pop up the message for the independent link of multi-level reporting upon first-time login (The message prompts you to determine whether to synchronize permission configurations from directory permissions because permission configurations related to the reporting page exist in the directory permissions.)
true: The message will not pop up.
false: The message will pop up.
Determines whether the retry mechanism is deleted by local files
true: The retry mechanism is deleted by local files.
false: The retry mechanism is not deleted by local files.
Determines the retry period for deleting local files
Determines the retry times for deleting by local files
Determines the maximum memory size of Slice
Determines the port number of BlockManager in Spark
Positive Integer ranging from 1001 to 65535
Default value: 17778
Determines the host name of the driver in Spark
Determines the maximum size of the result set returned to the driver in Spark
Determines the port number of the driver in Spark
Default value: 17777
Determines the number of cores of Executor in Spark
Determines the memory size of Executor in Spark
DistributedOptimizationConfig.spiderConfig.spark_local_dir
Determines the host name of the master in Spark
Determines the port number of the master in Spark
Default value: 7077
Determines the scheduling mode in Spark
Determines whether data is spilled to disk during the shuffle process
true: Data is spilled to disk during the shuffle process.
false: Data is not spilled to disk during the shuffle process.
Determines whether adaptive computation is enabled
true: Adaptive computation is enabled.
false: Adaptive computation is disabled.
Determines the size of the computational adaptive target block
Determines the broadcast timeout
Determines the number of concurrent shuffle blocks in Spark
Determines the maximum data volume of the SortMergeJoin operator
Determines the throughput threshold of the SortMergeJoin operator
Determines the array grouping algorithm threshold
Determines the proportion of basic table thread
Determines the number of cores for building field indexes
Determines the number of cores for building indexes
Determines the maximum data volumn in a data column that can be loaded to data dictionary
Determines the row number of each slice during data extraction
Determines the task score limiting by cores in Spark
Default value: 0.67
Determines whether to create satellite tables asynchronously
true: Satellite tables are created asynchronously.
false: Satellite tables are not created asynchronously.
Determines the maximum calculation size per incremental deletion
Determines whether pagination is used in detail formulas
true: Pagination is used in detail formulas.
false: Pagination is not used in detail formulas.
Determines the distinct count/median memory threshold
Positive Integer
Default value: 100 (for versions earlier than V5.1.12) or 25 (for V5.1.12 and later versions)
Determines the maximum number of double type records in data dictionary
Determines whether to use the pagination engine
true: Pagination engine is used.
false: Pagination engine is not used.
Determines the maximum number of chunks during the ETL process
Determines the limit on the number of computation cells during the ETL process
Determines whether the number of cores is limited during the ETL process
true: The number of cores is limited during the ETL process.
false: The number of cores is not limited during the ETL process.
Determines the size of data repartitions during the ETL process
Determines whether data order is preserved during the ETL process
true: Data order is not preserved during the ETL process.
false: Data order is preserved during the ETL process.
Determines whether indexes are generated during the ETL process
true: Indexes are generated during the ETL process.
false: Indexes are not generated during the ETL process.
Determines the number of rows displayed as a preview during the ETL process
Determines the maximum duration an ETL process should wait to acquire a write lock
Integer larger than or equals to -1
Default value: 60000
Determines the maximum memory size (in Bytes) that can be used for fast computation tasks
Default value: 500000000
Determines the maximum number of rows that can be processed in fast computation tasks
Determines the maximum number of cells that can be processed in fast computation tasks
Determines whether cache is used for fast computation tasks
true: Cache is used for fast computation tasks.
false: Cache is not used for fast computation tasks.
Determines the maximum file mmap size
Determines the file mmap size
Integer ranging from 0 to 6
Determines the maximum number of float type records in data dictionary
Determines whether association cache is generated during query
true: Association cache is generated during query.
false: Association cache is not generated during query.
Determines the resource pool size for associations and analysis tables when computation performance is not guaranteed
Determines the occupancy time of high performance resources
Determines whether to ignore the upgrade of basic tables
true: Basic table upgrade will be ignored.
false: Basic table upgrade will not be ignored.
Determines whether datasets are used for generating indexes
true: Datasets are used for generating indexes.
false: Datasets are not used for generating indexes.
Determines whether external sorting is used for generating indexes
true: External sorting is used for generating indexes.
false: External sorting is not used for generating indexes.
Determines the path of index cache files
Default value: distributed/external
Determines the size of index cache
Determines the maximum number of int type records in data dictionary
Determines the data structure of distinct data (This parameter is available in V5.1.12 and later versions.)
The following lists the parameter values (default value: 0).
0: The data structure is KolobokeIntSet, which runs fast but occupies large memory space (8 bytes for 1 int key).
1: The data structure is RoaringBitmap, which occupies small memory space but runs slowly (1 byte for 1 int key).
Determines whether associations are always performed using SQL queries
true: Associations are always performed using SQL queries.
false: Associations are never performed using SQL queries.
Determines whether indexes are generated for associations
true: Indexes are generated for associations.
false: Indexes are not generated for associations.
Determines whether association cache is deleted immediately
true: Association cache is deleted immediately.
false: Association cache is not deleted immediately.
Determines the dot constant for association
String (default value: .)
Determines the equal sign constant for association
Determines the size of a large associated table
Determines the left parenthesis constant for association
Determines the left bracket constant for associate
Determines whether simple naming is used for associated tables
true: Simple naming is used for associated tables.
false: Simple naming is not used for associated tables.
Determines the right parenthesis constant for association
Determines the right bracket constant for associate
Determines whether association cache is used
true: Association cache is used.
false: Association cache is not used.
Determines the buffer queue size of extracted data
Determines the buffer row size of extracted data
Determines whether indexes are generated for extracted data
true: Indexes are generated for extracted data.
false: Indexes are not generated for extracted data.
Determines the number of local computation cores
Determines the default database of data
Determines the storage path of extracted data
Determines the default wait time for locks
Determines the maximum number of long type records in data dictionary
Determines the resource pool size for generating associations when computation performance is guaranteed
Determines the memory limit of rowstream during the ETL process
Determines the memory evaluation ratio after filtering
Non-negative double-precision float (default value: 0.3)
Determines the memory statistics frequency for grouping algorithm
Determines the time to forbid merging
Determines whether to set the maximum number of records in data dictionary for numerical type dictionary encoding
true: The maximum number of records in data dictionary is set.
false: The maximum number of records in data dictionary is not set.
Determines whether pagination indicators calculate concurrent threads
Boolean (empty by default)
true: Pagination indicators calculate concurrent threads.
false: Pagination indicators do not calculate concurrent threads.
Determines the maximum number of rows of partitions
Determines the merging strategy for partitions
Determines the number of rows in partitions
Determines the number of rows in each slice during partition data extraction
Determines the maximum number of conditions queried by the engine
Determines the dictionary usage ratio of reduce
Non-negative double-precision float (default value: 1.0)
Determines the generation strategy for association columns
Determines the association matching rule
Determines the maximum text length
Determines the maximum retry times
Determines whether to optimize row indexes in analysis tables
true: Row indexes in analysis tables are optimized.
false: Row indexes in analysis tables are not optimized.
Determines the step length created by satellite tables
Determines the number of large sections that can be merged
Determines the merging strategy for sections
Determines the threshold on the number of rows that can be merged
Determines the number of small sections that can be merged
Determines whether the driver in Spark uses random port numbers
true: The driver in Spark uses random port numbers.
false (default value): The driver in Spark does not use random port numbers.
Determines the number of local threads in Spark
Determines whether predicate pushdown is performed in SparkSQL
true: Predicate pushdown is performed in SparkSQL.
false: Predicate pushdown is not performed in SparkSQL.
Determines whether SQL can be used to merge tables
true: SQL can be used to merge tables.
false: SQL cannot be used to merge tables.
Estimates the estimated size of streaming partitions
Determines the number of threads submitted to Spark
Determines the strategy to estimate the table size
Determines the path for temporary Spark files
Default value: /root/temp/spark
Determines the disk space occupied by analysis user's self-service datasets
Determines whether incremental update merge is executed in the backend
true: Incremental update merge is executed in the backend.
false: Incremental update merge is not executed in the backend.
Determines the number of updated partitions to trigger merge
Determines whether local optimization is used in the quick calculation
true: Local optimization is used in the quick calculation.
false: Local optimization is not used in the quick calculation.
true: Sorting in Chinese Pinyin order is enabled
false: Sorting in Chinese Pinyin order is disabled
Determines whether the function to log errors when plugins are missing is enabled
false: The function is diabled.
true: The function is enabled.
Customizes the login search field for LDAP authentication usernames
Parameter value format: ["Value 1","Value 2"]
The parameter value cannot be empty.
Default value: ["sAMAccountName","cn","userPrincipalName","uid","displayName","name","sn"]
Determines whether to enable startup update during automatic plugin update
Determines whether to enable timed update during automatic plugin update
Determines whether to enable delayed update during automatic plugin update
Determines the time period during which updates are allowed to use high-performance resources
滑鼠選中內容，快速回饋問題
滑鼠選中存在疑惑的內容，即可快速回饋問題，我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy