Tuesday, August 19, 2014

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



Issue:
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!!!