topic SYS-E-HTTPFAIL, Stream component initialization function has failed for component 'Oracle', type 'Oracle'.. in Qlik Replicate

SYS-E-HTTPFAIL, Stream component initialization function has failed for component 'Oracle', type 'Oracle'..

SaranyaK — Wed, 19 Jan 2022 18:56:20 GMT

All - I am getting a following error in my Oracle connection

SYS-E-HTTPFAIL, Stream component initialization function has failed for component 'Oracle', type 'Oracle'..
SYS,GENERAL_EXCEPTION,Stream component initialization function has failed for component 'Oracle', type 'Oracle'.,Cannot load <oci.dll, >: The operation completed successfully. Cannot load <oci.dll>: The specified module could not be found.

Any idea what is causing this?

Re: SYS-E-HTTPFAIL, Stream component initialization function has failed for component 'Oracle', type 'Oracle'..

SwathiPulagam — Wed, 19 Jan 2022 19:04:09 GMT

Hi Saranya,

for the error :

The operation completed successfully. Cannot load <oci.dll>

1. make sure you have the Oracle client install, and then Restart the Replicate windows services.

2. This looks like a missing path to the latest oracle client.

2 of the paths Is the ORACLE_HOME system level environment variable

3. we have a similar case :
it was resolved by removing/renaming the oci.dll from system32. After removing the dll, please restart the replicate service and try again.

Thanks,

Swathi

Re: SYS-E-HTTPFAIL, Stream component initialization function has failed for component 'Oracle', type 'Oracle'..

SaranyaK — Wed, 19 Jan 2022 21:19:16 GMT

Thank you Swathi!!! That fixed it!