Interact | ETL | patternStateETL | <patternStateETLName> | Report

The configuration properties in this category define the settings for the ETL report aggregation process.

enable

Description
Enable or disable the report integration with ETL. This property is set to disable by default.

If set to disable, this property disables updates on table UARI_DELTA_PATTERNS Table . It does not disable reporting completely .

Note: To disable the report integration with ETL, you must also alter the trigger TR_AGGREGATE_DELTA_PATTERNS to disable on UACI_ETLPATTERNSTATERUN staging table.

retryAttemptsIfAggregationRunning

Description
The number of times the ETL attempts to check whether the report aggregation is completed if the lock flag is set. This property is set to 3 by default.

sleepBeforeRetryDurationInMinutes

Description
Sleep time in minutes between consecutive attempts. This property is set to 5 minutes by default.

aggregationRunningCheckSql

Description
This property lets you define a custom SQL, which can be run to see whether the report aggregation lock flag is set. By default this property is empty.
When this property is not set, the ETL runs the following SQL to get the lock flag.
select count(1) AS ACTIVERUNS from uari_pattern_lock where islock='Y'
=> If ACTIVERUNS is > 0, lock is set

aggregationRunningCheck

Description
Enable or disable the check if the report aggregation is running before the ETL run is performed. This property is set to enable by default.