Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Discussion board for collaboration on Qlik Replicate.
I've noticed an 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.
I have set the error handling rule to insert the row if missing, but I’m still concerned as to why these inserts are missing in the first place.
Edit: I hadn't restarted the task since changing the above setting, now it fails to start as it tries to enable supplemental logging on every column of every table! Is this necessary for the "No record found for applying an UPDATE: INSERT the missing target record" setting to work?