Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Enum value sync issue
Finance | Project Operations, Human Resources, ...
Unanswered

Enum value sync issue

(1) ShareShare
ReportReport
Posted on by Suren_G 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 231,432 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... 292,516 Super User 2025 Season 1 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 7,587 Super User 2025 Season 1 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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,432 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans