Business Configuration Modification

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

Positive integer

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

Positive integer

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

Positive integer

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

Non-negative single-precision floating point number

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

Non-negative integer

Default value: 2

Determines whether to enable assigning permissions by position

Boolean (default value: false)

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)

Default value: 1

Determines whether to allow adaptive record tracking

false: Adaptive record tracking is not allowed

true: Adaptive record tracking is allowed

Non-negative integer

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

Non-negative double-precision floating point number

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

Long positive integer

Default value: 6

Non-negative double-precision floating point number

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

Note:

Only takes effect for mobile terminals

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

Note:

Only takes effect for mobile terminals

Boolean (default value: false)

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

Note:

Only takes effect for mobile terminals

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

Note:

Only takes effect for mobile terminals

Boolean (default value: true)

false: You are not enrolled in the developer plan.

true: You are enrolled in the developer plan.

Determines the template timeout

Note:

Only takes effect for mobile terminals

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

Positive integer

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)

Default value: 6

Determines the Redis-specified database

Integer

Default value: 0

Determines the time interval at which expired keys are deleted from the state server (unit: ms)

Positive integer

Default value: 300000

Default value: 200

Boolean (default value: true)

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.

Note:

Configure it during project deployment. Otherwise, multiple cookies will be stored in the browser, requiring each user to manually clear cookies for successful login.

Non-Empty String

The initial path is /

false: Tokens cannot be retrieved from cookies during background verification.

true: Tokens can be retrieved from cookies during background verification.

Boolean (default value: false)

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

String

Default value: __EMPTY__

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.

Long positive integer

Determines the percentage of memory in large buffer pool

Default value: 0.2

Default value: 0.05

Default value: 0.01

String

Default value: mem

Limits the number of big data charts

Default value: 3

Non-negative integer

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.

Long positive integer

Default value: 30

Integer

Boolean (default value: true)

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 

Boolean (default value: true)

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.

Default value: 10000

Determines the timeout for retrieving field information from data sources

Long integer

Default value: -1

Determines the first day of a week

Integer

Default value: 0

false: Column compression for group tables is disabled.

true: Column compression for group tables is enabled.

Determines the default status for permission inheritance

Boolean (default value: true)

false: Permission inheritance is disabled by default.

true: Permission inheritance is enabled by default.

Non-negative double-precision floating point number

Default value: 0.6

Default value: 100000000

Boolean (default value: false)

false: Self-service datasets marked in red will not be restored.

true: Self-service datasets marked in red will be restored.

Boolean (default value: true)

false: SQL aliases are not be optimized.

true: SQL aliases are optimized.

Determines the count limit of detail filtering conditions

Integer

Default value: -1

Determines whether to read associations in the database when adding database tables

Boolean (default value: true)

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

Integer

Default value: 0

Determines the time interval for the merge of scheduled tasks (unit: second)  

Default value: 5

Determines the number of update threads

Integer

Default value: 20

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

Integer

Default value: -1

Long integer

Default value: -1

Determines whether column compression for group tables is enabled

Boolean (default value: true)

false: Column compression for group tables is disabled.

true: Column compression for group tables is enabled.

Determines whether pagination cache is enabled

Boolean (default value: true)

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.

Boolean (default value: false)

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)

Default value: __EMPTY__

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

Non-Empty String (absolute path is strongly recommended)

Default value: __EMPTY__

Determines whether to enable the session ID generation policy in the cluster environment

Boolean (default value: false)

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)

Note:

This parameter only takes effect on mobile terminals.

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.

Default value: __EMPTY__

Allows you to customize the clearance strategy for 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 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

Boolean (default value: false)

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.)

Boolean (default value: false)

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

Positive Integer ranging from 1001 to 65535

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

Positive Integer ranging from 1001 to 65535

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

Boolean (default value: true)

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

Non-negative double-precision floating point number

Default value: 0.67

Determines whether to create satellite tables asynchronously

Boolean (default value: true)

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

Boolean (default value: true)

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

Boolean (default value: false)

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

Boolean (default value: false)

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

Boolean (default value: true)

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

Long positive integer

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

Determines the first day of a week

Integer ranging from 0 to 6

Default value: 1

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

Boolean (default value: false)

true: Basic table upgrade will be ignored.

false: Basic table upgrade will not be ignored.

Determines whether datasets are used for generating indexes

Boolean (default value: false)

true: Datasets are used for generating indexes.

false: Datasets are not used for generating indexes.

Determines whether external sorting is used for generating indexes

Boolean (default value: true)

true: External sorting is used for generating indexes.

false: External sorting is not used for generating indexes.

Determines the path of index cache files

String

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

Boolean (default value: false)

true: Associations are always performed using SQL queries.

false: Associations are never performed using SQL queries.

Determines whether indexes are generated for associations

Boolean (default value: true)

true: Indexes are generated for associations.

false: Indexes are not generated for associations.

Determines whether association cache is deleted immediately

Boolean (default value: true)

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

Boolean (default value: false)

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

Boolean (default value: true)

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

Boolean (default value: true)

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

Boolean (default value: false)

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

Integer larger than or equals to -1

Default value: -1

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

Boolean (default value: false)

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

Boolean (default value: false)

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

Boolean (default value: true)

true: Predicate pushdown is performed in SparkSQL.

false: Predicate pushdown is not performed in SparkSQL.

Determines whether SQL can be used to merge tables

Boolean (default value: true)

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

String

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

Boolean (default value: false)

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

Boolean (default value: false)

true: Local optimization is used in the quick calculation.

false: Local optimization is not used in the quick calculation.

Boolean (default value: false)

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

Boolean (default value: false)

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