Monday, September 24, 2018

Steps to configure retail when copying or restoring database between environments in Dynamics 365 Retail


Hi Guys,

The general business scenario we will be moving database from Production servers to Sandbox, UAT, DEV servers and after every restore there are few steps we need to follow to make system up and running.

I would like to list out the steps needs to be followed to configure retail when copying or restoring database between environments in Dynamics, please find the same below.

1. Run the Environment retargeting tool from LCS.

When you do any kind of copying between environments in Dynamics there are some settings related to Retail which are copied that are actually wrong for the destination environment.
To fix these you need to apply tool called Environment retargeting tool  and also its knowsn Retail Reprovisioning tool.

This tool needs to be run every time we do restore and all the environments. Irrespective if they use Retail components or not.

a.      Please make sure that we have the latest version of the tool.
b.      To check the same go to LCS – Asset Library. Go to Software Deployable Packages – Import  and Select the latest Environment Reprovisioning tool.


c.      Please select the latest tool and click on Apply.



d.      Once its applied then it will get Queued and start servicing, this operation will finish within 30 min (Please make sure to use latest version of tool).

      2. Once retargeting tool applied then you need to run these five steps.
a.      Navigate to the “Organization administration > Number sequences > Number sequences” and click on “Generate” 



b.      Open the "Retail Parameters" form, and press the "Initialize" link under the "General" tab. Answer "Yes" to the prompt. This will provide any new Retail seed data. 



c.      Open the "Initialize Retail Scheduler" form, and run it with "delete existing configuration" set to "yes". 



d.      Restart the "Microsoft Dynamics AX Batch Service" on all AOS VMs. This will update any cached connection credentials that may be used when running a CDX data sync. (done by DSE if PROD) 


e.      Navigate to the "Channel Database" form and run a CDX 9999 sync (full sync). This should succeed if everything is properly configured for retail. 



And also please have a look at blog to understand about Datawriting batch job

 Hope this helpful and Next post will be explain common issues we face when we run distribution scheduler job.

Thanks for reading!


2 comments: