topic Re: Generate ETL: Log Tables Not Present in Qlik Compose

Generate ETL: Log Tables Not Present

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

Hello. I am attempting to drop and recreate a DW in Compose Version November 2020 (7.0.0.253)

I am receiving this error when attempting to generate the ETL instructions, so that I can then Run the ETL.

I cannot find anything in the documentation relating to it, nor a search here.

Any help would be appreciated, thank you.

Re: Generate ETL: Log Tables Not Present

shashi_holla — Thu, 19 Jan 2023 20:56:15 GMT

Hi @santoi21

By looking at the error message looks like the TLOG tables are missing in the Datawarehouse schema. Could you please validate the DataWarehouse and check if it throws any errors.

Thanks,

Re: Generate ETL: Log Tables Not Present

santoi21 — Thu, 19 Jan 2023 20:59:08 GMT

Thank you for the response. When I validate the DW it completes successfully:

Re: Generate ETL: Log Tables Not Present

shashi_holla — Thu, 19 Jan 2023 21:16:45 GMT

On a side note, 7.0 version is already out of Support and you should plan for an upgrade soon.

The original error just says that the TLOG tables are missing but the task instructions are generated successfully and should be able to run them.

But if you like to avoid getting the error then please Drop and create the Datawarehouse tables as per the user guide link below.

https://help.qlik.com/en-US/compose/August2021/Content/ComposeDWDL/Main/DW/Data%20Warehouse/drop_and_recreate_tables.htm

The link is for a newer version of Compose but process should not have changed much.

Thank you,

Re: Generate ETL: Log Tables Not Present

santoi21 — Thu, 19 Jan 2023 21:25:08 GMT

Thank you, I realized that also in debugging I kept "Generate DDL scripts but do not run" selected in the project settings, that was probably preventing the full drop and recreate.

Following the steps worked, and I will let my manager know its time to upgrade! I marked your reply as correct.

Re: Generate ETL: Log Tables Not Present

shashi_holla — Thu, 19 Jan 2023 21:29:26 GMT

Great, Thank you.