Supply chain | Supply Chain Management, Commerce

Retail Environment Reprovisioning Retarget Tool on VHD

(0) Share

Report

Posted on by MYGz

1,862

Hello,

What is the process of running Environment Reprovisioning tool on VHD environment.

I have restored the Database from UAT (Update 20) to Local VHD (Update 10.0.13)

The modules implemented in UAT are Finance, SCM, Payroll and Retail/Commerce.

I want to run Retail Retarget tool on the VHD. I have downloaded it from LCS and tried running it:

But I'm getting below error:

Is there a blog to explain how it can be run on VHD?

---------------Update1-----------

I followed this Blog Using the Retail Reprovisioning tool for Dynamics 365 for Operations – JohanPersson.nu

and ran the Runbook command but getting below error:

Appreciate any tips.

Regards,

All responses (25)

Answers (0)

MYGz 1,862 on at

Like (0)

Report

RE: Retail Environment Reprovisioning Retarget Tool on VHD

Had another call with someone at microsoft.

The Microsoft person said if you restore UAT tier-2 to VHD/Development tier-1, the CRT, POS tables will be gone.

The developer is saying if you run the reprovisioning tool on LCS, the tables come back again but the microsoft person is saying they won't and reprovisioning tool won't help.

Confused as who is correct here.

The reprovisioning tool succeeded on VHD and the Jobs are still not running.
MYGz 1,862 on at

Like (0)

Report

RE: Retail Environment Reprovisioning Retarget Tool on VHD

Thanks Jeffrey. I had asked client for this. He is taking time. Meanwhile after a meeting with someone from Microsoft this is what they have sent us. It does makes sense that store database is separately installed on stores. But is a copy of the tables at store also maintained at HQ? Need your opinion on the below response.

"

Feedback :

As discussed over call and screen sharing session, retarget tool is working on development environment now but this shall not help in syncing the jobs.
As I mentioned in our first call that development box and UAT/Production are two different tiers of Dynamics 365 F&O. These both have different architecture and working style. Since you have restored Tier 3 DB on Tier 1 machine that is why Retail CDX will not work here with this database.

The difference between both of these tiers is their architecture.
Tier 1 is a single box environment with a single database for all HQ, POS and commerce runtime operations. Whereas tier2 or Tier 3 have different databases for HQ, CRT and POS operations. Now the scenario is that you have restored database with only HQ schema in it and trying to perform crt operations which does not exist there. This will not work.

During the call, you also mentioned that you are doing all this for customization of Modern POS.
For customization of Modern POS all this is not required. I have shown you the SDK from where you can create custom Modern POS package and deploy it on UAT environment through LCS.
Also we have installed and configured 10.0.20 Modern POS on your machine and activated it through UAT CSU.

In case you still want to sync jobs on development box you shall have to restore its original demo database which contains all HQ, POS and crt tables. But I would again suggest to follow the correct way for customization of Modern POS where all these things are not required.

"
JeffreyPW 228 on at

Like (1)

Report

RE: Retail Environment Reprovisioning Retarget Tool on VHD

Even Microsoft's documentation says its not generally needed anymore:

docs.microsoft.com/.../dbmovement-scenario-exportuat

"The Environment re-provisioning step has now been fully automated as part of database movement operations, and no longer needs to be run manually. The Environment re-provisioning tool is still available in the Asset Library and may be used in certain situations to mitigate error conditions."

OP, just try what i said earlier... Start with a fresh VHD, import the UAT bacpac, etc. and then take a snapshot (I use vmware, so whatever the hyper-v equivalent is) to save you time so you can revert if you have issues. Follow the instructions on the link above... I did this same migration from a tier-2 to a dev vhd just last week....
Juliet Zhu on at

Like (0)

Report

RE: Retail Environment Reprovisioning Retarget Tool on VHD

For Tier-2 sandbox or production, you don't need the Reprovisioning tool anymore.

But if I understand it correctly, this is a Tier-1 dev box. If so, you still need it after database refresh.

We've seen similar database connection error before, which was caused by SSL invalidation error, because RS web.config is using "localhost" but SSL certification is assigned to the PC name. You need to update the DataAccess.DBServer line in the Retail Server Web.config file from the current value of "localhost" to the actual PC name. Once that is complete, you just need to re-run the tool.

Once the reprovisioning tool is successfully finished, you may start to run all distribution scheduler jobs.

Thanks,

Juliet
MYGz 1,862 on at

Like (0)

Report

RE: Retail Environment Reprovisioning Retarget Tool on VHD

Thanks Jeffrey, Juliet.

Juliet Zhu I replaced localhost with server name,

Now the jobs are running but failing with error:

Microsoft.Dynamics.Ax.Xpp.ErrorException: CDX download job 1200 failed to be initialized for performing the data transfer operation.
at Dynamics.AX.Application.RetailCDXDataSync.`initialize() in xppSource://Source/Foundation\AxClass_RetailCDXDataSync.xpp:line 117
at Dynamics.AX.Application.RetailCDXDataSync.initialize()
at Dynamics.AX.Application.RetailCDXDataSync.`run() in xppSource://Source/Foundation\AxClass_RetailCDXDataSync.xpp:line 607
Microsoft.Dynamics.Ax.Xpp.ErrorException: Cannot execute the required database operation.
The SQL database has issued an error.
at Microsoft.Dynamics.Ax.MSIL.Interop.throwException(Int32 ExceptionValue, interpret* ip)
at Microsoft.Dynamics.Ax.MSIL.cqlClassIL.Call(IntPtr c, String methodName, Object[] parameters, Type[] types, Object[] varargs, Type[] varargsTypes)
at Microsoft.Dynamics.Ax.Xpp.XppObjectBase.Call(String methodName, Object[] parameters, Type[] types, Object[] varargs)
at Dynamics.AX.Application.NativeStatementImplementation.executeUpdate(String _statement)
at Dynamics.AX.Application.Statement.executeUpdate(String _statement)
at Dynamics.AX.Application.RetailCDXChangeTrackingAux.`executeSqlStmt(Statement stmt, String sql) in xppSource://Source/Retail\AxClass_RetailCDXChangeTrackingAux.xpp:line 59
at Dynamics.AX.Application.RetailCDXChangeTrackingAux.executeSqlStmt(Statement stmt, String sql)
at Dynamics.AX.Application.RetailCDXChangeTracking.`runChangeTracking_table(Int32 tid) in xppSource://Source/Foundation\AxClass_RetailCDXChangeTracking.xpp:line 156
at Dynamics.AX.Application.RetailCDXChangeTracking.runChangeTracking_table(Int32 tid)
at Dynamics.AX.Application.RetailCDXDataSync.`trackChannelDBAssignment() in xppSource://Source/Foundation\AxClass_RetailCDXDataSync.xpp:line 421
at Dynamics.AX.Application.RetailCDXDataSync.trackChannelDBAssignment()
at Dynamics.AX.Application.RetailCDXDataSync.`initialize() in xppSource://Source/Foundation\AxClass_RetailCDXDataSync.xpp:line 96
JeffreyPW 228 on at

Like (0)

Report

RE: Retail Environment Reprovisioning Retarget Tool on VHD

try what i mentioned... The reprovision tool isnt needed anymore afaik.. the latest package update will perform the steps that specific tool did... and, as you're seeing, it has issues running at all these days (it always did really)... If it were me, i would snapshot back, or start over from a clean working developer vhd and follow the steps as laid out in the two links i sent.. and sometimes/many times retail consultants regurgitate info that worked in the past but they arent keeping up, or dont have much hands on experience. just my .02.
Juliet Zhu on at

Like (0)

Report

RE: Retail Environment Reprovisioning Retarget Tool on VHD

Check this value in Retail Server web.config: <add key="DataAccess.DbServer" value="localhost" />

If it's "localhost", update the value to your machine name, restart Retail Server, then give it another try.

Thanks,

Juliet Zhu
MYGz 1,862 on at

Like (0)

Report

RE: Retail Environment Reprovisioning Retarget Tool on VHD

When run the Distribution Schedule 9999, all the jobs stay in Available state:

The retail consultant asked to run environment reprovisioning after restoration from UAT and Production.

When I tried to run, I couldn't.

Regards,
JeffreyPW 228 on at

Like (0)

Report

RE: Retail Environment Reprovisioning Retarget Tool on VHD

What are you actually trying to run? You dont need to run the reprovision tool anymore if that is what you are doing...

docs.microsoft.com/.../dbmovement-scenario-exportuat

after restoring the database and renaming the UAT to AXDB, start services, then install any and all customization axdeployablepackages using devinstall from command line as admin. Then, apply the same or a newer update package...

docs.microsoft.com/.../upgrade-latest-platform-update
MYGz 1,862 on at

Like (0)

Report

RE: Retail Environment Reprovisioning Retarget Tool on VHD

@Juliet Zhu

I tried debugging, this is where it's failing:

AxDeploymentSetupUtility.

The error is: 'Cannot execute the required database operation'