Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / AX2012 R2 CU7 Synchron...
Microsoft Dynamics AX (Archived)

AX2012 R2 CU7 Synchronization error

(0) ShareShare
ReportReport
Posted on by lispyj 2,751

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?

*This post is locked for comments

  • 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,751 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

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

Product updates

Dynamics 365 release plans