Greg On Dynamics Ax

Random thoughts about development using Dynamics AX and .Net

Solving Problems during SQL data dictionary synchronisation

leave a comment »

You might get this error message following an upgrade:

Data synchronisation 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)

To find out exactly what the problem is you will need to have a look in the Windows event viewer on the AOS server, which will look something like this:

Duplicate record error (Event Log Entry)

If the error is similar to this (I.E of the family “The CREATE UNIQUE INDEX statement terminated because a duplicate key was found”) then you have the following options to solve the problem:

1. If you are not worried about the data in the table then the simplest solution is to drop the table


2. In AX, temporarily disable the index (that causes the duplicate) and use the table browser with filters(using data from the event log) to correct the data.


3.  Use SQL Server management studio to resolve the problem – see this microsoft knowledge base article for a great guide on how to do this:


Please look out for future posts with some tools to help with this!


Written by gregondax

March 29, 2009 at 3:46 pm

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: