Tuesday, August 19, 2014

In-Place Data upgrade checklist issue in AX 2012 R3 and AX 2012 R2 upgrade

We observed this during AX 2012 R2 and AX 2012 R3 data upgrade other than the Launch Data Upgrade stage, a different stage Presynchronization is blocked: instead of showing the ReleaseUpdateCockpit form but the ReleaseUpdateScriptsHistory form pops up unexpectedly. 

Solution:This turned out that back dated rows were recorded into the log table ReleaseUpdateScriptsHistory (ScriptStage=16: Presynchronization; ScriptStage=17: Launch Data Upgrade).  We have dropped the relevant records from the ReleaseUpdateScriptsHistory:

  delete from ReleaseUpdateScriptsHistory where ScriptStage in (16,17,18)

After dropping data Presynchronization and launch data upgrade worked properly.

Happy DAXing!!!