Archive Log Date & Time

[RamdasP]

Hi,

We have an Oracle DB whose archive logs are mined through Qlik Replicate. Is there an API in Qlik Replicate to find out the time up to which Qlik Replicate has processed the archive log.

This is to ensure that if an ETL process is kicked off at 4 AM all the delta's (from the source DB) up to 4 AM has been processed by Qlik Replicate.

Kind Regards

Ramdas

[Heinvandenheuvel · Accepted solution]

You can use 'current date-time' minus 'source-latency' to determine how far the logs have been processed.

The latency can be obtained through the GetTaskDetails EnterpriseManager  API reponse 

"cdc_latency":{ "source_latency":"{int32}",  "total_latency":"{int32}", }

API Guide - Qlik Enterprise Manager , November 2020 SR1 562 Enterprise Manager REST API

That value can also be found using REPCTL  GETTASKSTATUS command line output.

Alternatively you could scan the teptask_xxx.log for the task looking for lines like:

>>>  Start processing archive Redo log sequence 76203

Combine the information with first_time/last_time/sequence# from Oracle's v$archived_log

Cheers,

Hein.