Hi Everyone,
I encountered the below error while synchronizing the Data Dictionary.
Please help me..
*This post is locked for comments
Hi Vilmos,
That was indeed a great explanation!
Thank you very much for that :)
When i went through the Error description in detail, i saw that there were a few fields in the InsertInto statement which caused problems. I removed those fields from SalesLine and now its good :)
Thank you, again!
Each metadata object in your AOT have a unique identifier, which you could see on the top if you go to the Properties of your table and field.
Then if you navigate in the AOT to System documentation > Tables > SQLDictionary, right click, select Add-ins and Table browse, you would see the object that AX thinks are there in your actual database within SQL. Now if these IDs sitting in the table do not match with the ones in the AOT, that is a problem which will cause your DB synchronization to throw errors similar to what you got. For example it tries to convert a field from one to another.
You may use an ID conflict resolving tool written by other AX developers, however do not do that in a Production environment unless you know and understand what the job is (and you are) doing.
To ensure that your IDs are correct, normally people create a Build environment off from Production, so initially these IDs will be matching. Then any code changes can only be introduced to your Build environment, where the new objects will get a new ID. Then from the build environment you would be releasing the AX ModelStore, which does carry over your IDs to Production, and not cause a problem like you have at the moment with the XPOs.
Thanks for the replies..
Martin,
I imported a few XPOs to the environment.
Also, i just now noticed that this error is related to the SalesLine table.
The insert into statement in the screenshot is for the SalesLine table.
Vilmos,
Can you please explain in brief about the ID conflicts? Also, what is required to be done for table/field identifiers to be in sync with SQLDictionary table?
Your table/field identifiers are out of synch from the SQLDictionary table. This is due to incorrectly releasing code to an environment. You need to sort out the ID conflicts on those objects.
It seems that you have several different errors there. What did you do with the environment before running synchronization?
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 2 Most Valuable Professional
Guy Terry 2 Moderator
Community Member 2
