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.
- Navigate to (default location) C:\app\client\Administrator\product\12.1.0\client_1\network\admin
- Open sqlnet.ora
- 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
- Stop and resume task task
Environment
Qlik Replicate