ORA-03156: OCI call timed out

[nikhilraorane]

Hi,

I am getting below error when I search for tables in Qlik replicate using Oracle as a source.

"ORA-03156: OCI call timed out"

Thanks & Regards,

Nikhil

[john_wang · Accepted solution]

Hello @nikhilraorane ,

I'm afraid I did not get your exact question from the short description however please first try this - open the Oracle endpoint, click on the Advanced tab, open Internal parameters, in the search box type executeTimeout (case sensitive) and change the value to 0 instead of the current 10000. 

Hope it helps.

Regards,

John.

[nikhilraorane]

Hi John,

Please find the below error I found in the logs.

I changed the executeTimeout value to 0 and it worked.

Thanks & Regards,

Nikhil. 

[john_wang]

Hello @nikhilraorane ,

Glad to hear that.

Regards,

John.