Wednesday, August 22, 2012

Synchronize Database Problem - Missing Field in SQL Table


During Syncronize process could happen that for certain Tables the System table SqlDictionary present all columns, but the relative SQL Table have some fields missing.

The problem occur with the Check\Synchronize Action. Seems that AX update correctly the system table SQLDictionary, but don't create the new fields in the SQL Tables.

Due to solve the problem, run the Synchronize Database Action from the SQL Administration form. This action first update the system table SQLDictionary and finally create the fields in SQL Table if missing.
Seems that the Check\Synchronize Action, if a field is present in the system table SQLDictionary don't check if the same is present in the SQL Table !

See also Troubleshooting AOT Synchronization Errors

Enjoy !


No comments: