A Qlik Replicate task with an Oracle target fails with the following in the task log:
[TARGET_LOAD ]T: ORA-03156: OCI call timed out
This can be expected with long-running executions during a full load.
Resolution
To disable the timeout, set the Internal Parameter executeTimeout on the Oracle target endpoint.
- Go to the Oracle Endpoint connection
- Switch to the Advanced tab
- Click Internal Parameters
- Add executeTimeout with a value of 0
For more information about Internal Parameters, see Qlik Replicate: How to set Internal Parameters and what are they for?
Environment
Qlik Replicate