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.