Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Unanswered

Enum value sync issue

(1) ShareShare
ReportReport
Posted on by 242

Hi All,

We are facing an issue with Enum value sync in DB.

Scenario :

We created a new enum, ex., TestEnum with elements as below and deployed to the Tier 2 environment.

Enum value

Name

0

B

1

C

2

D

Later, we added a new element and changed the enum value as below and deployed again to the Tier 2 environment.

Enum value

Name

0

A

1

B

2

C

3

D

But the enum values in the standard - 'EnumValueTable' is not getting changed unless we manually delete the data for the particular EnumId and resync the data. 

As we don't have provision to backend in Tier 2 environment, we are not able to proceed with this workaround.

Could someone please suggest your inputs on this issue!

Thanks!

 

  • Martin Dráb Profile Picture
    Martin Dráb 230,379 Most Valuable Professional on at
    Enum value sync issue
    I've moved this thread from Dynamics AX forum, because several things suggest it's actually about F&O.
     
    It seems you created a non-extensible enum and then you manually changed the meaning of value 2 from TestEnum::D to TestEnum::C. Then it's you who "caused mismatches between UI and DB".
  • Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Enum value sync issue
    Hi,
    In this case, I agree with Andre's approach. At present, I don't know why this problem arises or how to solve it, so we can avoid this problem in another way. You can choose to add a new record instead of modifying it and re-editing it to meet your needs.
    Best regards,
    Kevin
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,661 Super User 2024 Season 2 on at
    Enum value sync issue
    Hi Suren,
     
    In case you have an enumeration with predefined values, I wonder why you renumbered the values. Why didn't you add A with enum value 3? You can then still manage the order for the user starting with an A. In that case, you don't have this type of issue.
  • Suren_G Profile Picture
    Suren_G 242 on at
    Enum value sync issue
    Hi Waed,
     
    Yes, we updated the exiting element name in the enum and added a new element. But the updated values are not syncing to the 'EnumValueTable' and it causes mismatches between UI and DB. 
     
    Thanks!
  • Waed Ayyad Profile Picture
    Waed Ayyad 6,500 Super User 2024 Season 2 on at
    Enum value sync issue
    Hi,
     
    Did you update the already-existing records, as some records will have wrong values?
     

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,379 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans