Posts

Showing posts with the label EDT

AX Database synchronisation error when EDT property changed

Image
DB sync errors when change tracking is enabled for a table on sql server and you changed the field size. Example: In below, I changed the Num EDT size from 20 to 30, this EDT is used in InventDIM table which has change tracking enabled in SQL database. DB sync errored when doing a full data dictionary Synchronisation. Num EDT size changed from 30 to 20 Change tracking enabled on custtable and inventdim tables in SQL database DB sync error Fix:  Go to SSMS and find the table "InventDIM" in AX database Right click and select properties Select Change Tracking Change to False for both option "change tracking and Track columns updated" Click Okay Start DB sync and it should finish with out error Revert the change tracking property back to "True".