Unable to run the landing task to land data on to snowflake

[akaradhya]

Hi Team,

We have setup Qlik Gateway on our Linux server. As part of testing the entire data flow we are moving data from MySql on to Snowflake.

As part of this, we have installed both the MySql and snowflake driver on the gateway machine. 

On QCDI, we are able to load the select tables from MySql but when we run the landing task, we are encountering the below error. Looked up online for this error and tried out of a few different workarounds, but was not able to resolve this issue. Below is the error that we are facing. Reaching out to the community to throw some light on this. 

Error Message: 

00021296: 2023-04-03T19:49:01 [METADATA_MANAGE ]E: RetCode: SQL_ERROR SqlState: HY000 NativeError: 4 Message: [Snowflake][Snowflake] (4) REST request for URL https://hy81676.ap-south-1.aws.snowflakecomputing.com:443/session/v1/login-request?requestId=b24c510... failed: CURLerror (curl_easy_perform() failed) - code=77 msg='Problem with the SSL CA cert (path? access rights?)' osCode=32 osMsg='Broken pipe'. [1022502] (ar_odbc_conn.c:584)00021296: 2023-04-03T19:49:01 [METADATA_MANAGE ]E: Cannot connect to Cloud server [1022502] (cloud_imp.c:3929)00021296: 2023-04-03T19:49:01 [METADATA_MANAGE ]E: Failed while preparing stream component 'EP_dQlG4yXlFTy7Vwr1BAgQDw'. [1022502] (metadatamanager.c:855)00021296: 2023-04-03T19:49:01 [METADATA_MANAGE ]E: Cannot create the target utility component [1022502] (metadatamanager.c:760)00021296: 2023-04-03T19:49:01 [TASK_MANAGER ]E: Creating Metadata Manager's utility components failed [1022502] (replicationtask.c:3875)00021296: 2023-04-03T19:49:01 [TASK_MANAGER ]W: Task 'TASK_bXvbR9NgDuoIzEJygk589w' encountered a recoverable error (repository.c:5919)

Thanks!

[CF_Debarati]

Hi @akaradhya ,

We would like to set up a call to investigate the issue further. But since as per the user guide, we should use Redhat or equivalent Linux 8.x (64-bit), please get the 8.x version, where the issue is still likely to exist, and we can have the call.

User Guide link:  https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Gateways/dm-gateway-prer...  

Data Movement gateway is certified for installation on Red Hat 8.x (64-bit). Although Data Movement gateway is certified on Red Hat, it is also supported on corresponding and compatible Linux distributions.

[akaradhya]

Hi @CF_Debarati 

I upgraded our CentOS version to 8.x. Post the upgrade, I tried connecting to snowflake using the curl command and I was able to connect successfully. 

But once I tried to run the landing job, I am facing the below issue:

00012110: 2023-04-19T13:48:27 [METADATA_MANAGE ]E: RetCode: SQL_ERROR SqlState: HY000 NativeError: 4 Message: [Snowflake][Snowflake] (4) REST request for URL https://hy81676.ap-south-1.aws.snowflakecomputing.com:443/session/v1/login-request?requestId=1c93b12... failed: CURLerror (curl_easy_perform() failed) - code=77 msg='Problem with the SSL CA cert (path? access rights?)' osCode=32 osMsg='Broken pipe'. [1022502] (ar_odbc_conn.c:584)00012110: 2023-04-19T13:48:27 [METADATA_MANAGE ]E: Cannot connect to Cloud server [1022502] (cloud_imp.c:3929)00012110: 2023-04-19T13:48:27 [METADATA_MANAGE ]E: Failed while preparing stream component 'EP_lrauTmu_U93PQd6MF-5iZA'. [1022502] (metadatamanager.c:855)00012110: 2023-04-19T13:48:27 [METADATA_MANAGE ]E: Cannot create the target utility component [1022502] (metadatamanager.c:760)00012110: 2023-04-19T13:48:27 [TASK_MANAGER ]E: Creating Metadata Manager's utility components failed [1022502] (replicationtask.c:3875)00012110: 2023-04-19T13:48:27 [TASK_MANAGER ]W: Task 'TASK_KDmEpb_hY_qJYW1KzqGeZQ' encountered a recoverable error (repository.c:5919)

[CF_Debarati]

Hi @akaradhya ,

I have sent you an email to set up a call with you for further investigation. Please answer to the email.

[CF_Debarati]

The solution was to install the snowflake ODBC driver on the gateway machine and restart the repagent service, after which the task ran successfully.

User Guide link:  https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/TargetCo...