Dynamics AX 2009 Upgrade: Synchronize Won't Synchronize

I am upgrading from Axapta 3.0 to Dynamics AX 2009. One problem I encountered (among the many) was that i was at the stage where i have done everything before the Synchronize stage. All ticks were green. All issues resolved.

But when i click on the Synchronize option, nothing happens! I try to synchronize by using the Right Click on the Database and Synchronize, however nothing i do will make that arrow turn into a tick box.

After two days of going crazy, i am proud to share with you how i got over this problem.

I debugged the code and got to the upgrade class of \Classes\xUtilIdElements\checkDuplicateNamesWithDifferentId, and lo and behold, the process errors in this section as it is detecting duplicate Indexes on the same table, with the same Index Name, but on different layers.

HOWEVER, the code does not throw an error. Or if it does, it’s nowhere i can see it. It just exits the class and pretends that nothing happens.

So. Solution:

1. Go to \Classes\xUtilIdElements\checkDuplicateNamesWithDifferentId

2. Debug on line 59, or where it says.. ok = checkFailed(strfmt(“SYS... etc

3. On the Locals watch pane, you can determine which Index/Table/Field is the problem, and the TableId it is from (Column Name is ParentId)

4. Go to that table and delete the offending item.

I hope my two days worth of AX upgrade nightmare is somehow helpful to you