Finance | Project Operations, Human Resources, ...

DB Sync errors on Ax 2012 R2 - R3 Upgrade

(0) Share

Report

Posted on by BrandonSA

1,673

Hi everyone

I've just performed an upgrade from Ax 2012 R2 CU6 to Ax 2012 R3 CU13 according to this documentation:

https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/scenario-perform-in-place-upgrade-to-ax-2012-r2-or-ax-2012-r3

I'm at the point where the upgraded models are in the R3 environment, and I need to run the data upgrade.

I make it through the pre-Sync fine, but the actual Synchronization fails with errors - all of them on DMF tables. I noticed that on the DMF tables reported in the error, there are field id conflicts. I run a job to fix them, and try to sync again, but then I get tons of errors on indexes that can't be updated, so I think I'm on the wrong path.

Some of the DMF tables had modifications on them. In the upgrade documentation, you're supposed to delete the DMF or FPK model. I did that. However, there were DMF modifications in an ISV layer that got merged back into the code after the code upgrade was done. I suspect I did something wrong here - what did I do wrong? When are you supposed to merge DMF customisations back into the code? Since DMF changed so much between R2 and R3, does it require re-implementation? The documentation says nothing about it, only that the FPK model must be initially deleted - which it was.

My strategy now is to delete the DMF modifications, recompile the code, recompile CIL, and then run the dataupgrade again. Will this work? What must I do with the DMF modifications?

Any help is appreciated as always.

Thanks

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

Khushhal Garg 1,514 on at

Like (0)

Report
Copy link

Link copied!

You are supposed to remove DMF from FPK layer.

Was this reply helpful? Yes No
BrandonSA 1,673 on at

Like (0)

Report
Copy link

Link copied!

Hi Khushhal

Thanks for the reply. As stated, I did do that. Something else is wrong.

Thanks

Was this reply helpful? Yes No
Suggested answer

Khushhal Garg 1,514 on at

Like (0)

Report
Copy link

Link copied!

What kind of modifications are there in DMF? Did you add new fields?

Was this reply helpful? Yes No
BrandonSA 1,673 on at

Like (0)

Report
Copy link

Link copied!

The changes are from another ISV partner. Some of the changes include new fields. Some of the changes are changed field properties, like changing mandatory from no to yes. Some of the changes include small changes on relationships etc.

The documentation also seems to indicate that there should be an updated FPK model in R3, but I can't see one. It looks like all DMF objects now reside on the SYS layer. I don't understand why Ax is unable to update these tables.

Was this reply helpful? Yes No
Suggested answer

Khushhal Garg 1,514 on at

Like (0)

Report
Copy link

Link copied!

seems significant changes that could be impacting upgrade. You can try removing these changes and put these back after upgrade. Only thing if you want to bring data in these new fields then those have to migrated later manually. If not, then removing these customizations before upgrade and adding later after upgrade should be fine.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,172 Moderator on at

Like (0)

Report
Copy link

Link copied!

Do you have R3 compatible version of the ISV solution, or are you using the old one?

What errors do you get? Perhaps you should talk to the ISV if the issue seems to be related to their stuff.

Was this reply helpful? Yes No