News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) AX 2012R3 Synchronizat...

Microsoft Dynamics AX (Archived)

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

(0) Share

Report

Report

Posted on by Alejandro Garza

40

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 Img

All responses (2)

Answers Img

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.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans