topic Re: Source view does not exist in database in Qlik Compose

Source view does not exist in database

Al_gar — Fri, 14 Mar 2025 20:49:07 GMT

When I select a task map I get error message "Source View vw_ViewName used in the mapping does not exist in the database". Then the edit mapping window opens and the Landing Zone Columns section and the View dropdown options are empty.

The view exists in the source database and the user account has access to it.

Re: Source view does not exist in database

jtompkins — Mon, 26 Sep 2022 11:46:46 GMT

You probably need to clear the metadata cache and/or the landing cache.

Re: Source view does not exist in database

Al_gar — Mon, 26 Sep 2022 16:39:25 GMT

Thanks, went into Manage under DW and the "Clear Landing Cache" did the trick.

Re: Source view does not exist in database

jtompkins — Mon, 26 Sep 2022 16:39:44 GMT

The only other suggestion I can think of would be to change the project settings to check "Generate DDL scripts but do not run them", then generate instructions for the task that uses the source view, and then go back to the project settings, uncheck the same box, and then generate the instructions again. Sometimes that gets the metadata in sync when clearing the cache doesn't work.