Replication task: TASK_w9FMXAgcLS8UyeaZd6CUzA on server: local_repsrv failed with fatal error. To see detailed logs, select the "..." menu and View lo

[BouwerQlik]

I'm trying to create a Pipeline between an On Prem Server and Snowflake using Qlik Cloud Data Integration.

When preparing the Onboard Landing I'm getting the below errors in the Logs:

00052616: 2023-12-19T10:29:31 [METADATA_MANAGE ]E: RetCode: SQL_ERROR SqlState: 01000 NativeError: 0 Message: [unixODBC][Driver Manager]Can't open lib 'SnowflakeDSIIDriver' : file not found [1022502] (ar_odbc_conn.c:584)00052616: 2023-12-19T10:29:31 [METADATA_MANAGE ]E: Cannot connect to Cloud server [1022501] (cloud_imp.c:4445)00052616: 2023-12-19T10:29:31 [METADATA_MANAGE ]E: Failed while preparing stream component 'EP_5MBC6itJAfH_fXACJvkW2g'. [1022501] (metadatamanager.c:855)00052616: 2023-12-19T10:29:31 [METADATA_MANAGE ]E: Cannot create the target utility component [1022501] (metadatamanager.c:760)00052616: 2023-12-19T10:29:31 [TASK_MANAGER ]E: Creating Metadata Manager's utility components failed [1022501] (replicationtask.c:3896)00052616: 2023-12-19T10:29:31 [TASK_MANAGER ]W: Task 'TASK_iBQTeRpRGafCnhxePLfAMg' encountered a fatal error (repository.c:6064)

[TimGarrod]

Hello, it appears the drivers have not been installed on the data movement gateway. 

 Message: [unixODBC][Driver Manager]Can't open lib 'SnowflakeDSIIDriver' : file not found [1022502]   

Please ensure the drivers for source and targets are installed by running the driver mgmt utility.   

Eg. for installing Snowflake on your gateway machine (ensure python is installed on the server) and follow the below directions -

The help docs show how to run the utility on the gateway - https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/TargetCo...