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) / I have Problems during...
Microsoft Dynamics AX (Archived)

I have Problems during SQL data dictionary synchronization?

(0) ShareShare
ReportReport
Posted on by khalil Hamad 305

Dears,

I'm trying to add t fields to the InventJournalTrans 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)

 

Any help i will be grateful.

Thank you

 

*This post is locked for comments

I have the same question (0)
  • khalil Hamad Profile Picture
    khalil Hamad 305 on at
    Re: I have Problems during SQL data dictionary synchronization?

    and one more thing fellows i tried to add the colums to the SQL server and thin not gonna work too

  • Lauras U Profile Picture
    Lauras U 955 on at
    Re: I have Problems during SQL data dictionary synchronization?

    Can you find and post windows event viewer log for this error?

  • khalil Hamad Profile Picture
    khalil Hamad 305 on at
    Re: I have Problems during SQL data dictionary synchronization?

    Object Server 01: The database reported (session 5 (Admin)): [Microsoft][SQL Native Client][SQL Server]There is already an object named 'INVENTJOURNALTRANS' in

    the database.. The SQL statement was: "CREATE TABLE "DBO".INVENTJOURNALTRANS  (JOURNALID NVARCHAR(10) NOT NULL DEFAULT '' ,LINENUM NUMERIC(28,12) NOT NULL DEFAULT 0 ,TRANSDATE DATETIME NOT NULL DEFAULT '1900-01-01 00:00:00.000' ,VOUCHER NVARCHAR(20) NOT NULL DEFAULT '' ,JOURNALTYPE INT NOT NULL DEFAULT 0 ,ITEMID NVARCHAR(40) NOT NULL DEFAULT '' ,DEL_CORRECTIVEREASON NTEXT DEFAULT NULL ,QTY NUMERIC(28,12) NOT NULL DEFAULT 0 ,COSTPRICE NUMERIC(28,12) NOT NULL DEFAULT 0 ,PRICEUNIT NUMERIC(28,12) NOT NULL DEFAULT 0 ,COSTMARKUP NUMERIC(28,12) NOT NULL DEFAULT 0 ,COSTAMOUNT NUMERIC(28,12) NOT NULL DEFAULT 0 ,SALESAMOUNT NUMERIC(28,12) NOT NULL DEFAULT 0 ,PROJTRANSID NVARCHAR(20) NOT NULL DEFAULT '' ,INVENTTRANSID NVARCHAR(20) NOT NULL DEFAULT '' ,INVENTTRANSIDFATHER NVARCHAR(20) NOT NULL DEFAULT '' ,LEDGERACCOUNTIDOFFSET NVARCHAR(40) NOT NULL DEFAULT '' ,INVENTONHAND NUMERIC(28,12) NOT NULL DEFAULT 0 ,COUNTED NUMERIC(28,12) NOT NULL DEFAULT 0 ,DIMENSION NVARCHAR(10) NOT NULL DEFAULT '' ,DIMENSION2_ NVARCHAR(10) NOT NULL DEFAULT '' ,DIMENSION3_ NVARCHAR(10) NOT NULL DEFAULT '' ,BOMLINE INT NOT NULL DEFAULT 0 ,INVENTTRANSIDRETURN NVARCHAR(20) NOT NULL DEFAULT '' ,PROJCATEGORYID NVARCHAR(10) NOT NULL DEFAULT '' ,PROJID NVARCHAR(10) NOT NULL DEFAULT '' ,DEL_CORRECTEDINVOICEID NVARCHAR(20) NOT NULL DEFAULT '' ,TOINVENTTRANSID NVARCHAR(20) NOT NULL DEFAULT '' ,REASONREFRECID BIGINT NOT NULL DEFAULT 0 ,INVENTDIMID NVARCHAR(20) NOT NULL DEFAULT '' ,TOINVENTDIMID NVARCHAR(20) NOT NULL DEFAULT '' ,REQPOID NVARCHAR(20) NOT NULL DEFAULT '' ,EMPLID NVARCHAR(40) NOT NULL DEFAULT '' ,ASSETTRANSTYPE INT NOT NULL DEFAULT 0 ,ASSETID NVARCHAR(40) NOT NULL DEFAULT '' ,ASSETBOOKID NVARCHAR(10) NOT NULL DEFAULT '' ,PROJTAXGROUPID NVARCHAR(10) NOT NULL DEFAULT '' ,PROJSALESCURRENCYID NVARCHAR(3) NOT NULL DEFAULT '' ,PROJLINEPROPERTYID NVARCHAR(10) NOT NULL DEFAULT '' ,PROJTAXITEMGROUPID NVARCHAR(10) NOT NULL DEFAULT '' ,PROJUNITID NVARCHAR(10) NOT NULL DEFAULT '' ,PROJSALESPRICE NUMERIC(28,12) NOT NULL DEFAULT 0 ,INVENTREFTYPE INT NOT NULL DEFAULT 0 ,INVENTREFID NVARCHAR(20) NOT NULL DEFAULT '' ,INVENTREFTRANSID NVARCHAR(20) NOT NULL DEFAULT '' ,PROFITSET INT NOT NULL DEFAULT 0 ,ACTIVITYNUMBER NVARCHAR(10) NOT NULL DEFAULT '' ,RELEASEDATE DATETIME NOT NULL DEFAULT '1900-01-01 00:00:00.000' ,RELEASEDATETZID INT NOT NULL DEFAULT 37001 ,DATAAREAID NVARCHAR(4) NOT NULL DEFAULT 'dat' ,RECVERSION INT NOT NULL DEFAULT 1 ,RECID BIGINT NOT NULL CHECK (RECID <> 0) ) "

    For more information, see Help and Support Center at go.microsoft.com/.../events.asp.

  • khalil Hamad Profile Picture
    khalil Hamad 305 on at
    Re: I have Problems during SQL data dictionary synchronization?

    Object Server 01: The database reported (session 5 (Admin)): [Microsoft][SQL Native Client][SQL Server]There is already an object named 'INVENTJOURNALTRANS' in

    the database.. The SQL statement was: "CREATE TABLE "DBO".INVENTJOURNALTRANS  (JOURNALID NVARCHAR(10) NOT NULL DEFAULT '' ,LINENUM NUMERIC(28,12) NOT NULL DEFAULT 0 ,TRANSDATE DATETIME NOT NULL DEFAULT '1900-01-01 00:00:00.000' ,VOUCHER NVARCHAR(20) NOT NULL DEFAULT '' ,JOURNALTYPE INT NOT NULL DEFAULT 0 ,ITEMID NVARCHAR(40) NOT NULL DEFAULT '' ,DEL_CORRECTIVEREASON NTEXT DEFAULT NULL ,QTY NUMERIC(28,12) NOT NULL DEFAULT 0 ,COSTPRICE NUMERIC(28,12) NOT NULL DEFAULT 0 ,PRICEUNIT NUMERIC(28,12) NOT NULL DEFAULT 0 ,COSTMARKUP NUMERIC(28,12) NOT NULL DEFAULT 0 ,COSTAMOUNT NUMERIC(28,12) NOT NULL DEFAULT 0 ,SALESAMOUNT NUMERIC(28,12) NOT NULL DEFAULT 0 ,PROJTRANSID NVARCHAR(20) NOT NULL DEFAULT '' ,INVENTTRANSID NVARCHAR(20) NOT NULL DEFAULT '' ,INVENTTRANSIDFATHER NVARCHAR(20) NOT NULL DEFAULT '' ,LEDGERACCOUNTIDOFFSET NVARCHAR(40) NOT NULL DEFAULT '' ,INVENTONHAND NUMERIC(28,12) NOT NULL DEFAULT 0 ,COUNTED NUMERIC(28,12) NOT NULL DEFAULT 0 ,DIMENSION NVARCHAR(10) NOT NULL DEFAULT '' ,DIMENSION2_ NVARCHAR(10) NOT NULL DEFAULT '' ,DIMENSION3_ NVARCHAR(10) NOT NULL DEFAULT '' ,BOMLINE INT NOT NULL DEFAULT 0 ,INVENTTRANSIDRETURN NVARCHAR(20) NOT NULL DEFAULT '' ,PROJCATEGORYID NVARCHAR(10) NOT NULL DEFAULT '' ,PROJID NVARCHAR(10) NOT NULL DEFAULT '' ,DEL_CORRECTEDINVOICEID NVARCHAR(20) NOT NULL DEFAULT '' ,TOINVENTTRANSID NVARCHAR(20) NOT NULL DEFAULT '' ,REASONREFRECID BIGINT NOT NULL DEFAULT 0 ,INVENTDIMID NVARCHAR(20) NOT NULL DEFAULT '' ,TOINVENTDIMID NVARCHAR(20) NOT NULL DEFAULT '' ,REQPOID NVARCHAR(20) NOT NULL DEFAULT '' ,EMPLID NVARCHAR(40) NOT NULL DEFAULT '' ,ASSETTRANSTYPE INT NOT NULL DEFAULT 0 ,ASSETID NVARCHAR(40) NOT NULL DEFAULT '' ,ASSETBOOKID NVARCHAR(10) NOT NULL DEFAULT '' ,PROJTAXGROUPID NVARCHAR(10) NOT NULL DEFAULT '' ,PROJSALESCURRENCYID NVARCHAR(3) NOT NULL DEFAULT '' ,PROJLINEPROPERTYID NVARCHAR(10) NOT NULL DEFAULT '' ,PROJTAXITEMGROUPID NVARCHAR(10) NOT NULL DEFAULT '' ,PROJUNITID NVARCHAR(10) NOT NULL DEFAULT '' ,PROJSALESPRICE NUMERIC(28,12) NOT NULL DEFAULT 0 ,INVENTREFTYPE INT NOT NULL DEFAULT 0 ,INVENTREFID NVARCHAR(20) NOT NULL DEFAULT '' ,INVENTREFTRANSID NVARCHAR(20) NOT NULL DEFAULT '' ,PROFITSET INT NOT NULL DEFAULT 0 ,ACTIVITYNUMBER NVARCHAR(10) NOT NULL DEFAULT '' ,RELEASEDATE DATETIME NOT NULL DEFAULT '1900-01-01 00:00:00.000' ,RELEASEDATETZID INT NOT NULL DEFAULT 37001 ,DATAAREAID NVARCHAR(4) NOT NULL DEFAULT 'dat' ,RECVERSION INT NOT NULL DEFAULT 1 ,RECID BIGINT NOT NULL CHECK (RECID <> 0) ) "

    For more information, see Help and Support Center at go.microsoft.com/.../events.asp.

  • Lauras U Profile Picture
    Lauras U 955 on at
    Re: I have Problems during SQL data dictionary synchronization?

    We had similar problem with newly added fields when moving objects from usr to var. So fields was newly added to ax, but not to database. We managed to solve this by deleting those fileld records from sqlDictionary (AOT->Sys documentation->Tables->Sqldictionary) and then syncing table again. But your problem a bit differs, because error  is system table itself. So I just can guess. Make full application and DB backup and try to delete records of inventjournaltrans from sqldictionary and syncronize table again. See event viewer to know if error changes.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    Re: I have Problems during SQL data dictionary synchronization?

    Complete the following steps:

    1) Administrator -> Periodic -> Compile application

    2) SQL Administration

    If it doesn't solve, please backup your InventJournalTrans table, drop it, synch it, and transfer back data again.

    Regards,

    S.C.GAN

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier 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)

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#2
Community Member Profile Picture

Community Member 2

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans