Synchronizationissue between Offline database and Store database
We recently had a case where an offline POS refused to sync transactions to the store database afterit came back online. This retail systemconsisted of a centralized store database and an offline database for each ofthe POS machines. On each POS the Microsoft Dynamics AX for Retail Offline Sync Service was running to synchronize the offline database with thestore database. The offline databases were created using the Retail Database Utility and had data, so offline sync had been working at one point.
To troubleshoot, we enabled tracing on the AX for RetailOffline 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)
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 RetailDatabase Utility. In order to recreate these tables in just the store database we created a new offline database usingthe utility (making sure to create a backup of the existing offline database). After this we ran the N-1095job and restarted the AX for Retail Offline Sync Service which resolved the issue.
Microsoft Sync Framework documentation
How to: Provision and DeprovisionSynchronization Scopes and Templates
ReleaseNotes for Microsoft Sync Framework 2.1
Authors: Shane Erstad & Kim Truelsen
i am also facing same problem. But I have all tables in my database which i have provisioned.... :(
I am having the same issue as Mohini
Tracking tables have NULL value in scope tables.
Please suggest resolution. thanks