Qlik Replicate : Configure snowflake Target - keeps failing with timeout when waiting for child process to open pipe

[Rak]

• SYS-E-HTTPFAIL, SYS-E-HTTPFAIL, Timeout when waiting for child process to open pipe '\\.\pipe\replicate_child_proc_pipe_3320_6944_11'..
• SYS,GENERAL_EXCEPTION,SYS-E-HTTPFAIL, Timeout when waiting for child process to open pipe '\\.\pipe\replicate_child_proc_pipe_3320_6944_11'.,SYS,GENERAL_EXCEPTION,Timeout when waiting for child process to open pipe '\\.\pipe\replicate_child_proc_pipe_3320_6944_11'
  
  

we have installed the ODBC driver (64-bit) after Replicate installation. 

On Replicate Server, configuring the system DSN to connect to snowflake works. What am i missing?

[narendersarva · Accepted solution]

Hi @Rak  Since you installed the Snowflake ODBC driver after Qlik Replicate, check that the driver version is compatible with your Qlik Replicate version. Also, after installing a new ODBC driver, restart Qlik Replicate services to ensure it picks up the latest driver.

Thanks
Naren

[Rak]

We pretty much followed the instructions listed in the Qlik documentation., https://help.qlik.com/en-US/replicate/November2024/Content/Replicate/Main/Snowflake_Google_Target/go...

[VXS1031]

Hi @Rak ,

Can you try using this parameter in Snowflake Target endpoint in the advanced tab.

Select Additional ODBC connection properties:

enter the below property

CLIENT_SESSION_KEEP_ALIVE=true;ABORT_DETACHED_QUERY=true;CLIENT_SESSION_KEEP_ALIVE_HEARTBEAT_FREQUENCY=900;

Thanks,

Surya

[eltonpereira]

Has anyone fixed this issue by adding this parameter? I am still having the same error

[john_wang]

Hello @eltonpereira ,

The error message "Timeout when waiting for child process to open pipe" when working with Snowflake usually points to a resource, network, or concurrency issue between Qlik Replicate and Snowflake.For example, certain VPN connections may not function properly and can lead to this error in Qlik Replicate.

Could you please confirm whether SnowSQL is working in your environment? This would help determine if the issue is related to general connectivity.
Also, please verify which version of the Snowflake ODBC driver you're currently using. Upgrading to a newer version may help resolve the issue.

thanks,

John.

[Rak · Accepted solution]

We encountered the same issue with Snowflake connectivity after upgrading Replicate. Restarting the Replicate VMs resolved the issue.!

[john_wang]

Thank you for the update! @Rak