Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Commerce forum / Data sync to Offline DB
Commerce forum
Suggested answer

Data sync to Offline DB

Posted on by Microsoft Employee

Hi..We would like to seek your advice on this matter

We have a project Dynamics AX 2012 R3 (The latest version) in Retail Company. We put it in Azure. 

Our problem is about data sync to Offline DB (we have Offline DB in all POS Clients). For example: We create a promo on HQ (AX). Store DB updated properly, POS1 updated properly, POS2 updated properly, but POS3 was not updated. Sometimes POS1 was not updated, but POS2 updated properly and POS3 updated properly (doesn't have a regular pattern).

We have a temporary solution (re-build Offline DB), but it didn't last long. Data sync problem will come back again.

Any recommendation would be very much appreciated. Thank You

  • Oksana Kovaliova Profile Picture
    Oksana Kovaliova 3,586 on at
    RE: Data sync to Offline DB

    Hi,

    What do you mean by 'updated property' - data syncs or database redeployments?

    About error you get - try to search 'the first error' from where problem started.

    'Remote peer is outdated' usually means, that offline sync was failing to execute successfully many times - and sync knowledge has expired. Probably, you have some tables that are huge and sync fails with timeouts, probably some SQL operations are slow, etc.

  • Suggested answer
    Xusheng Profile Picture
    Xusheng on at
    RE: Data sync to Offline DB

    I suggest you log a new service request to double check with Microsoft retail support team. then they will help fix this issue for you.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Data sync to Offline DB

    Hi Steven..

    We found the below error message:

    Microsoft.Synchronization.Data.DbOutdatedSyncException: Cannot enumerate changes at the RelationalSyncProvider because the remote peer is outdated. See the OutdatedDbSyncException that was thrown for more details.

      at Microsoft.Synchronization.Data.RelationalSyncProvider.GetChangeBatch(UInt32 batchSize, SyncKnowledge destinationKnowledge, Object& changeDataRetriever)

      at Microsoft.Synchronization.KnowledgeProviderProxy.GetChangeBatch(UInt32 dwBatchSize, ISyncKnowledge pSyncKnowledge, ISyncChangeBatch& ppChangeBatch, Object& ppUnkDataRetriever)

      at Microsoft.Synchronization.CoreInterop.ISyncSession.Start(CONFLICT_RESOLUTION_POLICY resolutionPolicy, _SYNC_SESSION_STATISTICS& pSyncSessionStatistics)

      at Microsoft.Synchronization.KnowledgeSyncOrchestrator.DoOneWaySyncHelper(SyncIdFormatGroup sourceIdFormats, SyncIdFormatGroup destinationIdFormats, KnowledgeSyncProviderConfiguration destinationConfiguration, SyncCallbacks DestinationCallbacks, ISyncProvider sourceProxy, ISyncProvider destinationProxy, ChangeDataAdapter callbackChangeDataAdapter, SyncDataConverter conflictDataConverter, Int32& changesApplied, Int32& changesFailed)

      at Microsoft.Synchronization.KnowledgeSyncOrchestrator.DoOneWayKnowledgeSync(SyncDataConverter sourceConverter, SyncDataConverter destinationConverter, SyncProvider sourceProvider, SyncProvider destinationProvider, Int32& changesApplied, Int32& changesFailed)

      at Microsoft.Synchronization.KnowledgeSyncOrchestrator.Synchronize()

      at Microsoft.Synchronization.SyncOrchestrator.Synchronize()

      at Microsoft.Dynamics.Retail.Offline.Sync.Synchronizer.SynchronizeScope(RETAILOFFLINESCOPE scope)

  • Xusheng Profile Picture
    Xusheng on at
    RE: Data sync to Offline DB

    Is there any failed event log for this issue?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,914 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,549 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans