Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Dimension Value already exists

Posted on by 92
Hello,
 
I created a blank company and I tried uploading Dimension and Dimension Values using a configuration package.
 
However, when I upload the table i get the message that the value already exists. I can get around this by deleting the table record before processing.
 
Can anyone explain why i get this error in the first place and how I can avoid this in the future?
 
 
 
 
Thanks
 
 
 
 
  • INITMAN007 Profile Picture
    INITMAN007 92 on at
    Dimension Value already exists
    Hi Yi,
     
    Non customizations, I am working in a CDX environment.
     
    Thanks
  • Suggested answer
    Yi Yong Profile Picture
    Yi Yong 1,007 Super User 2024 Season 2 on at
    Dimension Value already exists
    Hello INITMAN,
     
    Do you have any customizations for Dimension Value?
    I tried exporting table:349 and importing back the same file and there is no error.
     
  • INITMAN007 Profile Picture
    INITMAN007 92 on at
    Dimension Value already exists
    Hi Valentin,
     
    The screen shot was after my first attempt at loading the dimensions. Previously there was nothing loaded, it was a blank company
     
    It appears that BC loaded the dimensions and then gave me the error that the dimensions already exists. 
     
    It seems that BC is trying to load the data twice and then giving the error??
     
     
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,061 Super User 2024 Season 2 on at
    Dimension Value already exists
    At what point in the process did you take the screenshot? In the screenshot the dimensions are already loaded in the system, and you're trying to load them again:
     
     
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 3,952 on at
    Dimension Value already exists
    It’s indeed strange that the configuration package modifies data even when the dimensions are already present.
     
    Have you tried importing data using the Excel sheet? - do this and check
    I recommend creating a new blank company and testing the upload there.
     
    This can help you determine if the issue is specific to your current setup or if it persists across different environments.
     
  • INITMAN007 Profile Picture
    INITMAN007 92 on at
    Dimension Value already exists
    Hi gdrenteria,
     
    The company was a new blank company and i checked and the dimensions where blank. But i still got the error?
     
    Thanks
  • gdrenteria Profile Picture
    gdrenteria 11,307 Most Valuable Professional on at
    Dimension Value already exists
    Hi
    You have been able to check if that value already exists in the dimension table, the message indicates that it already exists and you cannot upload it again.
    Best
    GR

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,912 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,355 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans