Skip to main content

Notifications

Supply chain | Supply Chain Management, Commerce
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,595 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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans