fimmtudagur, 20. október 2011

Synchronisation error

Got an error when adding new field to InventTable, user did not have rights to sqldictionary table when adding new field?
The field was added to AOTand  the database table, but further synchronisation in AX gave the classic error
"Cannot execute a data definition language command on (). The SQL database has issued an error. Problems during SQL data dictionary synchronisation. The operation failed. Synchronise failed on n table(s)"
Amended by checking the error further in the AOS event viewer and then removing the field in the database and then synchronise in AOT.