Notifications
Announcements
No record found.
Hi all!
Where Dynamics AX 2012 contain table Ids sequence?
*This post is locked for comments
What are you trying to achieve by setting a table ID manually?
I just want to create unique Ids in different AX instances (different development teams). For grant possibility of union application models with data to one instance in future.
The Application Object Ids are allocated sequentially by the AX kernel. If you would go around the problem by creating +1000 dummy tables to artificially increase next tableid to be +1001 on top of the first free object id within the available range, once you export that object and put it in another AX instance, the kernel there will re-number it to become the next one in the sequence (+11 for example if you have 10 custom-created tables in the target environment).
I have not tried to manipulate object IDs directly in the modelstore's ModelElement* tables and in SQLDictionary/SystemSequences, but that could also be one (very risky, untested) way to isolate them. But then again, once you export/import them, it is getting re-numbered anyway.
You're talking about AX 2012, where object IDs are installation specific. You'll simply get a new set of IDs when you install models to another environment, and IDs are even not stored in version control at all, therefore there is no risk of conflicts.
I understand, what that solution (set table ID) not best, but business dictated such conditions.
Thanks for yours answers. I will inform managers about possible problems.
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 Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Priya_K 4
Martin Dráb 4 Most Valuable Professional
MyDynamicsNAV 2
