Skip to main content
Dynamics 365

AX2012 Retail: Microsoft Dynamics AX for Retail Offline Sync Service fails to synchronize transactions from offline database

 

Synchronization
issue between Offline database and Store database

 

 

Issue description

 We recently had a case where an offline POS refused to sync transactions to the store database after
it came back online.  This retail systemconsisted of a centralized store database and an offline database for each of
the POS machines.   On each POS the Microsoft Dynamics AX for Retail Offline Sync Service was running to synchronize the offline database with the
store database. The offline databases were created using the Retail Database Utility and had data, so offline sync had been working at one point.

  

Troubleshooting

 

To troubleshoot, we enabled tracing on the AX for Retail
Offline Sync Service as described in this article:  

 

The outcome was following:

 

ERROR  , Microsoft.Dynamics.Retail.Offline.Service, 21,
  08/13/2012 14:59:20:313, The current operation could not be completed because
  the database is not provisioned for sync or you not have permissions to the
  sync configuration tables. Exception: Microsoft.Synchronization.Data.DbNotProvisionedException:
  The current operation could not be
  completed because the database is not provisioned for sync or you not have
  permissions to the sync configuration tables.

   at
  Microsoft.Synchronization.Data.SqlServer.SqlManagementUtils.VerifyRuntimeVersionExceedsSchema(SqlConnection
  connection, String objectPrefix, String objectSchema, Boolean
  throwWhenNotProvisioned)

 

 

 

Solution

 

We discovered that the store database was missing three tables that manage the sync configuration:  scope_info, scope_config, and schema_info. 

 

These tables are normally created in the process of creating any new offline database using the Retail
Database Utility.  In order to recreate these tables in just the store database we created a new offline database using
the utility (making sure to create a backup of the existing offline database).  After this we ran the N-1095
job and restarted the AX for Retail Offline Sync Service which resolved the issue.

 

 

Related documentation

 

Microsoft Sync Framework documentation

http://msdn.microsoft.com/en-us/library/bb902854.aspx

 

How to: Provision and Deprovision
Synchronization Scopes and Templates

http://msdn.microsoft.com/en-us/library/ff928603.aspx

 

Release
Notes for Microsoft Sync Framework 2.1

 

http://download.microsoft.com/download/E/8/8/E8819A3A-E994-4A1C-B318-1E9DD2E936DB/SyncFramework_2.1_ReleaseNotes.htm

 

 

 

Authors: Shane Erstad & Kim Truelsen

Date: 15/8-2012