topic Delay in replication in Qlik Replicate

Delay in replication

TaylorN — Thu, 20 Feb 2020 04:45:21 GMT

I am replicating from Oracle 11g to Azure SQL DB (using redo logs). I have only just set this up within the last few days, but I have noticed very big gaps in the delay of processing. i.e. I can see changes in my source DB, but they aren't being picked up by Replicate for sometimes 1 hour or more.

Re: Delay in replication

Ted_Manka — Tue, 25 Feb 2020 20:44:41 GMT

Hello Taylor,

I would recommend increasing your log levels for source capture, target apply and performance to trace level. Then you should be able to see when the latency starts to increase and what is happening during that time or just before. Also look to see if there are errors or 1-1 mode is taking over.

Thank you,

Ted Manka

Re: Delay in replication

TaylorN — Tue, 25 Feb 2020 20:49:23 GMT

@Ted_Manka , thanks I have enabled verbose logging now to see how things go for a couple of hours.

I've also just noticed another issue where some records are not being brought across from the source DB. Some of the errors in the apply_exceptions table are updates with 0 rows affected because the original row was never inserted.

The one with most of the errors, the source table has 102 318 367 rows and the target has 102 315 014 rows which is a bit of a concern.

Is there potentially a way to insert the missing data, if the update statement yields no effect?

Re: Delay in replication

Ted_Manka — Wed, 26 Feb 2020 16:46:10 GMT

Hello @TaylorN ,

If you open a new post for the new issue and tag me I will answer you there 😀

Thank you,

Ted Manka