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

I have the same question (0)

All responses (9)

Answers (3)

Sort by

Martin Dráb 239,385 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

What exactly are you doing?

Was this reply helpful? Yes No
Anand AX 2,172 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

Faisal Fareed 10,796 User Group Leader on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Anand AX 2,172 on at

Like (0)

Report
Copy link

Link copied!

Hi Faisal Fareed,

I tried manually in the table not with a code.

Was this reply helpful? Yes No
Martin Dráb 239,385 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Abhishek_mishra 405 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

Kauto 2,734 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Faisal Fareed 10,796 User Group Leader on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Faisal Fareed 10,796 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Did it resolve your issue - please verify if did

Was this reply helpful? Yes No