AX 2012R3 Synchronization Errors 'Failed to generate query for constrained table'

(0) Share

Report

Posted on by Alejandro Garza

Hello,

We have started a new AX2012R3 installation from scratch, slipstreaming the CU8. After finishing the previous tasks in the checklist successfully, including the X++ and CIL compilation, when attempting to synchronize the database, the following error comes up:

'Failed to generate query for constrained table X for policy DirRestrictViewPartyInAddressBook_Cust for query DirRestrictViewPartyInAddressBook'.

This error comes up multiple times, with different tables.

I haven't been able to find any online documentation covering this type of problem, has anyone had a similar experience? I would appreciate any suggestions.

Thank you in advance.

*This post is locked for comments

All responses (2)

Answers (0)

Kartik Tanna 310 on at

Like (0)

Report

RE: AX 2012R3 Synchronization Errors 'Failed to generate query for constrained table'

What we figured out is when running the SYNC from AOT does not throw any of these errors. It happends only when we run SYNC from Software update checklist screen.
Kartik Tanna 310 on at

Like (0)

Report

RE: AX 2012R3 Synchronization Errors 'Failed to generate query for constrained table'

Hi Alejandro,

I recently ran into the similar issue and trying to find the resolution.

Did you ever find out a solution or a work around for this error ?

Thanks.