Synchronize database not completing on code upgrade checklist for in-place AX 2012

AX 2012 to AX 2012 R3 upgrade.

I face the issue of not completing the Synchronize database step. i had spent lot time to resolve this. tried some solutions from the net as below.

1. Synchronize it many times from checklist

2. reviewed the event viewer log. it say sync finished

3. Synchronize from AOT. still not resolved

4. Run manual jobs to update checklist steps as complete

stuck with the synchronize database on code upgrade checklist for in place

Other warnings "the view that are disabled due to configuration key".  For that We have load the license file again and it resolved. No error now. It don’t throw any error on synchronize database and even not completed.

Solution:

After a long digging I found the solution on Microsoft DynamicsLifecycle Services (LCS).

Ultimately it’s a issue in AX 2012 R3 registered on LCS as synchronize database cannot completed on code upgrade checklist in place.

Downloaded the hotfix from LCS and installed . It resolved my issue.

This helped you..!! Then comment below..:) . 

The primary key constraint 'I_029TYPEIDX' on table 'BUDGETMODEL' cannot be dropped because change tracking is enabled on the table

AX 2012 upgrade

During upgrade AX 2012 to AX 2012 R3. i face the error below while synchronize data dictionary on development server

Error

SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]The primary key constraint 'I_029TYPEIDX' on table 'BUDGETMODEL' cannot be dropped because change tracking is enabled on the table. Change tracking requires a primary key constraint on the table. Disable change tracking before dropping the constraint.

SQL statement: ALTER TABLE BUDGETMODEL DROP CONSTRAINT I_029TYPEIDX

Cannot execute a data definition language command on  ().

Solution

- Open SQL Management studio and open new query window for the AX database

- Run below query. this will populate the table having change Tracking enabled

- set the query window to result in to text

SELECT Distinct T1.NAME AS TABLENAME into ##Name FROM SYSOBJECTS T1, sys.change_tracking_tables T2 WHERE T1.ID = T2.object_id ORDER BY T1.NAME 

SELECT 'ALTER TABLE ' + TableName + ' DISABLE CHANGE_TRACKING' from ##Name

- Copy the text and save to file. do not run this now

- execute query below

SELECT 'ALTER TABLE ' + TableName + ' ENABLE CHANGE_TRACKING' from ##Name

- Copy the text and save to file

- Run the text saved first

- Restart AOS and Synchronize

that's it.

Reference https://technet.microsoft.com/en-in/library/jj733502.aspx go to AOS fails to start

Share your comments below if this helps you.