2022-07-08 05:04:07 INFO i.a.v.j.JsonSchemaValidator(test):71 - JSON schema validation failed. errors: $.storage: must be a constant value HTTPS 2022-07-08 05:04:07 INFO i.a.v.j.JsonSchemaValidator(test):71 - JSON schema validation failed. errors: $.storage: must be a constant value GCS 2022-07-08 05:04:07 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword airbyte_secret - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-07-08 05:04:07 INFO i.a.v.j.JsonSchemaValidator(test):71 - JSON schema validation failed. errors: $.storage: must be a constant value S3 2022-07-08 05:04:07 INFO i.a.v.j.JsonSchemaValidator(test):71 - JSON schema validation failed. errors: $.storage_account: is missing but it is required, $.storage: must be a constant value AzBlob 2022-07-08 05:04:07 INFO i.a.v.j.JsonSchemaValidator(test):71 - JSON schema validation failed. errors: $.user: is missing but it is required, $.host: is missing but it is required, $.storage: must be a constant value SSH 2022-07-08 05:04:07 INFO i.a.v.j.JsonSchemaValidator(test):71 - JSON schema validation failed. errors: $.user: is missing but it is required, $.host: is missing but it is required, $.storage: must be a constant value SCP 2022-07-08 05:04:07 INFO i.a.v.j.JsonSchemaValidator(test):71 - JSON schema validation failed. errors: $.user: is missing but it is required, $.host: is missing but it is required, $.storage: must be a constant value SFTP 2022-07-08 05:04:07 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword order - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-07-08 05:04:07 INFO i.a.w.t.TemporalAttemptExecution(get):108 - Docker volume job log path: /tmp/workspace/222/0/logs.log 2022-07-08 05:04:07 INFO i.a.w.t.TemporalAttemptExecution(get):113 - Executing worker wrapper. Airbyte version: 0.39.35-alpha 2022-07-08 05:04:07 INFO i.a.c.f.EnvVariableFeatureFlags(getEnvOrDefault):43 - Using default value for environment variable USE_STREAM_CAPABLE_STATE: 'false' 2022-07-08 05:04:07 INFO i.a.c.i.LineGobbler(voidCall):82 - Checking if airbyte/source-file:0.2.10 exists... 2022-07-08 05:04:07 INFO i.a.c.i.LineGobbler(voidCall):82 - airbyte/source-file:0.2.10 was found locally. 2022-07-08 05:04:07 INFO i.a.w.p.DockerProcessFactory(create):108 - Creating docker job ID: 222 2022-07-08 05:04:07 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/222/0 --log-driver none --name source-file-check-222-0-ytylz --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=false -e WORKER_ENVIRONMENT=DOCKER -e AIRBYTE_ROLE= -e WORKER_JOB_ATTEMPT=0 -e WORKER_CONNECTOR_IMAGE=airbyte/source-file:0.2.10 -e AIRBYTE_VERSION=0.39.35-alpha -e WORKER_JOB_ID=222 airbyte/source-file:0.2.10 check --config source_config.json 2022-07-08 05:04:11 INFO i.a.w.i.DefaultAirbyteStreamFactory(internalLog):97 - Checking access to file:///local/projectperiodpvo.csv... 2022-07-08 05:04:11 INFO i.a.w.i.DefaultAirbyteStreamFactory(internalLog):97 - Check succeeded 2022-07-08 05:04:12 INFO i.a.w.t.TemporalAttemptExecution(get):134 - Stopping cancellation check scheduling... 2022-07-08 05:04:12 INFO i.a.w.t.TemporalAttemptExecution(get):108 - Docker volume job log path: /tmp/workspace/222/0/logs.log 2022-07-08 05:04:12 INFO i.a.w.t.TemporalAttemptExecution(get):113 - Executing worker wrapper. Airbyte version: 0.39.35-alpha 2022-07-08 05:04:12 INFO i.a.c.f.EnvVariableFeatureFlags(getEnvOrDefault):43 - Using default value for environment variable USE_STREAM_CAPABLE_STATE: 'false' 2022-07-08 05:04:12 INFO i.a.c.i.LineGobbler(voidCall):82 - Checking if airbyte/destination-oracle:0.1.16 exists... 2022-07-08 05:04:12 INFO i.a.c.i.LineGobbler(voidCall):82 - airbyte/destination-oracle:0.1.16 was found locally. 2022-07-08 05:04:12 INFO i.a.w.p.DockerProcessFactory(create):108 - Creating docker job ID: 222 2022-07-08 05:04:12 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/222/0 --log-driver none --name destination-oracle-check-222-0-jvita --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=false -e WORKER_ENVIRONMENT=DOCKER -e AIRBYTE_ROLE= -e WORKER_JOB_ATTEMPT=0 -e WORKER_CONNECTOR_IMAGE=airbyte/destination-oracle:0.1.16 -e AIRBYTE_VERSION=0.39.35-alpha -e WORKER_JOB_ID=222 airbyte/destination-oracle:0.1.16 check --config source_config.json 2022-07-08 05:04:14 ERROR i.a.c.i.LineGobbler(voidCall):82 - SLF4J: Class path contains multiple SLF4J bindings. 2022-07-08 05:04:14 ERROR i.a.c.i.LineGobbler(voidCall):82 - SLF4J: Found binding in [jar:file:/airbyte/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-07-08 05:04:14 ERROR i.a.c.i.LineGobbler(voidCall):82 - SLF4J: Found binding in [jar:file:/airbyte/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-07-08 05:04:14 ERROR i.a.c.i.LineGobbler(voidCall):82 - SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. 2022-07-08 05:04:14 ERROR i.a.c.i.LineGobbler(voidCall):82 - SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] 2022-07-08 05:04:15 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-07-08 05:04:15 INFO i.a.i.d.o.OracleDestination(main):156 - starting destination: class io.airbyte.integrations.destination.oracle.OracleDestination 2022-07-08 05:04:15 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-07-08 05:04:15 INFO i.a.i.b.IntegrationCliParser(parseOptions):118 - integration args: {check=null, config=source_config.json} 2022-07-08 05:04:15 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-07-08 05:04:15 INFO i.a.i.b.IntegrationRunner(runInternal):121 - Running integration: io.airbyte.integrations.base.ssh.SshWrappedDestination 2022-07-08 05:04:15 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-07-08 05:04:15 INFO i.a.i.b.IntegrationRunner(runInternal):122 - Command: CHECK 2022-07-08 05:04:15 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-07-08 05:04:15 INFO i.a.i.b.IntegrationRunner(runInternal):123 - Integration config: IntegrationConfig{command=CHECK, configPath='source_config.json', catalogPath='null', statePath='null'} 2022-07-08 05:04:15 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-07-08 05:04:15 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword order - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-07-08 05:04:15 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-07-08 05:04:15 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword examples - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-07-08 05:04:15 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-07-08 05:04:15 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword airbyte_secret - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-07-08 05:04:15 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-07-08 05:04:15 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword multiline - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-07-08 05:04:16 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-07-08 05:04:16 INFO i.a.i.b.s.SshTunnel(getInstance):170 - Starting connection with method: NO_TUNNEL 2022-07-08 05:04:18 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-07-08 05:04:18 INFO i.a.d.j.DefaultJdbcDatabase(lambda$unsafeQuery$1):106 - closing connection 2022-07-08 05:04:18 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-07-08 05:04:18 INFO i.a.d.j.DefaultJdbcDatabase(lambda$unsafeQuery$1):106 - closing connection 2022-07-08 05:04:18 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-07-08 05:04:18 INFO i.a.d.j.DefaultJdbcDatabase(lambda$unsafeQuery$1):106 - closing connection 2022-07-08 05:04:18 INFO i.a.w.t.TemporalAttemptExecution(get):134 - Stopping cancellation check scheduling... 2022-07-08 05:04:19 INFO i.a.w.t.TemporalAttemptExecution(get):108 - Docker volume job log path: /tmp/workspace/222/0/logs.log 2022-07-08 05:04:19 INFO i.a.w.t.TemporalAttemptExecution(get):113 - Executing worker wrapper. Airbyte version: 0.39.35-alpha 2022-07-08 05:04:19 INFO i.a.c.f.EnvVariableFeatureFlags(getEnvOrDefault):43 - Using default value for environment variable USE_STREAM_CAPABLE_STATE: 'false' 2022-07-08 05:04:19 INFO i.a.w.g.DefaultReplicationWorker(run):115 - start sync worker. job id: 222 attempt id: 0 2022-07-08 05:04:19 INFO i.a.w.g.DefaultReplicationWorker(run):127 - configured sync modes: {null.JULPERIODS=full_refresh - overwrite} 2022-07-08 05:04:19 INFO i.a.w.i.DefaultAirbyteDestination(start):69 - Running destination... 2022-07-08 05:04:19 INFO i.a.c.f.EnvVariableFeatureFlags(getEnvOrDefault):43 - Using default value for environment variable USE_STREAM_CAPABLE_STATE: 'false' 2022-07-08 05:04:19 INFO i.a.c.i.LineGobbler(voidCall):82 - Checking if airbyte/destination-oracle:0.1.16 exists... 2022-07-08 05:04:19 INFO i.a.c.i.LineGobbler(voidCall):82 - airbyte/destination-oracle:0.1.16 was found locally. 2022-07-08 05:04:19 INFO i.a.w.p.DockerProcessFactory(create):108 - Creating docker job ID: 222 2022-07-08 05:04:19 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/222/0 --log-driver none --name destination-oracle-write-222-0-zeqso --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=false -e WORKER_ENVIRONMENT=DOCKER -e AIRBYTE_ROLE= -e WORKER_JOB_ATTEMPT=0 -e WORKER_CONNECTOR_IMAGE=airbyte/destination-oracle:0.1.16 -e AIRBYTE_VERSION=0.39.35-alpha -e WORKER_JOB_ID=222 airbyte/destination-oracle:0.1.16 write --config destination_config.json --catalog destination_catalog.json 2022-07-08 05:04:19 INFO i.a.c.f.EnvVariableFeatureFlags(getEnvOrDefault):43 - Using default value for environment variable USE_STREAM_CAPABLE_STATE: 'false' 2022-07-08 05:04:19 INFO i.a.c.i.LineGobbler(voidCall):82 - Checking if airbyte/source-file:0.2.10 exists... 2022-07-08 05:04:19 INFO i.a.c.i.LineGobbler(voidCall):82 - airbyte/source-file:0.2.10 was found locally. 2022-07-08 05:04:19 INFO i.a.w.p.DockerProcessFactory(create):108 - Creating docker job ID: 222 2022-07-08 05:04:19 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/222/0 --log-driver none --name source-file-read-222-0-qichz --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=false -e WORKER_ENVIRONMENT=DOCKER -e AIRBYTE_ROLE= -e WORKER_JOB_ATTEMPT=0 -e WORKER_CONNECTOR_IMAGE=airbyte/source-file:0.2.10 -e AIRBYTE_VERSION=0.39.35-alpha -e WORKER_JOB_ID=222 airbyte/source-file:0.2.10 read --config source_config.json --catalog source_catalog.json --state input_state.json 2022-07-08 05:04:19 INFO i.a.w.g.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$7):405 - Destination output thread started. 2022-07-08 05:04:19 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):298 - Replication thread started. 2022-07-08 05:04:19 INFO i.a.w.g.DefaultReplicationWorker(run):169 - Waiting for source and destination threads to complete. 2022-07-08 05:04:20 destination > SLF4J: Class path contains multiple SLF4J bindings. 2022-07-08 05:04:20 destination > SLF4J: Found binding in [jar:file:/airbyte/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-07-08 05:04:20 destination > SLF4J: Found binding in [jar:file:/airbyte/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-07-08 05:04:20 destination > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. 2022-07-08 05:04:21 destination > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] 2022-07-08 05:04:22 destination > 2022-07-08 05:04:22 INFO i.a.i.d.o.OracleDestination(main):156 - starting destination: class io.airbyte.integrations.destination.oracle.OracleDestination 2022-07-08 05:04:22 destination > 2022-07-08 05:04:22 INFO i.a.i.b.IntegrationCliParser(parseOptions):118 - integration args: {catalog=destination_catalog.json, write=null, config=destination_config.json} 2022-07-08 05:04:22 destination > 2022-07-08 05:04:22 INFO i.a.i.b.IntegrationRunner(runInternal):121 - Running integration: io.airbyte.integrations.base.ssh.SshWrappedDestination 2022-07-08 05:04:22 destination > 2022-07-08 05:04:22 INFO i.a.i.b.IntegrationRunner(runInternal):122 - Command: WRITE 2022-07-08 05:04:22 destination > 2022-07-08 05:04:22 INFO i.a.i.b.IntegrationRunner(runInternal):123 - Integration config: IntegrationConfig{command=WRITE, configPath='destination_config.json', catalogPath='destination_catalog.json', statePath='null'} 2022-07-08 05:04:22 destination > 2022-07-08 05:04:22 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword order - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-07-08 05:04:22 destination > 2022-07-08 05:04:22 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword examples - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-07-08 05:04:22 destination > 2022-07-08 05:04:22 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword airbyte_secret - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-07-08 05:04:23 destination > 2022-07-08 05:04:23 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword multiline - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-07-08 05:04:23 destination > 2022-07-08 05:04:23 INFO i.a.i.b.s.SshTunnel(getInstance):170 - Starting connection with method: NO_TUNNEL 2022-07-08 05:04:23 destination > 2022-07-08 05:04:23 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):97 - Write config: WriteConfig{streamName=JULPERIODS, namespace=null, outputSchemaName=AIRBYTE_USER, tmpTableName=airbyte_tmp_JULPERIODS_4a5515ee1237487d80c17265507ab10b, outputTableName=airbyte_raw_JULPERIODS, syncMode=overwrite} 2022-07-08 05:04:24 destination > 2022-07-08 05:04:24 INFO i.a.i.d.b.BufferedStreamConsumer(startTracked):116 - class io.airbyte.integrations.destination.buffered_stream_consumer.BufferedStreamConsumer started. 2022-07-08 05:04:24 destination > 2022-07-08 05:04:24 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):122 - Preparing tmp tables in destination started for 1 streams 2022-07-08 05:04:24 destination > 2022-07-08 05:04:24 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):126 - Preparing tmp table in destination started for stream JULPERIODS. schema: AIRBYTE_USER, tmp table name: airbyte_tmp_JULPERIODS_4a5515ee1237487d80c17265507ab10b 2022-07-08 05:04:24 source > Reading JULPERIODS (file:///local/projectperiodpvo.csv)... 2022-07-08 05:04:26 destination > 2022-07-08 05:04:26 INFO i.a.d.j.DefaultJdbcDatabase(lambda$unsafeQuery$1):106 - closing connection 2022-07-08 05:04:26 destination > 2022-07-08 05:04:26 INFO i.a.d.j.DefaultJdbcDatabase(lambda$unsafeQuery$1):106 - closing connection 2022-07-08 05:04:26 destination > 2022-07-08 05:04:26 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):132 - Preparing tables in destination completed. 2022-07-08 05:04:26 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 1000 (193 KB) 2022-07-08 05:04:27 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 2000 (386 KB) 2022-07-08 05:04:28 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 3000 (580 KB) 2022-07-08 05:04:28 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 4000 (774 KB) 2022-07-08 05:04:29 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 5000 (967 KB) 2022-07-08 05:04:29 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 6000 (1 MB) 2022-07-08 05:04:30 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 7000 (1 MB) 2022-07-08 05:04:30 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 8000 (1 MB) 2022-07-08 05:04:31 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 9000 (1 MB) 2022-07-08 05:04:31 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 10000 (1 MB) 2022-07-08 05:04:32 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):335 - Total records read: 10950 (2 MB) 2022-07-08 05:04:32 INFO i.a.w.g.DefaultReplicationWorker(run):174 - One of source or destination thread complete. Waiting on the other. 2022-07-08 05:04:32 destination > 2022-07-08 05:04:32 INFO i.a.i.b.FailureTrackingAirbyteMessageConsumer(close):65 - Airbyte message consumer: succeeded. 2022-07-08 05:04:32 destination > 2022-07-08 05:04:32 INFO i.a.i.d.b.BufferedStreamConsumer(close):170 - executing on success close procedure. 2022-07-08 05:04:32 destination > 2022-07-08 05:04:32 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):84 - Flushing JULPERIODS: 10950 records (8 MB) 2022-07-08 05:11:01 destination > Exception in thread "main" java.sql.SQLRecoverableException: No more data to read from socket 2022-07-08 05:11:01 destination > at oracle.jdbc.driver.T4CMAREngineNIO.prepareForUnmarshall(T4CMAREngineNIO.java:804) 2022-07-08 05:11:01 destination > at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:449) 2022-07-08 05:11:01 destination > at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:410) 2022-07-08 05:11:01 destination > at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269) 2022-07-08 05:11:01 destination > at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655) 2022-07-08 05:11:01 destination > at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270) 2022-07-08 05:11:01 destination > at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91) 2022-07-08 05:11:01 destination > at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970) 2022-07-08 05:11:01 destination > at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205) 2022-07-08 05:11:01 destination > at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666) 2022-07-08 05:11:01 destination > at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1426) 2022-07-08 05:11:01 destination > at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3778) 2022-07-08 05:11:01 destination > at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1081) 2022-07-08 05:11:01 destination > at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94) 2022-07-08 05:11:01 destination > at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94) 2022-07-08 05:11:01 destination > at io.airbyte.integrations.destination.oracle.OracleOperations.lambda$insertRawRecordsInSingleQuery$1(OracleOperations.java:148) 2022-07-08 05:11:01 destination > at io.airbyte.db.jdbc.DefaultJdbcDatabase.execute(DefaultJdbcDatabase.java:45) 2022-07-08 05:11:01 destination > at io.airbyte.integrations.destination.oracle.OracleOperations.insertRawRecordsInSingleQuery(OracleOperations.java:120) 2022-07-08 05:11:01 destination > at io.airbyte.integrations.destination.oracle.OracleOperations.insertRecords(OracleOperations.java:105) 2022-07-08 05:11:01 destination > at io.airbyte.integrations.destination.jdbc.JdbcBufferedConsumerFactory.lambda$recordWriterFunction$2(JdbcBufferedConsumerFactory.java:150) 2022-07-08 05:11:01 destination > at io.airbyte.integrations.destination.record_buffer.InMemoryRecordBufferingStrategy.lambda$flushAll$1(InMemoryRecordBufferingStrategy.java:86) 2022-07-08 05:11:01 destination > at io.airbyte.integrations.base.sentry.AirbyteSentry.executeWithTracing(AirbyteSentry.java:54) 2022-07-08 05:11:01 destination > at io.airbyte.integrations.destination.record_buffer.InMemoryRecordBufferingStrategy.flushAll(InMemoryRecordBufferingStrategy.java:82) 2022-07-08 05:11:01 destination > at io.airbyte.integrations.destination.buffered_stream_consumer.BufferedStreamConsumer.close(BufferedStreamConsumer.java:171) 2022-07-08 05:11:01 destination > at io.airbyte.integrations.base.FailureTrackingAirbyteMessageConsumer.lambda$close$0(FailureTrackingAirbyteMessageConsumer.java:67) 2022-07-08 05:11:01 destination > at io.airbyte.integrations.base.sentry.AirbyteSentry.executeWithTracing(AirbyteSentry.java:54) 2022-07-08 05:11:01 destination > at io.airbyte.integrations.base.FailureTrackingAirbyteMessageConsumer.close(FailureTrackingAirbyteMessageConsumer.java:67) 2022-07-08 05:11:01 destination > at io.airbyte.integrations.base.AirbyteMessageConsumer$1.lambda$close$0(AirbyteMessageConsumer.java:63) 2022-07-08 05:11:01 destination > at io.airbyte.integrations.base.sentry.AirbyteSentry.executeWithTracing(AirbyteSentry.java:54) 2022-07-08 05:11:01 destination > at io.airbyte.integrations.base.AirbyteMessageConsumer$1.close(AirbyteMessageConsumer.java:62) 2022-07-08 05:11:01 destination > at io.airbyte.integrations.base.IntegrationRunner.runInternal(IntegrationRunner.java:164) 2022-07-08 05:11:01 destination > at io.airbyte.integrations.base.IntegrationRunner.run(IntegrationRunner.java:105) 2022-07-08 05:11:01 destination > at io.airbyte.integrations.destination.oracle.OracleDestination.main(OracleDestination.java:157) 2022-07-08 05:11:02 ERROR i.a.w.g.DefaultReplicationWorker(run):180 - Sync worker failed. java.util.concurrent.ExecutionException: io.airbyte.workers.general.DefaultReplicationWorker$DestinationException: Destination process exited with non-zero exit code 1 at java.util.concurrent.CompletableFuture.reportGet(CompletableFuture.java:396) ~[?:?] at java.util.concurrent.CompletableFuture.get(CompletableFuture.java:2073) ~[?:?] at io.airbyte.workers.general.DefaultReplicationWorker.run(DefaultReplicationWorker.java:175) ~[io.airbyte-airbyte-workers-0.39.35-alpha.jar:?] at io.airbyte.workers.general.DefaultReplicationWorker.run(DefaultReplicationWorker.java:65) ~[io.airbyte-airbyte-workers-0.39.35-alpha.jar:?] at io.airbyte.workers.temporal.TemporalAttemptExecution.lambda$getWorkerThread$2(TemporalAttemptExecution.java:158) ~[io.airbyte-airbyte-workers-0.39.35-alpha.jar:?] at java.lang.Thread.run(Thread.java:833) [?:?] Suppressed: io.airbyte.workers.exception.WorkerException: Destination process exit with code 1. This warning is normal if the job was cancelled. at io.airbyte.workers.internal.DefaultAirbyteDestination.close(DefaultAirbyteDestination.java:119) ~[io.airbyte-airbyte-workers-0.39.35-alpha.jar:?] at io.airbyte.workers.general.DefaultReplicationWorker.run(DefaultReplicationWorker.java:137) ~[io.airbyte-airbyte-workers-0.39.35-alpha.jar:?] at io.airbyte.workers.general.DefaultReplicationWorker.run(DefaultReplicationWorker.java:65) ~[io.airbyte-airbyte-workers-0.39.35-alpha.jar:?] at io.airbyte.workers.temporal.TemporalAttemptExecution.lambda$getWorkerThread$2(TemporalAttemptExecution.java:158) ~[io.airbyte-airbyte-workers-0.39.35-alpha.jar:?] at java.lang.Thread.run(Thread.java:833) [?:?] Caused by: io.airbyte.workers.general.DefaultReplicationWorker$DestinationException: Destination process exited with non-zero exit code 1 at io.airbyte.workers.general.DefaultReplicationWorker.lambda$getDestinationOutputRunnable$7(DefaultReplicationWorker.java:420) ~[io.airbyte-airbyte-workers-0.39.35-alpha.jar:?] at java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1804) ~[?:?] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) ~[?:?] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[?:?] ... 1 more 2022-07-08 05:11:02 INFO i.a.w.g.DefaultReplicationWorker(run):239 - sync summary: io.airbyte.config.ReplicationAttemptSummary@7d2557b1[status=failed,recordsSynced=10950,bytesSynced=2170830,startTime=1657256659296,endTime=1657257062111,totalStats=io.airbyte.config.SyncStats@139f5ffd[recordsEmitted=10950,bytesEmitted=2170830,stateMessagesEmitted=0,recordsCommitted=0],streamStats=[io.airbyte.config.StreamSyncStats@7bf42f87[streamName=JULPERIODS,stats=io.airbyte.config.SyncStats@41fd3fe4[recordsEmitted=10950,bytesEmitted=2170830,stateMessagesEmitted=,recordsCommitted=]]]] 2022-07-08 05:11:02 INFO i.a.w.g.DefaultReplicationWorker(run):268 - Source did not output any state messages 2022-07-08 05:11:02 WARN i.a.w.g.DefaultReplicationWorker(run):276 - State capture: No new state, falling back on input state: io.airbyte.config.State@16b260b5[state={}] 2022-07-08 05:11:02 INFO i.a.w.t.TemporalAttemptExecution(get):134 - Stopping cancellation check scheduling... 2022-07-08 05:11:02 INFO i.a.w.t.s.ReplicationActivityImpl(lambda$replicate$3):161 - sync summary: io.airbyte.config.StandardSyncOutput@1f22ef63[standardSyncSummary=io.airbyte.config.StandardSyncSummary@7dee253f[status=failed,recordsSynced=10950,bytesSynced=2170830,startTime=1657256659296,endTime=1657257062111,totalStats=io.airbyte.config.SyncStats@139f5ffd[recordsEmitted=10950,bytesEmitted=2170830,stateMessagesEmitted=0,recordsCommitted=0],streamStats=[io.airbyte.config.StreamSyncStats@7bf42f87[streamName=JULPERIODS,stats=io.airbyte.config.SyncStats@41fd3fe4[recordsEmitted=10950,bytesEmitted=2170830,stateMessagesEmitted=,recordsCommitted=]]]],normalizationSummary=,state=io.airbyte.config.State@16b260b5[state={}],outputCatalog=io.airbyte.protocol.models.ConfiguredAirbyteCatalog@3e8925c7[streams=[io.airbyte.protocol.models.ConfiguredAirbyteStream@5d0fe58f[stream=io.airbyte.protocol.models.AirbyteStream@555e40ba[name=JULPERIODS,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"ORGID":{"type":["number","null"]},"REPORTDATE":{"type":["string","null"]},"GLPERIODNAME":{"type":["string","null"]},"GLPERIODTYPE":{"type":["string","null"]},"GLPERIODNUMBER":{"type":["number","null"]},"GLADJPERIODFLAG":{"type":["string","null"]},"GLPERIODSETNAME":{"type":["string","null"]},"GLQUARTERNUMBER":{"type":["number","null"]}}},supportedSyncModes=[full_refresh],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[],additionalProperties={}]],additionalProperties={}],failures=[io.airbyte.config.FailureReason@599550f3[failureOrigin=destination,failureType=,internalMessage=io.airbyte.workers.general.DefaultReplicationWorker$DestinationException: Destination process exited with non-zero exit code 1,externalMessage=Something went wrong within the destination connector,metadata=io.airbyte.config.Metadata@2e45e11b[additionalProperties={attemptNumber=0, jobId=222}],stacktrace=java.util.concurrent.CompletionException: io.airbyte.workers.general.DefaultReplicationWorker$DestinationException: Destination process exited with non-zero exit code 1 at java.base/java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:315) at java.base/java.util.concurrent.CompletableFuture.completeThrowable(CompletableFuture.java:320) at java.base/java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1807) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at java.base/java.lang.Thread.run(Thread.java:833) Caused by: io.airbyte.workers.general.DefaultReplicationWorker$DestinationException: Destination process exited with non-zero exit code 1 at io.airbyte.workers.general.DefaultReplicationWorker.lambda$getDestinationOutputRunnable$7(DefaultReplicationWorker.java:420) at java.base/java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1804) ... 3 more ,retryable=,timestamp=1657257062107]]] 2022-07-08 05:11:02 INFO i.a.w.t.TemporalUtils(withBackgroundHeartbeat):291 - Stopping temporal heartbeating... 2022-07-08 05:11:02 INFO i.a.c.f.EnvVariableFeatureFlags(getEnvOrDefault):43 - Using default value for environment variable USE_STREAM_CAPABLE_STATE: 'false' 2022-07-08 05:11:02 INFO i.a.v.j.JsonSchemaValidator(test):71 - JSON schema validation failed. errors: $.storage: must be a constant value HTTPS 2022-07-08 05:11:02 INFO i.a.v.j.JsonSchemaValidator(test):71 - JSON schema validation failed. errors: $.storage: must be a constant value GCS 2022-07-08 05:11:02 INFO i.a.v.j.JsonSchemaValidator(test):71 - JSON schema validation failed. errors: $.storage: must be a constant value S3 2022-07-08 05:11:02 INFO i.a.v.j.JsonSchemaValidator(test):71 - JSON schema validation failed. errors: $.storage_account: is missing but it is required, $.storage: must be a constant value AzBlob 2022-07-08 05:11:02 INFO i.a.v.j.JsonSchemaValidator(test):71 - JSON schema validation failed. errors: $.user: is missing but it is required, $.host: is missing but it is required, $.storage: must be a constant value SSH 2022-07-08 05:11:02 INFO i.a.v.j.JsonSchemaValidator(test):71 - JSON schema validation failed. errors: $.user: is missing but it is required, $.host: is missing but it is required, $.storage: must be a constant value SCP 2022-07-08 05:11:02 INFO i.a.v.j.JsonSchemaValidator(test):71 - JSON schema validation failed. errors: $.user: is missing but it is required, $.host: is missing but it is required, $.storage: must be a constant value SFTP 2022-07-08 05:11:02 INFO i.a.w.t.TemporalAttemptExecution(get):108 - Docker volume job log path: /tmp/workspace/222/1/logs.log 2022-07-08 05:11:02 INFO i.a.w.t.TemporalAttemptExecution(get):113 - Executing worker wrapper. Airbyte version: 0.39.35-alpha 2022-07-08 05:11:02 INFO i.a.c.f.EnvVariableFeatureFlags(getEnvOrDefault):43 - Using default value for environment variable USE_STREAM_CAPABLE_STATE: 'false' 2022-07-08 05:11:02 INFO i.a.c.i.LineGobbler(voidCall):82 - Checking if airbyte/source-file:0.2.10 exists... 2022-07-08 05:11:02 INFO i.a.c.i.LineGobbler(voidCall):82 - airbyte/source-file:0.2.10 was found locally. 2022-07-08 05:11:02 INFO i.a.w.p.DockerProcessFactory(create):108 - Creating docker job ID: 222 2022-07-08 05:11:02 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/222/1 --log-driver none --name source-file-check-222-1-bhlrc --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=false -e WORKER_ENVIRONMENT=DOCKER -e AIRBYTE_ROLE= -e WORKER_JOB_ATTEMPT=1 -e WORKER_CONNECTOR_IMAGE=airbyte/source-file:0.2.10 -e AIRBYTE_VERSION=0.39.35-alpha -e WORKER_JOB_ID=222 airbyte/source-file:0.2.10 check --config source_config.json 2022-07-08 05:11:05 INFO i.a.w.i.DefaultAirbyteStreamFactory(internalLog):97 - Checking access to file:///local/projectperiodpvo.csv... 2022-07-08 05:11:05 INFO i.a.w.i.DefaultAirbyteStreamFactory(internalLog):97 - Check succeeded 2022-07-08 05:11:06 INFO i.a.w.t.TemporalAttemptExecution(get):134 - Stopping cancellation check scheduling... 2022-07-08 05:11:06 INFO i.a.w.t.TemporalAttemptExecution(get):108 - Docker volume job log path: /tmp/workspace/222/1/logs.log 2022-07-08 05:11:06 INFO i.a.w.t.TemporalAttemptExecution(get):113 - Executing worker wrapper. Airbyte version: 0.39.35-alpha 2022-07-08 05:11:06 INFO i.a.c.f.EnvVariableFeatureFlags(getEnvOrDefault):43 - Using default value for environment variable USE_STREAM_CAPABLE_STATE: 'false' 2022-07-08 05:11:06 INFO i.a.c.i.LineGobbler(voidCall):82 - Checking if airbyte/destination-oracle:0.1.16 exists... 2022-07-08 05:11:06 INFO i.a.c.i.LineGobbler(voidCall):82 - airbyte/destination-oracle:0.1.16 was found locally. 2022-07-08 05:11:06 INFO i.a.w.p.DockerProcessFactory(create):108 - Creating docker job ID: 222 2022-07-08 05:11:06 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/222/1 --log-driver none --name destination-oracle-check-222-1-sdqml --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=false -e WORKER_ENVIRONMENT=DOCKER -e AIRBYTE_ROLE= -e WORKER_JOB_ATTEMPT=1 -e WORKER_CONNECTOR_IMAGE=airbyte/destination-oracle:0.1.16 -e AIRBYTE_VERSION=0.39.35-alpha -e WORKER_JOB_ID=222 airbyte/destination-oracle:0.1.16 check --config source_config.json 2022-07-08 05:11:08 ERROR i.a.c.i.LineGobbler(voidCall):82 - SLF4J: Class path contains multiple SLF4J bindings. 2022-07-08 05:11:08 ERROR i.a.c.i.LineGobbler(voidCall):82 - SLF4J: Found binding in [jar:file:/airbyte/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-07-08 05:11:08 ERROR i.a.c.i.LineGobbler(voidCall):82 - SLF4J: Found binding in [jar:file:/airbyte/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-07-08 05:11:08 ERROR i.a.c.i.LineGobbler(voidCall):82 - SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. 2022-07-08 05:11:08 ERROR i.a.c.i.LineGobbler(voidCall):82 - SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]