Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

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

(0) ShareShare
ReportReport
Posted on by 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

  • Kartik Tanna Profile Picture
    Kartik Tanna 310 on at
    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 Profile Picture
    Kartik Tanna 310 on at
    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.

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans