When you do any kind of copying between environments in Dynamics there are some settings which are copied that are actually wrong for the destination environment. To fix these you need to run a tool called Retail Reprovisioning tool (also called Environment retargeting tool)
At the beginning this was only supposed to be run for environments actively using the Retail Components. The recommendation at the moment (2017-11-29) is to run it for every environment since al of the actually contains Retail components.
1. To make sure that you have the latest version of the tool go to LCS – Asset Library. Go to Software Deployable Packages – Import and Select the latest Environment Reprovisioning tool.
2. The next step is different depending on which type of environment you are using.
If you are using a 2-tier environment; go to the environment, select Maintain and Apply Updates. Select the Environment Reprovisioning tool and click Apply. Continue to Step 5
If you are using a Dev environment you are not able to deploy using LCS and you will have to deploy from command line according steps 3 – 4
3. Unblock the downloaded file by Right-clicking the file and going to Properties – General Unblock for the fil
4. Extract the file to a temporary directory
Install using these command lines:
Fix the DefaultTopologyData.xml and make it look like this:
<?xml version="1.0" encoding="utf-8"?> <TopologyData xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <Name>AX topology</Name> <MachineList> <Machine> <Name>localhost</Name> <ServiceModelList> <string>RetailServer</string> <string>ALMService</string> <string>AOSService</string> <string>BIService</string> <string>DevToolsService</string> <string>DIXFService</string> <string>DocumentRoutingAgent</string> <string>MROneBox</string> <string>PayrollTaxModule</string> <string>PerfSDK</string> <string>ReportingService</string> <string>RetailCloudPos</string> <string>RetailHQConfiguration</string> <string>RetailSDK</string> <string>RetailSelfService</string> <string>RetailStorefront</string> <string>SCMSelfService</string> <!-- DefaultTopologyData are only for dev vhd, which we only support AOS update--> <!-- Create a new topology data for your Cloud AX topology--> </ServiceModelList> </Machine> </MachineList> <BackupScript> <FileName /> <Automated>false</Automated> <Description>Please backup your environment now, set this step to complete once you finished backup</Description> </BackupScript> </TopologyData>
Generate The Runbook
AXUpdateInstaller.exe generate -runbookid=[runbookID] -topologyfile=[topologyFile] -servicemodelfile=[serviceModelFile] -runbookfile=[runbookFile]
AXUpdateInstaller.exe import -runbookfile=[runbookFile]
Verify the runbook
Execute the runbook
AXUpdateInstaller.exe execute -runbookid=[runbookID]
5. After the retargeting tool is run you need to run these four steps
a. 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.
b. Open the “Initialize Retail Scheduler” form, and run it with “delete existing configuration” set to “Yes“.
c. 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 => you need to raise a ticket)
d. Navigate to the “Channel Database” form and run a CDX 9999 sync (full sync). This should succeed if everything is properly configured for Retail.
6. Sometimes there is issues with some columns in some tables in the channel database looses their setting for full text indexing (this seems to be an effect of the BacPac procedure when sopying to and from an Azure Environment), this results in not being able to search in for instance MPOS. To verify this you can use this script:
SELECT SCHEMA_NAME(t.schema_id) as TableSchema, t.name AS TableName, c.name AS CatalogName , i.name AS UniqueIdxName, cl.name AS ColumnName, COLUMNPROPERTY(t.object_id, cl.name, 'IsFulltextIndexed') as IsFullTextEnabledOnTable, fi.is_enabled AS isEnabledOnColumn FROM sys.tables t INNER JOIN sys.fulltext_indexes fi ON t.[object_id] = fi.[object_id] INNER JOIN sys.fulltext_index_columns ic ON ic.[object_id] = t.[object_id] INNER JOIN sys.columns cl ON ic.column_id = cl.column_id AND ic.[object_id] = cl.[object_id] INNER JOIN sys.fulltext_catalogs c ON fi.fulltext_catalog_id = c.fulltext_catalog_id INNER JOIN sys.indexes i ON fi.unique_index_id = i.index_id AND fi.[object_id] = i.[object_id] where c.name like 'COMMERCEFULLTEXTCATALOG' order by Tablename ASC
look for the ones having a ‘0’ in any column and fix them by runing:
ALTER FULLTEXT INDEX ON [ax].tablename ENABLE
ALTER FULLTEXT INDEX ON [ax].tablename SET CHANGE_TRACKING=MANUAL; GO<span id="mce_marker" data-mce-type="bookmark" data-mce-fragment="1"></span>
ALTER FULLTEXT INDEX ON [ax].tablename START FULL POPULATION; GO
ALTER FULLTEXT INDEX ON [ax].tablename SET CHANGE_TRACKING=AUTO; GO<span id="mce_marker" data-mce-type="bookmark" data-mce-fragment="1"></span>