Customer reports data is not in sync between SAP and Qlik 'datalake'

[tiewoods]

I get a request to reload the SAP table LIKP table as it is out of sync.  One engineer will send me a query from SAP and the same from the datalake and I can see missing data.  Again once I run a reload the issue goes away.  The customer has raised this to management as it has happened multiple times.  Can someone point me to any documents or log files that I can review to see where the error occurred?

Version of Qlik Replicate is -> November 2024 (2024.11.0.177)

[john_wang · Accepted solution]

Hello @tiewoods ,

You are running the 2024.11 GA release. The later patches, SP1 and SP2, include several defect fixes for the SAP source endpoint (though I’m not sure which endpoints you are currently using) and one fix for the Databricks target.

We recommend the following steps:

1. Upgrade to SP2 – This is the latest build as of today. https://files.qlik.com/url/qr2024110374sp02 (expires 5/31/2025)

2. Enable verbose logging – Set SOURCE_CAPTURE to Verbose, reproduce the issue, and collect the task Diagnostics Package.

3. Process the logs – Decrypt the generated task log files and compress them.

4. Provide missing data details – Share information about the missing data, including the affected time range, primary key value(s), and any other details that can help uniquely identify the missing rows.

5. Open a support ticket – Submit a ticket with the above information. Our support team will be happy to assist you.

Regards,

John.

[tiewoods]

Thank you, John.  I have scheduled an update for this Friday.  Afterwards, I'll update this with any details.

[tiewoods]

I have applied the Service pack and we are now at this version -> 2024.11.0.374
I will wait to hear from my staff on anything that is out of sync.
Once this happens then I will apply John's steps and see if I can isolate the issue.

Please close this for now and I'll update this article when/if this happens.