Archive Log Date & Time

RamdasP — Thu, 20 Oct 2022 13:22:09 GMT

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

Re: Archive Log Date & Time

Heinvandenheuvel — Thu, 20 Oct 2022 13:53:55 GMT

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.

topic Archive Log Date & Time in Qlik Replicate

Archive Log Date & Time

Re: Archive Log Date & Time