Microsoft Dynamics AX (Archived)

Syncronization issue

(0) Share

Report

Posted on by Community Member

Hi all,

Syncronization is giving an error for a table Z_inventDimCombination.

5165.sync-error.jpg

i'm using Ax 2012 R2 application.

the following is the error,

Cannot execute a data definition language command on ().

The SQL database has issued an error.

SQL error description: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '<'.

SQL statement: DROP INDEX Z_INVENTDIMCOMBINATION.<Name of Missing Index, sysname,>

Problems during SQL data dictionary synchronization.
The operation failed.

Synchronize failed on 1 table(s)

Please help to solve this error.

Thank you,

Praveen.

*This post is locked for comments

All responses (5)

Answers (0)

Suggested answer

Vilmos Kintera on at

Like (0)

Report

RE: Syncronization issue

That is a weird error. How does the Indexes node look like in your table? Does everything look OK in the AOT? Expand all indexes and fields and upload a screenshot. Is everything OK in SQLDictionary table in the database for the tabid of your table?

It looks like a custom table, try dropping the index nodes in the AOT and also in the SQL database, then recreate them, see if that helps.
Community Member on at

Like (0)

Report

RE: Syncronization issue

Thank you for your reply Vilmos,

I do not have access to AX Data base in SQL, i'm trying to get that.

please find below screen shots of the indexes and fields expanded.

Thanks,

Praveen
Suggested answer

Tommy Skaue on at

Like (1)

Report

RE: Syncronization issue

Hi Praveen

Most likely, someone on the Database Administration side has created the index outside of AX. And looking at the name, it seems like they have run a missing index analysis and simply created the index using the template SQL without giving the index a proper name.

AX will not be able to drop the index, so you will need someone on the database side, with access to the database, to drop the index directly on the table.
Suggested answer

Vilmos Kintera on at

Like (0)

Report

RE: Syncronization issue

Apparently the case is exactly as Tommy suggested, that is why I wanted you to check the indexes between the AX AOT, and SQL Server.

Please make sure you communicate with your vendor and internal staff, that no modifications are allowed directly in an AX SQL database (i.e. creating suggested indexes), since all metadata must be maintained within the application. If not, that will cause problems as per above during Data Dictionary syncronization / table / data type modifications.
Community Member on at

Like (0)

Report

RE: Syncronization issue

Thanks for this solution. I have been searching for a whole day untill I found this solution. The installation of a platform update failed on the synchronization step.