Update set deployment issue

[Vijay Kumar4]

I'm encountering an issue while deploying my update set. I have three fields involved: Category, Subcategory 1, and Subcategory 2. Subcategory 1 depends on Category, and Subcategory 2 depends on Subcategory 1.

In my update set, I’ve added new values to Subcategory 1 and Subcategory 2. However, in the production org, several values were added directly (not via update sets). Now, when I try to deploy my update set, I receive the following error:

"Found a local update that is newer than this one."

How can I resolve this? I need to retain both the existing values in production and the new values from my update set. Is it possible to merge the remote update into the local version without losing any data? I'd appreciate your help.

[RaghavSh]

1.This is sys_choice table so the best approach here is to import the choices for particular fields to dev instance via xml from prod.

2. Make required changes like addition or deletion in an update set and them move it from dev to prod.