Hi All,
Unable to synchronise the new table, getting the below error.
Tried deleting the records from the table and reimported from lower environment (able to synchronise in lower environment) still it is not getting synchronised.
Synchronise database
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]The object 'I_106017PURCHIDIDX' is dependent on column 'NEWPURCHID'.
SQL statement: ALTER TABLE tabelname DROP COLUMN NEWPURCHID
Problems during SQL data dictionary synchronisation.
The operation failed.
Synchronise failed on 1 table(s)
Please advise us how to resolve this issue.
Regards,
Akbar
Thanks All,
We have dropped the table from SQL(taken backup before dropping), and able to synchronised from AOT.
Thank you very much.
Regards,
Akbar
hi Akbar,
Check this post, same problem:
community.dynamics.com/.../can-not-execute-data-definition-language-after-db-sync
Regards
Hi Akbar,
Yes, You can try deleting the Index and then do a synchronization again. But, I am wondering why it is trying to drop the field when you are trying to synchronize.
For now please try removing the index from SQL and try to synchronize again. If that doesn't work and you don't have any data in this table, you may try removing the table itself from SQL so that it is re-created from scratch during synchronization.
Hi Gunjan,
There is no Configuration key defined on the table and there are no changes in License configuration.
Can we try to delete index as suggested by Will Wu, or any other thing we can do.
Please advise us.
Regards,
Akbar
Hi Akbar,
Do you have a Configuration key mentioned for this field "NEWPURCHID"? Were there any changes to License configuration which might be causing this?
Hi Akbarpasha,
Please try to back up your table first and then delete the index:
DROP INDEX I_106017PURCHIDIDX ON [yourtable].
Hi Gunjan,
It is customised new table.
Regards,
Akbar
Hi Akbar,
Is this a standard table or a customized one?
Hi Will Wu,
We are not trying to delete anything, just trying to Synchronise the table , getting the above error.
Regards,
Akbar
Hi Akbarpasha,
It seems you are going to delete the filed "NEWPURCHID" and it has a index called "I_106017PURCHIDIDX".
Are you sure that you want to remove the field? If yes, you could go to SSMS to run sql command to drop this index, then synchronize the table again from AX, and the field will be removed.
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,836
Most Valuable Professional
nmaenpaa
101,156