Description:

This property specifies the duration (in minutes) for which a query will be held when the Query Engine (QE) cluster is down.

The system will attempt to start the QE cluster, and if it does not become available within the specified wait time, the query will fail.

If the value is set to 0, the query will not wait for the Query Engine cluster to start and will fail immediately.

Values and behavior:

Any positive integer value (in minutes).

Syntax:

QE_STARTUP_QUERY_HOLD_TIME=[60] (int)

Default value:

The default value is 5.

This indicates the query will not wait for the startup of the Query Engine cluster and will fail instantly.

Scope:

Application

Comes into effect:

The administrator can change its value anytime, and it requires a BI Server restart.

Environment:

Applicable in all cloud environments.