Log messages in the UARI_DELTA_REFRESH_LOG
table for the Unica Interact Event Pattern report
The UARI_DELTA_REFRESH_LOG
table contains logging information for all
procedures.
Aggregation process status
To verify the status of the aggregation process, look for the following text:
MESSAGE_LINE:
<patterntype> patterns delta refresh started for parallel degree <degree value>
<patterntype> patterns delta refresh completed for parallel degree <degree value>
where:
- <patterntype> is
Match All
,Counter
, orWeighted Counter
. - <degree value> is the value with which patterns are processed in parallel.
For example, when the degree value is 2, the following messages are logged:
MatchAll patterns delta refresh started for parallel degree 1
MatchAll patterns delta refresh completed for parallel degree 1
MatchAll patterns delta refresh started for parallel degree 2
MatchAll patterns delta refresh completed for parallel degree 2
UARI_PATTERNSTATE_INFO
table
To verify if the UARI_PATTERNSTATE_INFO
table is refreshed, look for the
following text:
MESSAGE_LINE:
Pattern State information refresh procedure started
--The procedure to refresh the data in UARI_PATTERNSTATE_INFO is running.
MESSAGE_LINE:
Pattern State information refresh procedure completed
--The procedure to refresh the data in UARI_PATTERNSTATE_INFO is completed.
Lock flags reset by the SP_AGGR_RUN_STATUS
procedure
To verify if the lock flags are reset by the SP_AGGR_RUN_STATUS
procedure, look
for the following text:
MESSAGE_LINE:
patterns lock has been reset for parallel degree <degree value>
The OBJECT
column of the UARI_DELTA_REFRESH_LOG
table contains
the procedure name for which the lock is reset.
where: <degree value> is the value with which patterns are processed in parallel.
For example, when the degree value is 1, the following message is logged:
patterns lock has been reset for parallel degree 1
For DB2 only: rebinding of packages
For DB2 only: to verify that rebinding of the packages completed, look for the following text:
MESSAGE_LINE:
Rebind of packages started
--Rebinding of the packages started
MESSAGE_LINE:
Rebinding of packages completed successfully on <datetime>
--Rebinding of the packages completed successfully on the given date.
Statistics updated on ETL tables
To verify if the statistics were updated on the ETL tables, look for the following text:
MESSAGE_LINE:
Table statistics update started
--Update statistics on the ETL tables is in process
MESSAGE_LINE:
Statistics on Tables UACI_ETLPATTERNSTATE UACI_ETLPATTERNSTATEITEM
UACI_ETLPATTERNEVENTINFO and indexes have been updated successfully
on <datetime>
--Statistics are updated on the mentioned ETL tables on the given date.
Degree of parallel execution
To verify the degree of parallel execution, look for the following text:
MESSAGE_LINE:
Pattern aggregation processing Parallel degree is set to <degree value>
--Parallel degree with which report aggregation will run is set to <degree value>.
For example, when the degree value is 2, the following message is logged:
Pattern aggregation processing Parallel degree is set to 2.