Error in migrating the update Set

[Community Alums]

Hi,

I am migrating the update set to Test and I see this error 'Could not find a record in sys_user for column manager referenced in this update' What might be the issue please.

Regards

Suman P.

[Sandeep Rajput · Accepted solution]

@Community Alums This issue is occurring because one of the updates refers to a user in the manager column which is no longer available in the sys_user table on the Test instance.

To fix this error, identify the record which is causing this error in the update set XML. Once identified remove it from your update set or update the manager field on the source record and make it empty and redeploy the changes on the Test intance. 

[Community Alums]

Hi @Sandeep Rajput,

Is there a way to identify which record it is missing?

[Sandeep Rajput]

@Community Alums In the error it must be showing the sys_id of the missing user, search with that sys_id in your update set XML and you will be able to find the record.

[Zach Koch]

The column, manager, that is referenced in your update set is not in your targeted environment. I'm assuming this a user created field that never got put into the targeted environment. You need to have that column captured from the environment to your target environment and then you shouldn't see this conflict message.