Table synchronization errors

You can try following method to solve almost any table synchronization error:

- At SQL server rename table and append 2 at the name. Clustered index of table should also be renamed (table name -> Indexes node -> name (clustered) ).
- Synchronize table in AX. Which should create clear table at SQL server.
- Pull data from table with postfix 2 to newly created table using INSERT ... SELECT statement and make any data transformations if required.
You can use right click on table in SQL serve -> Script Table as -> INSERT to and SELECT to, to automatically create required statement.
INSERT .. SELECT should look like:
INSERT INTO [dbo].[INVENTITEMGROUP]
           ([ITEMGROUPID]
           ,[NAME]
           ,[STANDARDITEMALLOCATEID]
           ,[TAXITEMGROUPIDSALES]
           ,[TAXITEMGROUPIDPURCH]
           ,[DUEDATELIMITGROUPID_ES]
           ,[ASSETGROUP_IN]
           ,[LOADTEMPLATEID]
           ,[MODIFIEDDATETIME]
           ,[DATAAREAID]
           ,[RECVERSION]
           ,[PARTITION]
           ,[RECID])
SELECT [ITEMGROUPID]
      ,[NAME]
      ,[STANDARDITEMALLOCATEID]
      ,[TAXITEMGROUPIDSALES]
      ,[TAXITEMGROUPIDPURCH]
      ,[DUEDATELIMITGROUPID_ES]
      ,[ASSETGROUP_IN]
      ,[LOADTEMPLATEID]
      ,[MODIFIEDDATETIME]
      ,[DATAAREAID]
      ,[RECVERSION]
      ,[PARTITION]
      ,[RECID]
  FROM [dbo].[INVENTITEMGROUP2]
GO

Search

About

DaxOnline.org is free platform that allows you to quickly store and reuse snippets, notes, articles related to Dynamics AX.

Authors are allowed to set their own AdSense units.
Join us.

Blog Tags