web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Problem during SQL dat...
Microsoft Dynamics AX (Archived)

Problem during SQL data dictionary synchronization

(0) ShareShare
ReportReport
Posted on by Community Member

I'm trying to add t fields to the PurchLine Table but after compile i got the following error:

Cannot execute a data definition language command on  ().
The SQL database has issued an error.
Problems during SQL data dictionary synchronization.
The operation failed.
Synchronize failed on 1 table(s)

This error happened when I was adding fields to the table and disconnect the system from the network.

 

Thanks for your help

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    Community Member on at

    You can check Eventlog for more detail info. E.g sql script, tables, etc

    Regards,

    S.C.GAN

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    How were you adding these fields?  Directly in AOT or through xpo?  I would first try recreating the fields in PurchLine and try another synch.  

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi

    I add these flieds directly in AOT, besides just delete these fields from AOT, but I mark error when synchronizing,

    I am checking the Server Application and the event log shome this message:

    Object Server 01: The database reported (session 9 (amar)): [Microsoft][ODBC SQL Server Driver][SQL Server] there is already an object named 'PURCHLINE' in the database.. The SQL statement was: "CREATE TABLE "DBO".PURCHLINE

    thanks by you help

  • Forever Profile Picture
    Forever 110 on at

    have u solved this problem? let me explain how to solve? same error facing here.

  • Forever Profile Picture
    Forever 110 on at

    hi friends,

    I have same problem face, can you help me how this problem solved?

  • Suggested answer
    Maxim Gorbunov Profile Picture
    Maxim Gorbunov 456 on at

    If AX is trying to create a table which already exists in the database, most likely that means that your SQLDictionary table is out of sync with the AOT.

    The easiest way to fix it would be to rename PURCHLINE table in the database, then run synchronization and let it create PURCHLINE table again, and then copy data from the renamed PURCHLINE table into the newly created PURCHLINE.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans