End of mainstream support for Microsoft Dynamics AX 2009, 2012, and 2012Mainstream support for Dynamics AX 2009 Service Pack 1 (SP1), Dynamics AX 2012, and Dynamics AX 2012 R2 ended Oct. 9, 2018. After that date, only security hotfixes will be provided for these three versions through the extended support period that until Oct. 12, 2021. Read more
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Talent TechTalks
I face problem that looks weird.
The version of AX is just AX2012(neither R2 nor R3).
When I try to insert some data into (table)EcoResTrackingDimensionGroupProduct, an error like below appears and not be able to insert the data.
Of course the table doesn't have the data.
How can I solve this situation?
Your first screenshot shows the table with data. As it is showing record ID's I cannot comment if the product is included already or not. However, also check which indexes are used on this table and see if they prevent duplicates.
The only index which is not be able to duplicate is product field, and I'm sure that the same product doesn't exist in the table as I shared the image.
Just to make sure there is no problem with RecId (as duplicates are not allowed), can you try creating a new item directly in released products and see if it goes through. It would atleast help isolate the problem.
Your screenshots don't provide enough information to understand the problem.
- We can see that Product recId 5637154327 doesn't exist in EcoResTrackingDimensionGroupProduct.
- We can see that trying to insert a record where product number is 033505010 and tracking dimension is BN fails because of "The record already exists" error.
We don't have any link between these two pieces of information. Could you maybe share some screenshot where we could see if EcoResProduct 033505010 has RecId 5637154327?
By the way, have you done any data management operations such as imported data directly in SQL lately? If yes, your RecId number sequences might not be up to date, and that would also explain this issue. In SystemSequences table AX stores the next available RecId for each table. If that sequence gives numbers that are actually already present as RecId in the target table, you would also see this error.
All replies inspired me to access this problem.
There is conflict with RecId.
It was really helpful for me.
Business Applications communities