Supply chain | Supply Chain Management, Commerce

Data sync to Offline DB

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (4)

Answers (0)

Xusheng on at

Like (0)

Report

Is there any failed event log for this issue?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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)

Was this reply helpful? Yes No
Suggested answer

Xusheng on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Oksana Kovaliova 3,597 on at

Like (0)

Report

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.

Was this reply helpful? Yes No