topic Re: "Incorrect timestamp" in logs in Qlik Replicate

"Incorrect timestamp" in logs

MoeE — Tue, 13 Feb 2024 03:57:15 GMT

Hi Support,

I am seeing these "incorrect timestamp" messages in the logs. Are they indicative of an issue or normal?

Regards,

Mohammed

Re: "Incorrect timestamp" in logs

john_wang — Tue, 13 Feb 2024 04:06:52 GMT

Hello @MoeE ,

Thanks for reaching out to Qlik Community!

What's the source DB type? there is some problem of the change data metadata, eg one line the change data epoch timestamp is

1707787745870000

however the current timestamp is

1707787745720236

where seems the change data time is a 'future time'. please check the source DB OS time is set correctly or not.

Hope this helps.

John.

Re: "Incorrect timestamp" in logs

MoeE — Tue, 13 Feb 2024 04:15:36 GMT

Hi Jon,

Source db is SQL Server. I'll check now. Would there be any issues with the replicate/source/target servers being in different timezones?

Regards,

Mohammed

Re: "Incorrect timestamp" in logs

john_wang — Tue, 13 Feb 2024 08:51:40 GMT

Hello @MoeE ,

You are right. Please check the time difference between SQL Server server and Replicate Server machines.

Regards,

John.

Re: "Incorrect timestamp" in logs

SushilKumar — Wed, 14 Feb 2024 07:17:51 GMT

Hello Team,

If our response has been helpful, please consider clicking "Accept as Solution". This will assist other users in easily finding the answer. if you require further assistance, please raise a Support case.

Regards,

Sushil Kumar