Configuring the Queue Waiter task

The Queue Waiter task is used to wait until the data warehouse terminates the processing of data imported by the ETLs. The Queue Waiter task is generally added to a task chain, so that the chain is placed in wait until the data processing is available. For details, see Configuring the Task chain. For example, you can add the task chain in wait until all the data required to build a specific report is available before launching the Report Executor task.

This task is used to postpone the execution of analyses, models, or reports till the related resolution of data is available in the warehouse after a batch loading through ETL. The queue waiter can be stopped after the expiration of a specified timeout, even if attended requests haven’t been completely processed. At configuration time, you can reduce the scope of the wait to a specific set of ETLs or domain and also to specific data warehouse threads.

The following details must be entered for the Run configuration of the task:

Additional information

Fields and tabs available in Advanced mode are identified using the (lightbulb) icon.

To edit the configurations for the queue waiter task, navigate to Administration > ETL & SYSTEM TASKS > System tasks and in the working area on the right, click the appropriate name available in the System tasks table. In the Run configurations table, click Edit to access the following General configuration and Scheduling options tabs:

FieldDescription
General configuration
NameType a name for the task.
Deploy statusSelect if the task should be in the Test or Production environment.
DescriptionType a description for the task.
Structure to wait for (lightbulb)Select the structure on which the task should wait - All, Domain, System, or Business Driver.
Components to wait for (lightbulb)Click Select components to wait to select the components to wait for:
  • Raw: Wait processing of raw data from staging area (only for ETLs that populates raw data).
  • Store: Wait processing of staged samples at detail resolution.
  • Warehouse: Wait processing from detail resolution to hour resolution and computation of derived series.
  • Reduce: Wait processing from hour resolution to  day/month resolution and computation of roll statistics.
  • Custom statistics: Wait processing configured custom statistics.
  • Variation: Wait processing of configuration series.
ScopeSelect one of the following options to define a scope for the task:
  • All: Wait till all queues of warehouse are processed.
  • Domains: Wait till all series of systems and business drivers that belong to a specific domain are processed.
  • ETL tasks: Wait till all series loaded by an ETL are processed.
Sleep Period (lightbulb)Enter a value after which the run configuration should start.
TimeoutEnter a timeout for the task (in minutes).
Scheduling options (lightbulb)
Hour maskSpecify the time of the day when the task is scheduled to run. For example, 0 – 23 or 1,3,5 - 12.
Day of week mask(Optional) Select the days of the week to schedule the task.
Day of month maskSpecify the days of the month to schedule the task. For example, 5, 9, 18, 27 – 31
Apply mask validationSelect whether you want to mask the validation. Set it to False if you want to disable the preceding Scheduling options that you specified. Setting it to False is useful if you want to temporarily turn off the mask validation without removing any values.
Execute after timeSpecify the time period (in hours:minutes format) after which the scheduler task must be executed. For example, 05:00 or 16:00. The task execution will start only after the specified time passes.
EnqueueableSelect if you want the task to be enqueued if other tasks are being executed.

Was this page helpful? Yes No Submitting... Thank you

Comments