Creating a new record in table showing error?

(0) Share

Report

Posted on by Anand AX

2,172

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

All responses (9)

Answers (3)

Faisal Fareed 10,794 User Group Leader on at

Like (0)

Report

RE: Creating a new record in table showing error?

Did it resolve your issue - please verify if did
Verified answer

Faisal Fareed 10,794 User Group Leader on at

Like (1)

Report

RE: Creating a new record in table showing error?

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.
Verified answer

Kauto 2,650 on at

Like (1)

Report

RE: Creating a new record in table showing error?

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
Suggested answer

Abhishek_mishra 405 on at

Like (1)

Report

RE: Creating a new record in table showing error?

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.
Martin Dráb 230,445 Most Valuable Professional on at

Like (1)

Report

RE: Creating a new record in table showing error?

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.
Anand AX 2,172 on at

Like (0)

Report

RE: Creating a new record in table showing error?

Hi Faisal Fareed,

I tried manually in the table not with a code.
Verified answer

Faisal Fareed 10,794 User Group Leader on at

Like (1)

Report

RE: Creating a new record in table showing error?

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
Anand AX 2,172 on at

Like (0)

Report

RE: Creating a new record in table showing error?

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.
Martin Dráb 230,445 Most Valuable Professional on at

Like (0)

Report

RE: Creating a new record in table showing error?

If it already exists, what's the point in creating it again?

What exactly are you doing?