topic Re: Changing compose data warehouse database name - SQL code references old database name value in Qlik Compose

Changing compose data warehouse database name - SQL code references old database name value

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

I have changed the Compose DATA WAREHOUSE connection (database name), cleared the metadata cache and regenerated the tasks.

Getting errors when running a tasks: Generated Sql code still references old database name.

Re: Changing compose data warehouse database name - SQL code references old database name value

Nanda_Ravindra — Wed, 24 Aug 2022 15:32:21 GMT

Hello @Pierre_G Looks like you are on one of our older versions of Compose. What version of Compose are you running?

Do you see an option to clear the landing cache under the DWH pannel? If so, please clear that as well and let me know if that address the issue.

Please share the screenshot of the error if that error persists.

Thanks,

Nanda

Re: Changing compose data warehouse database name - SQL code references old database name value

Pierre_G — Wed, 24 Aug 2022 18:09:02 GMT

Running Qlik Compose 2021.8.0.372

I clicked on the DWH Clear Metadata Cache and on the Manage Task Clear Landing Cache

I have regenerated all statements - no errors

When running etl getting this error:
Terminated: sqlstate S0002, errorcode 208, message Invalid object name CDW2.CDW_ODS_ADMIN.TSTG_E002_ELCTRL_EVENT.

The connection CDW2 was changed to CDW but the staging table sql code still uses the old value.

Re: Changing compose data warehouse database name - SQL code references old database name value

jtompkins — Mon, 29 Aug 2022 12:13:33 GMT

I am on the same version as you. Try going to settings and check the "generate DDL scripts but do not run them" box. Then generate your task instructions. Then uncheck the same box in settings and generate them again. That workaround usually refreshes the metadata, even though it's annoying to do every time.

Re: Changing compose data warehouse database name - SQL code references old database name value

Pierre_G — Mon, 29 Aug 2022 13:52:35 GMT

Thanks. this seems to have worked.