Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Unable to synchronise new table -Cannot execute a data definition language command on (). - AX 2012

(0) ShareShare
ReportReport
Posted on by

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

  • Akbarpasha Profile Picture
    Akbarpasha on at
    RE: Unable to synchronise new table -Cannot execute a data definition language command on (). - AX 2012

    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

  • Andre Ghazaleh Profile Picture
    Andre Ghazaleh 870 on at
    RE: Unable to synchronise new table -Cannot execute a data definition language command on (). - AX 2012

    hi Akbar,

    Check this post, same problem:

    community.dynamics.com/.../can-not-execute-data-definition-language-after-db-sync

    Regards

  • Verified answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: Unable to synchronise new table -Cannot execute a data definition language command on (). - AX 2012

    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.

  • Akbarpasha Profile Picture
    Akbarpasha on at
    RE: Unable to synchronise new table -Cannot execute a data definition language command on (). - AX 2012

    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

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: Unable to synchronise new table -Cannot execute a data definition language command on (). - AX 2012

    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?

  • Verified answer
    WillWU Profile Picture
    WillWU 22,352 on at
    RE: Unable to synchronise new table -Cannot execute a data definition language command on (). - AX 2012

    Hi Akbarpasha,

    Please try to back up your table first and then delete the index:

    DROP INDEX I_106017PURCHIDIDX ON [yourtable].

  • Akbarpasha Profile Picture
    Akbarpasha on at
    RE: Unable to synchronise new table -Cannot execute a data definition language command on (). - AX 2012

    Hi Gunjan,

    It is customised new table.

    Regards,

    Akbar

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: Unable to synchronise new table -Cannot execute a data definition language command on (). - AX 2012

    Hi Akbar,

    Is this a standard table or a customized one?

  • Akbarpasha Profile Picture
    Akbarpasha on at
    RE: Unable to synchronise new table -Cannot execute a data definition language command on (). - AX 2012

    Hi Will Wu,

    We are not trying to delete anything, just trying to Synchronise the table , getting the above error.

    Regards,

    Akbar

  • Verified answer
    WillWU Profile Picture
    WillWU 22,352 on at
    RE: Unable to synchronise new table -Cannot execute a data definition language command on (). - AX 2012

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,836 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans