can we add parameter "-Doracle.jdbc.fanEnabled=false" on Airbyte due to the issue "LineGobbler(voidCall):85 - SEVERE: attempt to configure ONS in FanManager failed with oracle.ons.NoServersAvailable: Subscription time out"

[Brianlifung]

Enviroment

• Airbyte version: 0.27.3-alpha
• OS Version / Instance: Ubuntu 16.04.7 LTS
• Deployment: Docker
• Source Connector and version: Oracle DB connector: 0.3.1
• Destination Connector and version: Snowflake 5.29.1
• Severity: Medium
• Step where error happened: Setup new connection

Current Behavior

Setting source to connect Oracle and Destination to Snowflake, passed checking on source and destination but hangs on setup connection.(there is 1 4G size table on Oracle schema)
checked the log it is related to "LineGobbler(voidCall):85 - SEVERE: attempt to configure ONS in FanManager failed with oracle.ons.NoServersAvailable: Subscription time out"

Expected Behavior

want to have parameter to disable using Fan at Airbyte application "-Doracle.jdbc.fanEnabled=false"
reference : https://stackoverflow.com/questions/58873384/spring-boot-app-error-log-says-attempt-to-configure-ons-in-fanmanager-failed-wit

Logs

2021-07-26 07:17:46 INFO () TemporalAttemptExecution(get):110 - Executing worker wrapper. Airbyte version: 0.27.3-alpha
2021-07-26 07:17:46 INFO () LineGobbler(voidCall):85 - Checking if airbyte/source-oracle:0.3.1 exists...
2021-07-26 07:17:46 INFO () LineGobbler(voidCall):85 - airbyte/source-oracle:0.3.1 was found locally.
2021-07-26 07:17:46 INFO () DockerProcessFactory(create):146 - Preparing command: docker run --rm --init -i -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -w /data/5e4ae478-4522-4294-a8ba-be252743f6b5/0 --network host --log-driver none airbyte/source-oracle:0.3.1 check --config source_config.json
2021-07-26 07:17:48 INFO () DefaultAirbyteStreamFactory(lambda$create$0):73 - 2021-07-26 07:17:48 [32mINFO[m i.a.i.s.o.OracleSource(main):72 - {} - starting source: class io.airbyte.integrations.source.oracle.OracleSource
2021-07-26 07:17:48 INFO () DefaultAirbyteStreamFactory(lambda$create$0):73 - 2021-07-26 07:17:48 [32mINFO[m i.a.i.b.IntegrationRunner(run):78 - {} - Running integration: io.airbyte.integrations.source.oracle.OracleSource
2021-07-26 07:17:48 INFO () DefaultAirbyteStreamFactory(lambda$create$0):73 - 2021-07-26 07:17:48 [32mINFO[m i.a.i.b.IntegrationCliParser(parseOptions):135 - {} - integration args: {check=null, config=source_config.json}
2021-07-26 07:17:48 INFO () DefaultAirbyteStreamFactory(lambda$create$0):73 - 2021-07-26 07:17:48 [32mINFO[m i.a.i.b.IntegrationRunner(run):82 - {} - Command: CHECK
2021-07-26 07:17:48 INFO () DefaultAirbyteStreamFactory(lambda$create$0):73 - 2021-07-26 07:17:48 [32mINFO[m i.a.i.b.IntegrationRunner(run):83 - {} - Integration config: IntegrationConfig{command=CHECK, configPath='source_config.json', catalogPath='null', statePath='null'}
2021-07-26 07:17:48 INFO () DefaultAirbyteStreamFactory(lambda$create$0):73 - 2021-07-26 07:17:48 [32mINFO[m i.a.i.s.j.AbstractJdbcSource(lambda$getCheckOperations$1):152 - {} - Attempting to get metadata from the database to see if we can connect.
2021-07-26 07:18:19 ERROR () LineGobbler(voidCall):85 - Jul 26, 2021 7:18:19 AM oracle.simplefan.impl.FanManager configure
2021-07-26 07:18:19 ERROR () LineGobbler(voidCall):85 - SEVERE: attempt to configure ONS in FanManager failed with oracle.ons.NoServersAvailable: Subscription time out
2021-07-26 07:18:21 INFO () TemporalAttemptExecution(get):133 - Stopping cancellation check scheduling...

LOG

replace this with
your long log
output here

Steps to Reproduce

1. create Oracle source at Source
2. create Snowflake Destination
3. set up connection linking Oracle and snowflake, see All passed for Source and Destination but hangs at set a new connection.

Are you willing to submit a PR?

Remove this with your answer.

┆Issue is synchronized with this Asana task by Unito

[sherifnada]

@Brianlifung thanks for creating the issue! Would you be open to create a PR to address this?

[Brianlifung]

can you guild me how to do it?

[etsybaev]

Hi there.
A new "custom jdbc parameters" field has been introduced. So since now, any additional param may be added to the connector's config.
This should also resolve this ticket. Please feel free to re-open the ticket in case of any issues.