Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Unable to synchronise ...
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 Akbarpasha

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,350 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,350 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans