I am getting below error while synchronizing table in AOT and working in ax 2012 R3.
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.
Data synchrinization from AOT.
Cleared cache restarted AOS service
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)