Hi all,
I tried to create a new record in dimensionAttributeValueCombination Table , But its showing error as "The record already exists". I urgently need to create one new record with the display value of "SD-0009700997". Also tried with update and insert method, no use same error. Please help me with this...
*This post is locked for comments
Did it resolve your issue - please verify if did
HI Anand, It is not a good practice to create records in this table from table browser. If you have a look on the index of this table you will see its indexed on HashId which for sure you don't have at the time of creation record directly. You should have to look on the link I shared and create dimension Id from your display value accordingly.
Anand - there is an index on this table relating to the HASH field, this is hidden by default in the AOT - you should not be creating records manually in this table. Either way I am guessing there is already a record with a blank hash value and your record is also trying to put in a blank hash value - hence it says the record exists.
Make the HASH field visible and you will see
You cannot create directly through table browser. 'Hash' field is unique index here with data dyte container.
You are not suppored to insert record from table browser anyways.
This is ledger dimension table. Please refer to artical suggested by Faisal.
And do you know how to manually build the value of the primary key of this table, namely the Hash container? I don't think it's the case. It's not something you can done manually and what you should do directly in code. Use API intended for this purpose.
By the way, I noticed that you mentioned dimension combination in your parallel thread about default dimensions. I hope you understand that this is about ledger dimensions, not default dimensions.
Hi Faisal Fareed,
I tried manually in the table not with a code.
Hi Anand, How are you creating new record in this table? Are you doing this through code? Have a look here blogs.msdn.com/.../creating-financial-dimension-combinations-in-ax-2012.aspx
Hi Martin Drab,
Thanks for the reply. Actually i am trying to create new record in dimensionAttributeValueCombination Table. But it is not allowing me to create a new record. Its always showing the error as "The record already exists"(But it doesn't exists). i tried with different display values.
If it already exists, what's the point in creating it again?
What exactly are you doing?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,151 Super User 2024 Season 2
Martin Dráb 229,993 Most Valuable Professional
nmaenpaa 101,156