Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

AX2012 R2 CU7 Synchronization error

Posted on by 2,695

After importing a custom layer, I started receiving 3 errors during synchronization: Cannot complete the data definition query on the ReqTransView.   I chose cancel on the sync, removed the modifications (which did make the query invalid) and saved the view.  The sync ran again, displaying the same 3 errors, duplicated, so now there are 6.  I am now up to 16 errors, after multiple attempts, for issues that I know are cured.  I have:

- checked the id values for all tables underlying the view.  

-There was a view within a view, so I dropped them both in SQL.  

-replaced the datasource with a different one

- I have stopped and started the AOS, completed full compiles without error, and generated CIL without error.  

-I used the cache tool to refresh the dictionary, data and objects.  

Any ideas about what could cause this?

  • Brandon Wiese Profile Picture
    Brandon Wiese 17,786 on at
    RE: AX2012 R2 CU7 Synchronization error

    I also see this quite a bit and have to purge the SQLSYNCINFO table, or the same 16 messages (all warnings related to configuration key and no actual errors) just continue to accumulate, i.e. 32 next time, 48 after that.  

  • lispyj Profile Picture
    lispyj 2,695 on at
    RE: AX2012 R2 CU7 Synchronization error

    Thanks everyone for the input!

  • Verified answer
    skaue Profile Picture
    skaue on at
    RE: AX2012 R2 CU7 Synchronization error

    Douglas might be right.

    Please have a look at this blog post by Palle Agermark:

    www.agermark.com/.../odd-synchronization-issues-in-ax-2012.html

    Stop the AOS and check SQLSYNCINFO table.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AX2012 R2 CU7 Synchronization error

    can you try running a check synchronize and looking at the sql for the synch directly? looking for your view will show what AX is trying to do and you can probably figure it out from there

  • Verified answer
    Douglas Noel Profile Picture
    Douglas Noel 3,905 on at
    RE: AX2012 R2 CU7 Synchronization error

    OK. There seems to be a bug (feature) with old messeages. I've had exactly the same: 21 Error(Warnings) then 42 the 63 and so on and so on and so on and .............

    The bug seems to be fixes meanwhile and shouldn't occur in future (as long If you haven't old data in the table)

    Can you please try de empty the SQLSYNCINFO table. (stop the AOS first)

    Now retry the sync.

    regards

    Douglas

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,989 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans