getting issue when synchronizing Table in AOT

Finance and Operations/AX Developer Forum
1

Hi All,

I am getting below error while synchronizing table in AOT and working in ax 2012 R3.

Issue:

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]Error: The new name ‘SYN_PROGRAMID’ is already in use as a COLUMN name and would cause a duplicate that is not permitted.

SQL statement: SP_RENAME ‘“DBO”.LEDGERJOURNALTRANS.SYN_UTRNUMBER’,‘SYN_PROGRAMID’,‘COLUMN’

I have already tried following ways in order to resolve this issue.

  1. Data synchrinization from AOT.

  2. Cleared cache restarted AOS service

  3. After googling i found in most of the solution that take backup of table and delete affected field after that reimport the table and sync. but in this way i will loss the data(transaction) for that fields.

if anybody have a solution then please suggest. any help and suggession would be highly appreciated.

screenshot.docx (137 KB)

Regards,

Akshay

2

Hi Akshay,

You can table a SQL backup of that affected table and delete the whole table and you can restore that table in AX from the SQL.

When you take backup in SQL you won’t lose any of your data and all your table data will be reinstated once you import into AX from SQL.

Please try the above and let me know for any queries.

Regards,

John