BeyondERP.Newsletter
Menu

Setup page · Retail and Commerce

Commerce scheduler parameters

A setup page holding the parameters that govern Commerce Data Exchange synchronization, such as the retry count for failed sessions, the full dataset generation interval, post database sync options and, for AX 2012 R3 channels, the headquarters message database connection.

Used by
Retail operations manager, Retail store IT, Retail store manager
Business process
Manage sales channels
Menu item
RetailConnParameters
Main table
RetailConnParameters
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page holding the parameters that govern Commerce Data Exchange synchronization, such as the retry count for failed sessions, the full dataset generation interval, post database sync options and, for AX 2012 R3 channels, the headquarters message database connection.
What you do hereUse this page to tune how CDX retries failed download sessions, whether full datasets are regenerated on a timer, and which clean-up and statistics steps run after each download session is applied.
ExampleFor example, Microsoft recommends a Try count of 3 and a Full dataset generation interval in days of 0 so that full dataset generation only happens when something other than time requires it.
Commerce scheduler parameters page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processDevelop sales policies › Manage sales channels
Menu pathRetail and Commerce › Headquarters setup › Parameters › Commerce scheduler parameters
Set up firstCommerce parameters (Initialize) Microsoft Learn
Related pagesCommerce shared parameters Microsoft Learn
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Setup steps on this page

Set up Commerce scheduler parameters

Use this page to tune how CDX retries failed download sessions, whether full datasets are regenerated on a timer, and which clean-up and statistics steps run after each download session is applied.

Steps from Microsoft

  1. Go to Retail and Commerce > Headquarters setup > Parameters > Commerce scheduler parameters.
  2. Set Try count to 3.
  3. Verify that Full dataset generation interval in days is 0.
  4. Under Post database sync, decide whether to enable Clean up irrelevant master data after sync and Optimize database statistics automatically.
  5. Select Save.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Try countNumber of times a failed download session application is retried before it is suspended.Microsoft Learn TryCount
Full dataset generation interval in daysTimer for regenerating full datasets; 0 means full generation only happens when something else requires it.Microsoft Learn
Clean up irrelevant master data after syncRuns the Strip Master Data procedure after each download session to delete records not needed by that device's store.Microsoft Learn StripMasterData
Optimize database statistics automaticallyUpdates table statistics for each table in a download session applied to the channel database.Microsoft Learn
SQL Server instance name (HQ Message Database)SQL Server instance hosting the AX 2012 R3 headquarters message database, used only for N-1 setups.Microsoft Learn
Server name (HQ Message Database)Server hosting the AX 2012 R3 headquarters message database.Microsoft Learn
Database name (HQ Message Database)Name of the AX 2012 R3 headquarters message database, by default HQMessageDB.Microsoft Learn

Test checklist

  1. Set Try count = 3 and Full dataset generation interval in days = 0.
  2. Run a distribution job such as 1040 for a channel database group.
  3. Open Download sessions and check the session is applied without retries.
  4. If Optimize database statistics automatically is on, check CDX_ENABLE_UPDATE_STATISTICS_FOR_REQUIRED_TABLE = 1 exists in Commerce shared parameters.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Commerce scheduler parametersTry count = 3 and Full dataset generation interval in days = 0Learn's CDX best practices give these values: full datasets are then only generated when something other than time needs them, which reduces errors and performance issues.Setting Try count too high: download sessions might fail during periods of high usage. Turning on Clean up irrelevant master data after sync without testing in a sandbox can break custom SQL views.
Solution architect

5Design impact

Can it be undoneReversible: Settings can be changed at any time and apply to later download sessions. Microsoft Learn
If you change it laterSetting Try count too high can make download sessions fail during busy periods, and the clean-up option should be tested in a sandbox because custom SQL views can introduce table dependencies it is not aware of. Microsoft Learn
Technical architect

6Technical

Menu itemRetailConnParameters Checked in Dynamics 365
FormRetailConnParameters Checked in Dynamics 365
TableRetailConnParametersShown as “SCHEDULER PARAMETERS” in Record infoChecked in Dynamics 365
Who can open itPrivilegesMaintain retail parameters RetailParametersMaintainDutiesMaintain retail parameters RetailParametersMaintain
3 security rolesRetail operations manager RetailOperationsManagerRetail store IT RetailStoreITRetail store manager RetailStoreManager
Checked in Dynamics 365
Roles to set it up and use itTo use itRetail operations manager RetailOperationsManagerRetail store manager RetailStoreManagerRetail store IT RetailStoreITGive people one of these roles. On this system, 3 roles can open this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): Get configuration data, Purge history data, Reset metadata synchronizationChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=RetailConnParameters
Table definitionRetailConnParameters columns and relations Microsoft data model
Everyone

8Sources