Qlik Replicate an Oracle target: ORA-03156: OCI call timed out

[Steve_Nguyen]

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.

1. Go to the Oracle Endpoint connection
2. Switch to the Advanced tab
3. Click Internal Parameters
4. 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