Synchronizing local SQLite Databases between different time zones

[ricardoamm]

Hello,

I'm facing some strange issues, where some local SqlLite Providers are not receiving changes for the same scope.
Could the fact that they are in different time zones create any time of problem due diferent timestamps?

Regards

[Mimetis]

The timestamp value calculated by SQLite every time a record is saved in the tracking table is basically calculated using this SQL statement:

Select replace(strftime('%Y%m%d%H%M%f', 'now'), '.', '')

In SQLite, Datetime('now') is basically returning the UTC Datetime.

So it should not be a problem when regarding different timezones.

[Mimetis]

On the server side, are you using Sql Server Change Tracking ?
If yes, what is your retention period parameter ?

[ricardoamm]

yes, 14 days

[Mimetis]

Can it be the cause of this out of date issue ?

[ricardoamm]

The error happened less than a day after the previous successful sync.

[Mimetis]

Hum, that's weird ....
It's only happens from some specific clients or it can happens to any client ?
Are you doing specific things that can help to debug this issue ?