Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Creating a new record in table showing error?

Posted on by 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

  • Faisal Fareed Profile Picture
    Faisal Fareed 10,794 User Group Leader on at
    RE: Creating a new record in table showing error?

    Did it resolve your issue - please verify if did

  • Verified answer
    Faisal Fareed Profile Picture
    Faisal Fareed 10,794 User Group Leader on at
    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 Profile Picture
    Kauto 2,650 on at
    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 Profile Picture
    Abhishek_mishra 405 on at
    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 Profile Picture
    Martin Dráb 229,993 Most Valuable Professional on at
    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 Profile Picture
    Anand AX 2,172 on at
    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 Profile Picture
    Faisal Fareed 10,794 User Group Leader on at
    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 Profile Picture
    Anand AX 2,172 on at
    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 Profile Picture
    Martin Dráb 229,993 Most Valuable Professional on at
    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?

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.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,993 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans