web

You’re offline. This is a read only version of the page.

News and Announcements icon

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

Microsoft Dynamics AX (Archived)

Unanswered

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

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Kartik Tanna 310 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Kartik Tanna 310 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

Sanhthosh.Kumar.K 2

#2

Raed Salah Bzour 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans