You’re offline. This is a read only version of the page.
114
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
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.
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.
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
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
#1
Mohamed Amine Mahmoudi
100
Super User 2025 Season 1
#2
Community Member
48
#3
Zain Mehmood
6
Moderator
Share
Report
All responses (
Answers (
