Could not find a table field -Database view

[nancyhz]

I have created a database view by joining with other 4 tables.   It works well in our dev instance, but when this database view was moved to our test instance, we got the error-"Could not find a table field referenced in this update" for all fields (14 column fields).   I think all fields created from database view are not in target instance that is why I got this error, am I right?       Shall I Accept Remote Update for all same error?     Any suggestion?

[ghsrikanth]

Yes, accept the remote update set, it comes when the join is commiting before the creation of view step, once you accept remote update set. It should be fine.

Hopefully it helps

[nancyhz]

Thank you.

[ghsrikanth]

Hi Nancyhz,

If the answer is helpful or correct, could you please mark it as correct, so that it will help future users of community

Thanks,

[Pradeep Sharma]

Hi Nancyhz,

Please check section 3.1 for more detailed info on how to resolve preview problems.

Transferring Update Sets - ServiceNow Wiki