How to migrate database view in an update set

[mauricio23]

I haven't found a way to migrate database views. I've tried the following:

Update sets yields this error:

Could not find a table u_test_users_companies this update requires

What should I be doing instead?

[mauricio23]

I moved the update set from DEV to TEST... getting the error while in the preview.

I tried to import the XML file to the database view but it's not uploading for some reason.

I'll try and create manually and re-run it.

[mauricio23]

ok - I exported the database view from DEV and imported it into TEST.

I noticed however that the tables and joins were not pulled in however.

and I am still getting the same error message.

[mauricio23 · Accepted solution]

ok - I ended up splitting up my update sets into smaller sets. The first one being the database view piece, followed by the joins, and lastly the labels. This worked.

[valerie_gallot]

Is it still the case in Istanbul?

I get a similar error while installing an update set that contains a database view...

Do I have to split into smaller update sets ? Or is there a better way?

thanks !

[Aman Gurram]

I know this is an old post.but just incase if someones looking for an alternative way from not creating multiple update sets to Migrate a database view. I faced the same problem. Accepting the preview errors resolved my issue as described in the below link. https://community.servicenow.com/community?id=community_question&sys_id=8c9ffae9db58dbc01dcaf3231f961963