topic Re: Data Warehouse already contains tables error while creating a new DW in Qlik Compose

Data Warehouse already contains tables error while creating a new DW

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

Hello,

We keep on getting the error stating Data Warehouse tables are already present when we try to create new Data Warehouse in Compose. Tried resetting the project and also cannot see any new tables in the target database. Can anyone assist with getting around this error ?

Re: Data Warehouse already contains tables error while creating a new DW

Nanda_Ravindra — Mon, 14 Nov 2022 20:33:36 GMT

@Abhi_719 Are you sure these DHW tables are not there in the database ? please check the views; if any are present, you'll need to delete that and retry the create DWH option.

If the above doesn't work, please share the screenshot of the DWH pannel.

Thanks,

Nanda

Re: Data Warehouse already contains tables error while creating a new DW

Abhi_719 — Mon, 14 Nov 2022 20:53:38 GMT

@Nanda_Ravindra we are positive there are no tables or views in the database. We do have tables present from other projects which I think should be irrelevant to our current project.

Also, I would guess that resetting project should clear the tables out too. We have tried a few times but does not work.

Re: Data Warehouse already contains tables error while creating a new DW

Nanda_Ravindra — Mon, 14 Nov 2022 21:35:54 GMT

@Abhi_719 I agree re-setting the project should have cleared the tables if there are any tables/views left behind. Based on what I see from the screenshot it looks like there is some caching issue. Before I have you open a case with support, I would like to try the below 2 options:

Option#1:

From the project drop-down menu, select the 'setting ' and enable “Generate DDL scripts but do not run them”
In the DWH pane, select the 'create database' option, once created close the window - this will create a DWH script and ask you to run the script manually, but no need to run any script outside of Compose.
Go back to the project drop-down menu, select the 'setting ' and disable “Generate DDL scripts but do not run them”
From the DWH pane drop-down menu, select the 'drop and recreate table' option and only enable 'Drop table' - see below
Compose should now let you create the data warehouse table

Note: In steps #1 thru 3, we are tricking Compose to think there are table that exists in the database.

Option#2 :

1. . Create a deployment package

2. Delete and recreate the same project

3. If you need the model then deploy the package from step#1

Hopefully one of them will work for you.

Thanks,

Nanda

Re: Data Warehouse already contains tables error while creating a new DW

Tool_Tip — Wed, 26 Mar 2025 07:18:16 GMT

Dear,

I am facing same issue. Tried all the steps above but no luck