Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Suggest an Idea

Announcements
This page is no longer in use. To suggest an idea, please visit Browse and Suggest.

Add column in attrep_status to specify last processed timestamp from source system

Prabodh
Creator II
Creator II

Add column in attrep_status to specify last processed timestamp from source system

The attrep_status table provides the replication status at a task level. This table is updated every minute.

This table contains 'SOURCE_TIMESTAMP_APPLIED' column which tells the timestamp until which the data is applied to the target. There are a few other columns that provide additional information.

However, we are looking to build a monitoring process to determine if the task has processed all the data for a given day. If we see SOURCE_TIMESTAMP_APPLIED value > midnight, we can confidently say that the task has processed all the data for the prior day for the tables it is replicating.

However, this is not a foolproof solution. If the tables being replicated within the task are not high velocity, then the SOURCE_TIMESTAMP_APPLIED corresponds to the time when data was committed to target for the task.

E.g. if the tables within the task are only updated in CST business time, we may not see any change to SOURCE_TIMESTAMP_APPLIED post 5:00 PM CT. Our monitoring process cannot determine if the data for these tables was processes for yesterday, as it has no way to know that there was no data in source after 5 PM.

 

I would like to propose an enhancement to add 'SOURCE_TIMESTAMP_PROCESSED' or equivalent column. This should be the timestamp value of the most recent transaction from source that was completely processed. This transaction may or may not produce any data for the tables in that task.

2 Comments
Meghann_MacDonald

From now on, please track this idea from the Ideation portal. 

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Ideation
Newbie
Newbie
 
Status changed to: Closed - Archived