topic urgent help needed for Missing records issue in Qlik Replicate

urgent help needed for Missing records issue

Mohanty — Fri, 19 Jul 2024 11:43:33 GMT

My source is Oracle and targe is Databricks. recently I found some records are missing to insert/update. While investigating found "attrep_changes..." table is dropped at target. may be before applying to target it is dropped. There was connection issue i can see in Qlik Replicate Log. Any one can help to handle such issue?

Re: urgent help needed for Missing records issue

john_wang — Fri, 19 Jul 2024 14:16:08 GMT

Hello @Mohanty ,

Welcome to Qlik Community forum and thanks for reaching out here!

I'd like suggest you opening a support ticket with below information:

1- Set source_capture/target_apply to Verbose, re-create the issue, then download the task Diag Package;

2- Decrypt the newly generated task log file, compress it and attach it to support case

3- Attach the source table and target table creation DDL include PK and Unique index information.

Our support team will be more than happy to assist you.

Regards,

John.

Re: urgent help needed for Missing records issue

DesmondWOO — Sat, 20 Jul 2024 17:16:41 GMT

Hi @Mohanty ,

Please also find following article for troubleshooting missing data.

Troubleshooting Missing Data using Change Tables in Qlik Replicate

Regards,
Desmond