Our support engineers have assembled the top recommended solutions for you.
Microsoft Dynamics AX 2012CRM Connector in Microsoft Dynamics AX 2012Financials Management in Microsoft Dynamics AX 2012Upgrading to Microsoft Dynamics AX 2012
Microsoft Dynamics AX 2009
Application Object Server (AOS)
Enterprise Portal and Role Centers
Inventory Costing in Microsoft Dynamics AX 2009
Invoice Settlements/Discounts/Reversals
SSRS and SSAS Integration
Workflow
Attempting to synchronize the database in a AX 2102 install the following errors happen:
I am hoping somebody in the AX community can explain how these arrors can be corrected.
Hi,
Can you see the SQL statement that is being used to create the view from the error message?
My blog | PBC
This posting is provided "AS IS" with no warranties, and confers no rights.
The system table SQLDictionary has a list of the tables and fields with id's. It could sound like a mismatch between the id's in the table and the id's shown when looking at the properties on the field in the AOT. It can be a massive task getting that fixed if they pile up.
I have earlier managed to fix errors like this by simply flipping the table to In-memory in type, synchronize the table and then flip it back.
Note, that this will truncate the table so you might want to copy the data to another database first and then back afterwards.
Maybe you want to try this on a copy of the database first. :)