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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Full DB Synchronizatio...
Microsoft Dynamics AX (Archived)

Full DB Synchronization error

(0) ShareShare
ReportReport
Posted on by gyan chand kabra

HI,

I am getting the following error in the full DB synchronization in AX 2012 R3. I checked the respective table in Information_schema as well but i am not getting any record in it and there is no record in the below tables

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]Cannot create index on view 'MSINVENTDIMTMP' because the view is not schema bound.

SQL statement: CREATE UNIQUE CLUSTERED INDEX I_111689DIMIDIDX ON "DBO".MSINVENTDIMTMP (PARTITION,DATAAREAID,INVENTDIMID)

Problems during SQL data dictionary synchronization.
The operation failed.

SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]There is already an object named 'I_111725RECID' in the database.

SQL statement: ALTER TABLE "DBO".SPC_REFROUTE_RESOUCERESGROUP ADD CONSTRAINT I_111725RECID PRIMARY KEY CLUSTERED (RECID)

*This post is locked for comments

  • Suggested answer
    5400 Profile Picture
    5400 on at
    RE: Full DB Synchronization error

    Please check your view is there any unknown field is mapped or not. also check your view related table are sync correctly.

    after that Please delete MSINVENTDIMTMP from SQL and sync from AOT.

  • gyan chand kabra Profile Picture
    gyan chand kabra on at
    RE: Full DB Synchronization error

    It is a standard table in AX and I can't delete it from sql without knowing the implication of it.

  • 5400 Profile Picture
    5400 on at
    RE: Full DB Synchronization error

    It is temp table. you can delete and once you sync from AOT, schema would generate automatically.  

  • gyan chand kabra Profile Picture
    gyan chand kabra on at
    RE: Full DB Synchronization error

    It is regular table. name is confusing. still can i delete it from sql DB ?

  • 5400 Profile Picture
    5400 on at
    RE: Full DB Synchronization error

    If data is empty u can. Otherwise you have to take the data back for this table once deletion done you can import the data in same table.

  • gyan chand kabra Profile Picture
    gyan chand kabra on at
    RE: Full DB Synchronization error

    I did the same thing but synchronization error is still coming.

  • A.Prasanna Profile Picture
    A.Prasanna on at
    RE: Full DB Synchronization error

    Hope this will help

    www.mssqltips.com/.../sql-server-schema-binding-and-indexed-views,

    Amith Prasanna

  • gyan chand kabra Profile Picture
    gyan chand kabra on at
    RE: Full DB Synchronization error

    HI,

    But this is not the view.

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans