Page tree
Skip to end of metadata
Go to start of metadata

Some of the important properties of the olapengine.properties file, needed for cluster deployment are listed here.

Property Name

Description

Syntax/Example

Default Value

LISTENER_PORT

The port at which the server will listen.

[1024] (int)

45450

DATABASE_CONNECTION_TIMEOUT

The Database connection timeout (specified in seconds).

[50] (int)

600

REQUEST_QUEUE_SIZE

The report server places all requests in a queue before executing them. This property is used to set the maximum number of requests that can be queued. After the queue is filled, the server ignores all client requests until the number of requests in the queue is reduced to a number less than the property value.

Specify an integer value that is greater than zero. The new value set for this property comes into effect after server restart.

[100] (int)

1000

TEMP

This property specifies where temporary files are stored. If the specified folder is not found, the server creates the folder. If the server is not able to create the folder, all the features that need to create temporary files will not work.

[path] (string)

../temp

LOG_LEVEL

This property specifies the debug level used for logging.

[TRACE,DEBUG, INFO, WARN, ERROR, FATAL] (string)

ERROR

LOG

The log file directory. The log filename is intera.log.

[path] (string)

../logs

CUBE_BUILDER_SCHD_THREADS

The maximum number of cubes that can be concurrently built.

[No. of threads] (int)

5

OLAP_EXEC_THREADS

These threads handle report execution requests. Specify the number of report execution requests that must be simultaneously served.

[5] (int)

5

SERVICE_THREADS

This thread handles all the requests (except report execution). Specify the number of service requests that must be simultaneously served.

[5] (int)

5

CANCEL_THREADS

This thread handles the report-canceling task (stopping the execution of a report). Specify the number of cancel requests that must be simultaneously served.

[5] (int)

5

CUBOID_PURGE_FREQUENCY

This is the file system purge frequency, that is, the interval after which the purge thread execution for cuboids is repeated (in minutes).

[>0] (int)

120

COMPRESS_NETWORK_DATA

This property is used to enable or disable communication with the clients in COMPRESS mode.

enable/disable (string)

enable

SCHD_JOB_DISPATCH_THREADS

The maximum number of schedules that can be concurrently executed.

[No. of threads] (int)

10

SCHD_JOB_DISPATCH_QUEUE_SIZE

The maximum number of jobs that can be served at once.

[Queue size] (int)

50

SCHD_PENDING_JOB_QUEUE_SIZE

The maximum number of pending jobs.

[Queue size] (int)

500

SMTP_SERVER

Configures the SMTP server for task status notifications.

[Server IP address or Domain name] (string)

127.0.0.1

SMTP_AUTHENTICATION

This option enables or disables SMTP server authentication.

If enabled, it requires SMTP_SERVER_USER and SMTP_SERVER_PASSWORD for authentication.

[enable,disable] (string)

disable

SMTP_SERVER_USER

Sets the User ID for the SMTP Server. You need to set a valid user if your SMTP server authenticates before sending emails.

[User Name] (string)

blank

ENCR_SMTP_SERVER_PASSWORD

Sets the password to be used for the SMTP Server.

[Password] (string)

blank

EMAIL_FROM_ADDRESS

Sets the email address which is shown as the sender’s address in email messages.

[From Address] (string)

blank

JOB_SUCCESS_MAIL_TO

The comma or semicolon-separated list of email addresses to which a job success email message is to be sent.

[Comma or Semi Colon-separated list of email addresses] (string)

blank

JOB_SUCCESS_MAIL_SUBJECT

The subject used for sending the job success mail.

[subject](String)

Scheduled job '<%JOB_NAME%>' notification - Success

JOB_ERROR_MAIL_TO

The comma or semicolon-separated list of email addresses to which the job error email message is to be sent.

[Comma or Semi Colon-separated list of email addresses] (string)

blank

JOB_ERROR_MAIL_SUBJECT

The subject to be used for sending the job error email message.

[subject] (string)

Scheduled job '<%JOB_NAME%>' notification - Failure

BIND_IPADDRESS

The IP address on which Report Server will bind itself.

[127.0.0.1] (string)

blank

MEMORY_TRIGGER_LEVEL

This property governs the behavior of the system in high memory situations. The Trigger Level is the percentage of total memory used after which the Report server invokes an event and sets the ReTrigger Level. The next event is invoked when the ReTrigger Level is exceeded. The Trigger Level must not exceed 100 and must not be less than 50.

[Trigger Level in %] (number)

90%

MEMORY_RETRIGGER_LEVEL

This property governs the behavior of the system in low memory situations. The ReTrigger Level is the percentage of total memory used after which Report server invokes an event and sets the Trigger Level. The ReTrigger Level must not exceed 100 and must not be less than 40.

[ReTrigger Level in %] (number)

70

MEMORY_TRIGGER_NOTIFICATION

This setting enables or disables notifications when memory usage of the Report Server exceeds the MEMORY_TRIGGER_LEVEL.

[enable/disable] (string)

Enable

EXEC_REJECTION_ON_MEMORY_TRIGGER

This setting enables or disables the EXEC Rejection On Memory Trigger feature. The Report Server rejects the execution request and blocks all the Scheduled jobs launched when USED MEMORY + DEFAULT_MEMORY_USAGE_PER_EXEC > MEMORY_TRIGGER_LEVEL.

[enable/disable] (string)

enable

TIME_DIFF_FOR_TRIGGER_NOTIFICATION

The minimum time difference after which the Memory Trigger Notification is sent.

[value in mins] (string)

30

DEPLOYMENT_TYPE

Configures the Scheduler in a clustered environment.

[CLUSTERED/STANDALONE] (string)

STANDALONE

UTILITY_THREAD_POOL_INITIAL_SIZE

Utility threads are used to carry out internal processes by the Report Server. This property governs the size of the utility thread pool.

[no. of Threads >0] (int)

5

UTILITY_THREAD_POOL_PURGE_TIME

This property governs the purge time of the utility thread pool. This is the maximum time that excess idle threads wait before terminating.

[>0] (int)

50

REPORT_PREVIEW_RECORD_COUNT

The property sets the default number of records available in the report preview mode.

[no. of Records >0] (int)

200

FIELD_LOOKUP_MAX_VALUES

This property sets the value for the maximum number of records that can be fetched from the database.

[no. of Records >0 AND no. of Records <=20000] (int)

2000

OLAP_MDX_MEMBER_LIMIT

This property sets the value for the maximum number of combinations that can be fetched for an MDX query.

[no. of Combinations >0] (int)

1000

ZOOKEEPER_HOSTS

Lists comma-separated ZooKeeper hosts optionally including their port values.

[host:port,localhost]

localhost: 2181

CLUSTER_NAME

The name the ZooKeeper node used for creating a namespace for different users

[unique_user_name]

Default_Cluster

CUBOID_DISTRIBUTION_QUEUE_SIZE

The maximum number of cuboid distribution requests that can be served at once.

[Queue size] (int)

1000

CUBOID_DISTRIBUTION_THREADS

The maximum number of cuboid distribution threads that can be concurrently executed.

[No. of threads] (int)

5

CUBOID_REPLICATION_FACTOR

The value for the maximum number of replications of every cuboid.

[No. of cuboid replications] (int)

2

CUBOID_REPLICATION_TRIGGER_INTERVAL

The time to wait before triggering the cuboid replication if the query engine goes down.

[No. of milliseconds] (int)

30000

HEALTH_READER_INTERVAL

The time interval upon which the Query Engine’s health is published to the ZooKeeper server.

[No. of milliseconds] (long)

30000

BUILD_HISTORY_RECORDS_SIZE

The number of build history records to maintain.

[No. of build history records to be maintained] (int)

0

Value = 0 means never purge, retain all entries.

NUMBER_OF_PREVIOUS_PASSWORDS

The number of previous passwords to be maintained in history.

[No. of previous passwords to be maintained] (int)

3

NOTE: Minimum Value is 1

USER_PASSWORD_LENGTH

The length of a user password.

[Minimum length of password] (int)

5

NOTE: Minimum Value is 5

PASSWORD_EXPIRATION_TIME

Time after which the password expires.

[Days after which password needs to be changed] (No. of Days)

30

NOTE: Minimum Value is 10, value = 0 means never expire

COORDINATION_MASTER_LISTENER_PORT

The port on which the server listens for thrift requests.

[9995] (int)

45460

MAX_FILE_SIZE_FOR_IN_MEMORY_OPERATIONS

Defines whether to use PIG or the in-memory mechanism for joining. This must be specified in GBs.

[2] (int)

2

QE_LOCAL_CACHE_PATH

The location where cube data is locally copied.

[Directory Path] (String)


OLAP_SLIDER_MEMBER_LIMIT

The upper limit for the number of members queried and shown on a slider while browsing a cube from Kyvos client.

[A positive integer value] (int)

200

OLAP_CHART_MEMBER_LIMIT

The upper limit for the number of members queried and shown on a chart while browsing a cube from the Kyvos client.

[A positive integer value] (int)

1000

OLAP_COLOR_SHELF_LIMIT

The upper limit for the number of members queried and shown on a color shelf while browsing a cube from the Kyvos client.

[A positive integer value] (int)

20

CUBE_DATA_CACHE_LIMIT

The amount of memory specified in the percentage of maximum memory assigned to the BI Server process for caching cube data.

[An integer value between 0 to 80] (int)

50

RAW_DATA_QUERYING_ENABLEDSpecifies if raw data querying is enabled or not.

false

false

SQL_PARSER_CACHE_CLEANUP_INTERVAL

This property governs the schedule of parsed SQL cache cleanup.

A cache is created and maintained in Kyvos memory for parsed SQLs. The size of this cache can grow indefinitely based on the unique input queries. In order to reduce the memory footprint, Kyvos will periodically clean this cache.

Integer value denoting hours

84

  • No labels