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

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

Rak — Tue, 11 Mar 2025 21:53:07 GMT

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?

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

narendersarva — Tue, 11 Mar 2025 22:14:50 GMT

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

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

Rak — Wed, 12 Mar 2025 01:51:31 GMT

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/google_prereq_SNOW.htm

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

VXS1031 — Thu, 13 Mar 2025 13:26:10 GMT

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

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

eltonpereira — Fri, 20 Jun 2025 19:04:11 GMT

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

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

john_wang — Sat, 21 Jun 2025 01:07:27 GMT

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.

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

Rak — Fri, 27 Jun 2025 18:40:58 GMT

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

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

john_wang — Sat, 28 Jun 2025 01:24:40 GMT

Thank you for the update! @Rak