Error: While doing Synchronization system throw below error
SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]Error: The new name ” is already in use as a COLUMN name and would cause a duplicate that is not permitted.
Solution: By doing followed steps the error got resolve for me:
1) Renamed the table name "PAYMENTTYPE_ES" to "PAYMENTTYPE_ES_Old" in SQL server.
2) Switched to AX and synchronized the "PAYMENTTYPE_ES" table.
3) Switched to SQL Server and refreshed the database, this will pop up two tables with names- i) PAYMENTTYPE_ES and ii) PAYMENTTYPE_ES_Old
4) Now renamed both the tables PAYMENTTYPE_ES to PAYMENTTYPE_ES_New and PAYMENTTYPE_ES_Old to PAYMENTTYPE_ES
5) Again switched to AX and synchronized the PAYMENTTYPE_ES table, error got resolved.
6) Dropped table "PAYMENTTYPE_ES_New" from SQL server.
SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]Error: The new name ” is already in use as a COLUMN name and would cause a duplicate that is not permitted.
Solution: By doing followed steps the error got resolve for me:
1) Renamed the table name "PAYMENTTYPE_ES" to "PAYMENTTYPE_ES_Old" in SQL server.
2) Switched to AX and synchronized the "PAYMENTTYPE_ES" table.
3) Switched to SQL Server and refreshed the database, this will pop up two tables with names- i) PAYMENTTYPE_ES and ii) PAYMENTTYPE_ES_Old
4) Now renamed both the tables PAYMENTTYPE_ES to PAYMENTTYPE_ES_New and PAYMENTTYPE_ES_Old to PAYMENTTYPE_ES
5) Again switched to AX and synchronized the PAYMENTTYPE_ES table, error got resolved.
6) Dropped table "PAYMENTTYPE_ES_New" from SQL server.
