Generating ETL instructions (both basic and all validations) for a data warehouse task fails at random for different tasks with the following error:
Undefined error
Clicking on more details shows no additional information. The same task will generate the instructions successfully at a different time.
This may occur after an upgrade of the Snowflake ODBC drivers (for example from 2.24 to 2.25.11).
As a troubleshooting step, turning up the Qlik Compose logs to verbose does not capture the undefined error, but the Windows Event logs show a crash of the Qlik Compose service.
Review the Windows Events (Application) log for Application Errors. Opening the log reveals an error such as:
Faulting application name: ComposeCtl.exe, version
Faulting module name: SnowflakeDSll.dll
Exception code: 0xc0000005
Resolution
A defect in the 2.25.11 Snowflake driver is causing this issue. Downgrading to 2.25.6 resolves the ‘undefined’ error and prevents the crash.
See Snowflake ODBC Driver Release Notes.
Environment
Qlik Compose 2021.02 and above
