Sync error after migration of VAR Layer customization through .axModel from source Server to target Server AX 2012 R3 CU9.. Error "Column names in each table must be unique. Column name 'Field name' in table 'Table Name' is specified

(0) Share

Report

Posted on by Sangeeth R

Hi folks,

I'm getting below sync error. When I migrated VAR layer customization through .axmodel from source server to target server. Both are different server.

Like this I'm getting nearly 62 tables sync error. in AX system behave perfectly when I try to create record creation(vendor, worker, customer, opportunity, PO, SO, PR, RFQ, Inventory journals, Financial transaction) and posting. There is no issue at time any user interruption. but when I try to synchronize from AX. getting below error.

When I try to check error column field in SQL Column field with AX AOT table fields in AOT Table error field is not available.

SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]
Column names in each table must be unique.
Column name 'Field name' in table 'Table Name' is specified more than once.

Any suggestions?..

Thank you

Sangeeth R

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Vilmos Kintera 46,149 on at

Like (0)

Report
Copy link

Link copied!

You must not use the system if database synchronization is failing.

Probably your AOT elements are not in synch with what your SQL metadata thinks about itself. You need to resolve Table and Field Id conflicts in the SQLDictionary table.

There are couple of things you could try to get it fixed:

community.dynamics.com/.../207511

Was this reply helpful? Yes No