Synchronization Error in AX 2012 R3

Finance and Operations/AX Technical Forum
1

Hi All,

I am getting below error while synchronizing the table InventItemGroup.

Cannot execute a data definition language command on (). The SQL database has issued an error.

SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]The object ‘I_152ITEMGROUPIDX’ is dependent on column ‘ITEMGROUPID’.

SQL statement: ALTER TABLE “DBO”.INVENTITEMGROUP ALTER COLUMN ITEMGROUPID nvarchar(25) NOT NULL

Problems during SQL data dictionary synchronization.

The operation failed.

Synchronize failed on 1 table(s)

Event Viewer Log:

Object Server 01: The database reported (session 3 (Shashank2)): [Microsoft][SQL Server Native Client 11.0][SQL Server]The object ‘I_152ITEMGROUPIDX’ is dependent

on column ‘ITEMGROUPID’… The SQL statement was: “ALTER TABLE “DBO”.INVENTITEMGROUP ALTER COLUMN ITEMGROUPID nvarchar(25) NOT NULL”

Thanks

2

Try the following:

  1. Disable ItemGroupIdx index
  2. Run synchronization to apply your change to ItemGroupId field
  3. Re-enable the index
3

Hi Martin,

Thanks for your valuable reply.

I approached with the solution you have suggested. But still it is not working, system is throwing the same error.

Thanks…

4

Please give us more details; we can’t see what happens in your system.

Is it failing at point two? It must mean that point 1 didn’t succeed. In that case, remove the change to ItemGroupId field and try it again.

5

does reindexing db work here ?