AX2012 R2 CU7 Synchronization error

(0) Share

Report

Posted on by lispyj

181

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 have the same question (0)

All responses (5)

Answers (2)

Verified answer

Douglas Noel 3,905 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Tommy Skaue Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
lispyj 181 on at

Like (0)

Report

Thanks everyone for the input!

Was this reply helpful? Yes No
Brandon Wiese 17,788 on at

Like (0)

Report

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.

Was this reply helpful? Yes No