Qlik Replicate tasks fail to start: Error ORA-12170: TNS:Connect timeout occurred

[Dineshan]

After a Qlik Replicate task was stopped to update parameters, the task will not start. A new task referencing the same source fails to fetch its tables and errors out with the following:

SYS-E-HTTPFAIL, SYS-E-HTTPFAIL, Command get_owner_list failed when creating the stream component...
SYS,GENERAL_EXCEPTION,SYS-E-HTTPFAIL, Command get_owner_list failed when creating the stream component..,SYS,GENERAL_EXCEPTION,Command get_owner_list failed when creating the stream component.,Failed getting stream handle create_stream_handle failed Command create_stream_handle failed when preparing component. ORA-12170: TNS:Connect timeout occurred

Resolution

ORA-12170 is an Oracle connection error and is not caused by Qlik Replicate. Qlik Replicate will send a connection request through the Oracle client, which will establish a connection to the database based on the sqlnet.ora settings. ORA-12170: TNS:Connect timeout occurred indicates a timeout.

To resolve the error, update sqlnet.ora and increase the available timeouts.

1. Navigate to (default location) C:\app\client\Administrator\product\12.1.0\client_1\network\admin
2. Open sqlnet.ora
3. Modify or add the below:
   
   SQLNET.INBOUND_CONNECT_TIMEOUT_LISTENER=360
   SQLNET.INBOUND_CONNECT_TIMEOUT=360
   SQLNET.RECV_TIMEOUT=160
   SQLNET.SEND_TIMEOUT=160
   BREAK_POLL_SKIP=10000
   DISABLE_OOB=on
   
   
4. Stop and resume task task

Environment

Qlik Replicate  

[MoeE]

Hi,

We're experiencing this error while the task is running normally. Also, we don't see the filepath listed here on our system.

Regards,

Mohammed

[Dana_Baldwin]

Hi @MoeE 

The exact path to the sqlnet.ora file can vary but it is always in the ..\network\admin folder on the Replicate server in the area where the Oracle client is installed. Your Oracle DBA should be able to help if you continue to have difficulty implementing the above solution.

Thanks,

Dana