Skip to content
Microsoft Dynamics 365 Blog

Credit to Brian Storie for the contribution provided.

Symptom

Microsoft.Synchronization.Data.DbSyncException: Cannot find a valid scope with the name ‘YourTable’ in table ‘[scope_info]’. Ensure that this scope exists and that it has a corresponding valid configuration in the configuration table ‘[scope_config]’.

Cause

You have created a new Offline scope, added it to the POS Offline profiles form and run the 1095 job without deprovisioning it properly in your Channel database. The Channel database turned out to be in an invalid state.

Solution

  1. Backup Channel database.
  2. Open command prompt with elevated privilege and run the following command line: C:\Program Files (x86)\Microsoft Dynamics AX\60\Retail Database Utility>RetailDbUtilityCmd.exe DeprovisionChannelDB                  /StoreServername:<YourStoreServerName> /StoreDatabaseName:<YourStoreDatabaseName>
  3. Check if all the _tracking tables are successfully deleted in your Channel database.
  4. Open and run “Retail Channel Configuration Utility” as administrator.
  5. Select “Create offline database”.  Specify your Channel database and offline database information, click “Apply” to recreate the offline database again.
  6. Channel database and offline database should be provisioned successfully.

 

We're always looking for feedback and would like to hear from you. Please head to the Dynamics 365 Community to start a discussion, ask questions, and tell us what you think!

Join the conversation

Loading comments...