2022-04-06 16:23:30 INFO i.a.w.w.WorkerRun(call):49 - Executing worker wrapper. Airbyte version: 0.35.65-alpha 2022-04-06 16:23:30 INFO i.a.w.t.TemporalAttemptExecution(get):105 - Docker volume job log path: /tmp/workspace/19/0/logs.log 2022-04-06 16:23:30 INFO i.a.w.t.TemporalAttemptExecution(get):110 - Executing worker wrapper. Airbyte version: 0.35.65-alpha 2022-04-06 16:23:30 INFO i.a.w.DefaultReplicationWorker(run):104 - start sync worker. job id: 19 attempt id: 0 2022-04-06 16:23:30 INFO i.a.w.DefaultReplicationWorker(run):116 - configured sync modes: {null.company=full_refresh - append, null.estimates=full_refresh - append, null.expenses=full_refresh - append, null.expenses_clients=full_refresh - append, null.expenses_team=full_refresh - append, null.invoice_messages=full_refresh - append, null.project_budget=full_refresh - append, null.time_tasks=full_refresh - append, null.invoice_item_categories=full_refresh - append, null.time_team=full_refresh - append, null.clients=full_refresh - append, null.time_clients=full_refresh - append, null.invoices=full_refresh - append, null.tasks=full_refresh - append, null.expense_categories=full_refresh - append, null.estimate_messages=full_refresh - append, null.expenses_projects=full_refresh - append, null.invoice_payments=full_refresh - append, null.task_assignments=full_refresh - append, null.uninvoiced=full_refresh - append, null.project_assignments=full_refresh - append, null.estimate_item_categories=full_refresh - append, null.user_assignments=full_refresh - append, null.contacts=full_refresh - append, null.projects=full_refresh - append, null.roles=full_refresh - append, null.expenses_categories=full_refresh - append, null.cost_rates=full_refresh - append, null.users=full_refresh - append, null.billable_rates=full_refresh - append, null.time_entries=full_refresh - append, null.time_projects=full_refresh - append} 2022-04-06 16:23:30 INFO i.a.w.p.a.DefaultAirbyteDestination(start):69 - Running destination... 2022-04-06 16:23:30 INFO i.a.c.i.LineGobbler(voidCall):82 - Checking if airbyte/destination-mysql:0.1.18 exists... 2022-04-06 16:23:30 INFO i.a.c.i.LineGobbler(voidCall):82 - airbyte/destination-mysql:0.1.18 was found locally. 2022-04-06 16:23:30 INFO i.a.w.p.DockerProcessFactory(create):106 - Creating docker job ID: 19 2022-04-06 16:23:30 INFO i.a.w.p.DockerProcessFactory(create):158 - Preparing command: docker run --rm --init -i -w /data/19/0 --log-driver none --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e WORKER_CONNECTOR_IMAGE=airbyte/destination-mysql:0.1.18 -e WORKER_JOB_ATTEMPT=0 -e WORKER_ENVIRONMENT=DOCKER -e AIRBYTE_ROLE= -e AIRBYTE_VERSION=0.35.65-alpha -e WORKER_JOB_ID=19 airbyte/destination-mysql:0.1.18 write --config destination_config.json --catalog destination_catalog.json 2022-04-06 16:23:30 INFO i.a.c.i.LineGobbler(voidCall):82 - Checking if airbyte/source-harvest:0.1.8 exists... 2022-04-06 16:23:31 INFO i.a.c.i.LineGobbler(voidCall):82 - airbyte/source-harvest:0.1.8 was found locally. 2022-04-06 16:23:31 INFO i.a.w.p.DockerProcessFactory(create):106 - Creating docker job ID: 19 2022-04-06 16:23:31 INFO i.a.w.p.DockerProcessFactory(create):158 - Preparing command: docker run --rm --init -i -w /data/19/0 --log-driver none --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e WORKER_CONNECTOR_IMAGE=airbyte/source-harvest:0.1.8 -e WORKER_JOB_ATTEMPT=0 -e WORKER_ENVIRONMENT=DOCKER -e AIRBYTE_ROLE= -e AIRBYTE_VERSION=0.35.65-alpha -e WORKER_JOB_ID=19 airbyte/source-harvest:0.1.8 read --config source_config.json --catalog source_catalog.json --state input_state.json 2022-04-06 16:23:31 INFO i.a.w.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$6):339 - Destination output thread started. 2022-04-06 16:23:31 INFO i.a.w.DefaultReplicationWorker(run):158 - Waiting for source and destination threads to complete. 2022-04-06 16:23:31 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):279 - Replication thread started. 2022-04-06 16:23:31 destination > SLF4J: Class path contains multiple SLF4J bindings. 2022-04-06 16:23:31 destination > SLF4J: Found binding in [jar:file:/airbyte/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-04-06 16:23:31 destination > SLF4J: Found binding in [jar:file:/airbyte/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-04-06 16:23:31 destination > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. 2022-04-06 16:23:31 destination > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] 2022-04-06 16:23:32 source > Starting syncing SourceHarvest 2022-04-06 16:23:32 source > Syncing stream: billable_rates 2022-04-06 16:23:33 destination > 2022-04-06 16:23:33 INFO i.a.i.d.m.MySQLDestination(main):125 - starting destination: class io.airbyte.integrations.destination.mysql.MySQLDestination 2022-04-06 16:23:33 destination > 2022-04-06 16:23:33 INFO i.a.i.b.IntegrationCliParser(parseOptions):118 - integration args: {catalog=destination_catalog.json, write=null, config=destination_config.json} 2022-04-06 16:23:33 destination > 2022-04-06 16:23:33 INFO i.a.i.b.IntegrationRunner(run):88 - Sentry transaction event: 4feae80d8c1f4bf5a9d6a12b2c7274eb 2022-04-06 16:23:33 destination > 2022-04-06 16:23:33 INFO i.a.i.b.IntegrationRunner(runInternal):106 - Running integration: io.airbyte.integrations.base.ssh.SshWrappedDestination 2022-04-06 16:23:33 destination > 2022-04-06 16:23:33 INFO i.a.i.b.IntegrationRunner(runInternal):107 - Command: WRITE 2022-04-06 16:23:33 destination > 2022-04-06 16:23:33 INFO i.a.i.b.IntegrationRunner(runInternal):108 - Integration config: IntegrationConfig{command=WRITE, configPath='destination_config.json', catalogPath='destination_catalog.json', statePath='null'} 2022-04-06 16:23:33 destination > 2022-04-06 16:23:33 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-04-06 16:23:33 destination > 2022-04-06 16:23:33 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-04-06 16:23:33 destination > 2022-04-06 16:23:33 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-04-06 16:23:33 destination > 2022-04-06 16:23:33 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-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.b.s.SshTunnel(getInstance):170 - Starting connection with method: NO_TUNNEL 2022-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):96 - Write config: WriteConfig{streamName=billable_rates, namespace=null, outputSchemaName=bstroharvest, tmpTableName=_airbyte_tmp_jmi_billable_rates, outputTableName=_airbyte_raw_billable_rates, syncMode=append} 2022-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):96 - Write config: WriteConfig{streamName=clients, namespace=null, outputSchemaName=bstroharvest, tmpTableName=_airbyte_tmp_lgo_clients, outputTableName=_airbyte_raw_clients, syncMode=append} 2022-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):96 - Write config: WriteConfig{streamName=company, namespace=null, outputSchemaName=bstroharvest, tmpTableName=_airbyte_tmp_axs_company, outputTableName=_airbyte_raw_company, syncMode=append} 2022-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):96 - Write config: WriteConfig{streamName=contacts, namespace=null, outputSchemaName=bstroharvest, tmpTableName=_airbyte_tmp_crh_contacts, outputTableName=_airbyte_raw_contacts, syncMode=append} 2022-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):96 - Write config: WriteConfig{streamName=cost_rates, namespace=null, outputSchemaName=bstroharvest, tmpTableName=_airbyte_tmp_fxn_cost_rates, outputTableName=_airbyte_raw_cost_rates, syncMode=append} 2022-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):96 - Write config: WriteConfig{streamName=estimate_item_categories, namespace=null, outputSchemaName=bstroharvest, tmpTableName=_airbyte_tmp_wfo_estimate_item_categories, outputTableName=_airbyte_raw_estimate_item_categories, syncMode=append} 2022-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):96 - Write config: WriteConfig{streamName=estimate_messages, namespace=null, outputSchemaName=bstroharvest, tmpTableName=_airbyte_tmp_whb_estimate_messages, outputTableName=_airbyte_raw_estimate_messages, syncMode=append} 2022-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):96 - Write config: WriteConfig{streamName=estimates, namespace=null, outputSchemaName=bstroharvest, tmpTableName=_airbyte_tmp_iad_estimates, outputTableName=_airbyte_raw_estimates, syncMode=append} 2022-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):96 - Write config: WriteConfig{streamName=expense_categories, namespace=null, outputSchemaName=bstroharvest, tmpTableName=_airbyte_tmp_wno_expense_categories, outputTableName=_airbyte_raw_expense_categories, syncMode=append} 2022-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):96 - Write config: WriteConfig{streamName=expenses, namespace=null, outputSchemaName=bstroharvest, tmpTableName=_airbyte_tmp_mxu_expenses, outputTableName=_airbyte_raw_expenses, syncMode=append} 2022-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):96 - Write config: WriteConfig{streamName=expenses_categories, namespace=null, outputSchemaName=bstroharvest, tmpTableName=_airbyte_tmp_lpj_expenses_categories, outputTableName=_airbyte_raw_expenses_categories, syncMode=append} 2022-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):96 - Write config: WriteConfig{streamName=expenses_clients, namespace=null, outputSchemaName=bstroharvest, tmpTableName=_airbyte_tmp_shg_expenses_clients, outputTableName=_airbyte_raw_expenses_clients, syncMode=append} 2022-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):96 - Write config: WriteConfig{streamName=expenses_projects, namespace=null, outputSchemaName=bstroharvest, tmpTableName=_airbyte_tmp_fwt_expenses_projects, outputTableName=_airbyte_raw_expenses_projects, syncMode=append} 2022-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):96 - Write config: WriteConfig{streamName=expenses_team, namespace=null, outputSchemaName=bstroharvest, tmpTableName=_airbyte_tmp_jsp_expenses_team, outputTableName=_airbyte_raw_expenses_team, syncMode=append} 2022-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):96 - Write config: WriteConfig{streamName=invoice_item_categories, namespace=null, outputSchemaName=bstroharvest, tmpTableName=_airbyte_tmp_ken_invoice_item_categories, outputTableName=_airbyte_raw_invoice_item_categories, syncMode=append} 2022-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):96 - Write config: WriteConfig{streamName=invoice_messages, namespace=null, outputSchemaName=bstroharvest, tmpTableName=_airbyte_tmp_szl_invoice_messages, outputTableName=_airbyte_raw_invoice_messages, syncMode=append} 2022-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):96 - Write config: WriteConfig{streamName=invoice_payments, namespace=null, outputSchemaName=bstroharvest, tmpTableName=_airbyte_tmp_snm_invoice_payments, outputTableName=_airbyte_raw_invoice_payments, syncMode=append} 2022-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):96 - Write config: WriteConfig{streamName=invoices, namespace=null, outputSchemaName=bstroharvest, tmpTableName=_airbyte_tmp_ijs_invoices, outputTableName=_airbyte_raw_invoices, syncMode=append} 2022-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):96 - Write config: WriteConfig{streamName=project_assignments, namespace=null, outputSchemaName=bstroharvest, tmpTableName=_airbyte_tmp_zju_project_assignments, outputTableName=_airbyte_raw_project_assignments, syncMode=append} 2022-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):96 - Write config: WriteConfig{streamName=project_budget, namespace=null, outputSchemaName=bstroharvest, tmpTableName=_airbyte_tmp_aef_project_budget, outputTableName=_airbyte_raw_project_budget, syncMode=append} 2022-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):96 - Write config: WriteConfig{streamName=projects, namespace=null, outputSchemaName=bstroharvest, tmpTableName=_airbyte_tmp_vve_projects, outputTableName=_airbyte_raw_projects, syncMode=append} 2022-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):96 - Write config: WriteConfig{streamName=roles, namespace=null, outputSchemaName=bstroharvest, tmpTableName=_airbyte_tmp_jdm_roles, outputTableName=_airbyte_raw_roles, syncMode=append} 2022-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):96 - Write config: WriteConfig{streamName=task_assignments, namespace=null, outputSchemaName=bstroharvest, tmpTableName=_airbyte_tmp_fgz_task_assignments, outputTableName=_airbyte_raw_task_assignments, syncMode=append} 2022-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):96 - Write config: WriteConfig{streamName=tasks, namespace=null, outputSchemaName=bstroharvest, tmpTableName=_airbyte_tmp_jdi_tasks, outputTableName=_airbyte_raw_tasks, syncMode=append} 2022-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):96 - Write config: WriteConfig{streamName=time_clients, namespace=null, outputSchemaName=bstroharvest, tmpTableName=_airbyte_tmp_dxy_time_clients, outputTableName=_airbyte_raw_time_clients, syncMode=append} 2022-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):96 - Write config: WriteConfig{streamName=time_entries, namespace=null, outputSchemaName=bstroharvest, tmpTableName=_airbyte_tmp_kmz_time_entries, outputTableName=_airbyte_raw_time_entries, syncMode=append} 2022-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):96 - Write config: WriteConfig{streamName=time_projects, namespace=null, outputSchemaName=bstroharvest, tmpTableName=_airbyte_tmp_fdb_time_projects, outputTableName=_airbyte_raw_time_projects, syncMode=append} 2022-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):96 - Write config: WriteConfig{streamName=time_tasks, namespace=null, outputSchemaName=bstroharvest, tmpTableName=_airbyte_tmp_ogl_time_tasks, outputTableName=_airbyte_raw_time_tasks, syncMode=append} 2022-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):96 - Write config: WriteConfig{streamName=time_team, namespace=null, outputSchemaName=bstroharvest, tmpTableName=_airbyte_tmp_zre_time_team, outputTableName=_airbyte_raw_time_team, syncMode=append} 2022-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):96 - Write config: WriteConfig{streamName=uninvoiced, namespace=null, outputSchemaName=bstroharvest, tmpTableName=_airbyte_tmp_ffr_uninvoiced, outputTableName=_airbyte_raw_uninvoiced, syncMode=append} 2022-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):96 - Write config: WriteConfig{streamName=user_assignments, namespace=null, outputSchemaName=bstroharvest, tmpTableName=_airbyte_tmp_vcl_user_assignments, outputTableName=_airbyte_raw_user_assignments, syncMode=append} 2022-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):96 - Write config: WriteConfig{streamName=users, namespace=null, outputSchemaName=bstroharvest, tmpTableName=_airbyte_tmp_yep_users, outputTableName=_airbyte_raw_users, syncMode=append} 2022-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.d.b.BufferedStreamConsumer(startTracked):141 - class io.airbyte.integrations.destination.buffered_stream_consumer.BufferedStreamConsumer started. 2022-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):121 - Preparing tmp tables in destination started for 32 streams 2022-04-06 16:23:34 destination > 2022-04-06 16:23:34 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):125 - Preparing tmp table in destination started for stream billable_rates. schema: bstroharvest, tmp table name: _airbyte_tmp_jmi_billable_rates 2022-04-06 16:23:35 source > Read 1 records from billable_rates stream 2022-04-06 16:23:35 source > Finished syncing SourceHarvest 2022-04-06 16:23:35 source > SourceHarvest runtimes: 2022-04-06 16:23:35 source > Syncing stream: clients 2022-04-06 16:23:36 source > Read 49 records from clients stream 2022-04-06 16:23:36 source > Finished syncing SourceHarvest 2022-04-06 16:23:36 source > SourceHarvest runtimes: 2022-04-06 16:23:36 source > Syncing stream: company 2022-04-06 16:23:36 source > Read 1 records from company stream 2022-04-06 16:23:36 source > Finished syncing SourceHarvest 2022-04-06 16:23:36 source > SourceHarvest runtimes: 2022-04-06 16:23:36 source > Syncing stream: contacts 2022-04-06 16:23:36 source > Read 0 records from contacts stream 2022-04-06 16:23:36 source > Finished syncing SourceHarvest 2022-04-06 16:23:36 source > SourceHarvest runtimes: 2022-04-06 16:23:36 source > Syncing stream: cost_rates 2022-04-06 16:23:36 destination > 2022-04-06 16:23:36 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):125 - Preparing tmp table in destination started for stream clients. schema: bstroharvest, tmp table name: _airbyte_tmp_lgo_clients 2022-04-06 16:23:36 destination > 2022-04-06 16:23:36 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):125 - Preparing tmp table in destination started for stream company. schema: bstroharvest, tmp table name: _airbyte_tmp_axs_company 2022-04-06 16:23:36 destination > 2022-04-06 16:23:36 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):125 - Preparing tmp table in destination started for stream contacts. schema: bstroharvest, tmp table name: _airbyte_tmp_crh_contacts 2022-04-06 16:23:37 destination > 2022-04-06 16:23:37 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):125 - Preparing tmp table in destination started for stream cost_rates. schema: bstroharvest, tmp table name: _airbyte_tmp_fxn_cost_rates 2022-04-06 16:23:37 destination > 2022-04-06 16:23:37 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):125 - Preparing tmp table in destination started for stream estimate_item_categories. schema: bstroharvest, tmp table name: _airbyte_tmp_wfo_estimate_item_categories 2022-04-06 16:23:37 destination > 2022-04-06 16:23:37 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):125 - Preparing tmp table in destination started for stream estimate_messages. schema: bstroharvest, tmp table name: _airbyte_tmp_whb_estimate_messages 2022-04-06 16:23:38 destination > 2022-04-06 16:23:38 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):125 - Preparing tmp table in destination started for stream estimates. schema: bstroharvest, tmp table name: _airbyte_tmp_iad_estimates 2022-04-06 16:23:38 destination > 2022-04-06 16:23:38 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):125 - Preparing tmp table in destination started for stream expense_categories. schema: bstroharvest, tmp table name: _airbyte_tmp_wno_expense_categories 2022-04-06 16:23:38 destination > 2022-04-06 16:23:38 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):125 - Preparing tmp table in destination started for stream expenses. schema: bstroharvest, tmp table name: _airbyte_tmp_mxu_expenses 2022-04-06 16:23:39 destination > 2022-04-06 16:23:39 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):125 - Preparing tmp table in destination started for stream expenses_categories. schema: bstroharvest, tmp table name: _airbyte_tmp_lpj_expenses_categories 2022-04-06 16:23:39 destination > 2022-04-06 16:23:39 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):125 - Preparing tmp table in destination started for stream expenses_clients. schema: bstroharvest, tmp table name: _airbyte_tmp_shg_expenses_clients 2022-04-06 16:23:39 destination > 2022-04-06 16:23:39 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):125 - Preparing tmp table in destination started for stream expenses_projects. schema: bstroharvest, tmp table name: _airbyte_tmp_fwt_expenses_projects 2022-04-06 16:23:39 destination > 2022-04-06 16:23:39 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):125 - Preparing tmp table in destination started for stream expenses_team. schema: bstroharvest, tmp table name: _airbyte_tmp_jsp_expenses_team 2022-04-06 16:23:40 destination > 2022-04-06 16:23:40 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):125 - Preparing tmp table in destination started for stream invoice_item_categories. schema: bstroharvest, tmp table name: _airbyte_tmp_ken_invoice_item_categories 2022-04-06 16:23:40 source > Read 1 records from cost_rates stream 2022-04-06 16:23:40 source > Finished syncing SourceHarvest 2022-04-06 16:23:40 source > SourceHarvest runtimes: 2022-04-06 16:23:40 source > Syncing stream: estimate_item_categories 2022-04-06 16:23:40 source > Encountered an exception while reading stream SourceHarvest Traceback (most recent call last): File "/usr/local/lib/python3.7/site-packages/airbyte_cdk/sources/abstract_source.py", line 108, in read internal_config=internal_config, File "/usr/local/lib/python3.7/site-packages/airbyte_cdk/sources/abstract_source.py", line 141, in _read_stream for record in record_iterator: File "/usr/local/lib/python3.7/site-packages/airbyte_cdk/sources/abstract_source.py", line 213, in _read_full_refresh for record in records: File "/usr/local/lib/python3.7/site-packages/airbyte_cdk/sources/streams/http/http.py", line 352, in read_records response = self._send_request(request, request_kwargs) File "/usr/local/lib/python3.7/site-packages/airbyte_cdk/sources/streams/http/http.py", line 319, in _send_request return backoff_handler(user_backoff_handler)(request, request_kwargs) File "/usr/local/lib/python3.7/site-packages/backoff/_sync.py", line 94, in retry ret = target(*args, **kwargs) File "/usr/local/lib/python3.7/site-packages/backoff/_sync.py", line 94, in retry ret = target(*args, **kwargs) File "/usr/local/lib/python3.7/site-packages/airbyte_cdk/sources/streams/http/http.py", line 285, in _send response.raise_for_status() File "/usr/local/lib/python3.7/site-packages/requests/models.py", line 953, in raise_for_status raise HTTPError(http_error_msg, response=self) requests.exceptions.HTTPError: 403 Client Error: Forbidden for url: https://api.harvestapp.com/v2/estimate_item_categories?per_page=50&updated_since=2017-01-25T00%3A00%3A00%2B00%3A00 2022-04-06 16:23:40 source > Finished syncing SourceHarvest 2022-04-06 16:23:40 source > SourceHarvest runtimes: 2022-04-06 16:23:40 source > 403 Client Error: Forbidden for url: https://api.harvestapp.com/v2/estimate_item_categories?per_page=50&updated_since=2017-01-25T00%3A00%3A00%2B00%3A00 Traceback (most recent call last): File "/airbyte/integration_code/main.py", line 13, in launch(source, sys.argv[1:]) File "/usr/local/lib/python3.7/site-packages/airbyte_cdk/entrypoint.py", line 116, in launch for message in source_entrypoint.run(parsed_args): File "/usr/local/lib/python3.7/site-packages/airbyte_cdk/entrypoint.py", line 107, in run for message in generator: File "/usr/local/lib/python3.7/site-packages/airbyte_cdk/sources/abstract_source.py", line 112, in read raise e File "/usr/local/lib/python3.7/site-packages/airbyte_cdk/sources/abstract_source.py", line 108, in read internal_config=internal_config, File "/usr/local/lib/python3.7/site-packages/airbyte_cdk/sources/abstract_source.py", line 141, in _read_stream for record in record_iterator: File "/usr/local/lib/python3.7/site-packages/airbyte_cdk/sources/abstract_source.py", line 213, in _read_full_refresh for record in records: File "/usr/local/lib/python3.7/site-packages/airbyte_cdk/sources/streams/http/http.py", line 352, in read_records response = self._send_request(request, request_kwargs) File "/usr/local/lib/python3.7/site-packages/airbyte_cdk/sources/streams/http/http.py", line 319, in _send_request return backoff_handler(user_backoff_handler)(request, request_kwargs) File "/usr/local/lib/python3.7/site-packages/backoff/_sync.py", line 94, in retry ret = target(*args, **kwargs) File "/usr/local/lib/python3.7/site-packages/backoff/_sync.py", line 94, in retry ret = target(*args, **kwargs) File "/usr/local/lib/python3.7/site-packages/airbyte_cdk/sources/streams/http/http.py", line 285, in _send response.raise_for_status() File "/usr/local/lib/python3.7/site-packages/requests/models.py", line 953, in raise_for_status raise HTTPError(http_error_msg, response=self) requests.exceptions.HTTPError: 403 Client Error: Forbidden for url: https://api.harvestapp.com/v2/estimate_item_categories?per_page=50&updated_since=2017-01-25T00%3A00%3A00%2B00%3A00 2022-04-06 16:23:40 destination > 2022-04-06 16:23:40 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):125 - Preparing tmp table in destination started for stream invoice_messages. schema: bstroharvest, tmp table name: _airbyte_tmp_szl_invoice_messages 2022-04-06 16:23:40 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):305 - Total records read: 52 (10 KB) 2022-04-06 16:23:40 destination > 2022-04-06 16:23:40 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):125 - Preparing tmp table in destination started for stream invoice_payments. schema: bstroharvest, tmp table name: _airbyte_tmp_snm_invoice_payments 2022-04-06 16:23:41 destination > 2022-04-06 16:23:41 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):125 - Preparing tmp table in destination started for stream invoices. schema: bstroharvest, tmp table name: _airbyte_tmp_ijs_invoices 2022-04-06 16:23:41 destination > 2022-04-06 16:23:41 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):125 - Preparing tmp table in destination started for stream project_assignments. schema: bstroharvest, tmp table name: _airbyte_tmp_zju_project_assignments 2022-04-06 16:23:41 destination > 2022-04-06 16:23:41 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):125 - Preparing tmp table in destination started for stream project_budget. schema: bstroharvest, tmp table name: _airbyte_tmp_aef_project_budget 2022-04-06 16:23:42 destination > 2022-04-06 16:23:42 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):125 - Preparing tmp table in destination started for stream projects. schema: bstroharvest, tmp table name: _airbyte_tmp_vve_projects 2022-04-06 16:23:42 destination > 2022-04-06 16:23:42 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):125 - Preparing tmp table in destination started for stream roles. schema: bstroharvest, tmp table name: _airbyte_tmp_jdm_roles 2022-04-06 16:23:42 destination > 2022-04-06 16:23:42 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):125 - Preparing tmp table in destination started for stream task_assignments. schema: bstroharvest, tmp table name: _airbyte_tmp_fgz_task_assignments 2022-04-06 16:23:43 destination > 2022-04-06 16:23:43 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):125 - Preparing tmp table in destination started for stream tasks. schema: bstroharvest, tmp table name: _airbyte_tmp_jdi_tasks 2022-04-06 16:23:43 destination > 2022-04-06 16:23:43 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):125 - Preparing tmp table in destination started for stream time_clients. schema: bstroharvest, tmp table name: _airbyte_tmp_dxy_time_clients 2022-04-06 16:23:43 destination > 2022-04-06 16:23:43 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):125 - Preparing tmp table in destination started for stream time_entries. schema: bstroharvest, tmp table name: _airbyte_tmp_kmz_time_entries 2022-04-06 16:23:43 destination > 2022-04-06 16:23:43 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):125 - Preparing tmp table in destination started for stream time_projects. schema: bstroharvest, tmp table name: _airbyte_tmp_fdb_time_projects 2022-04-06 16:23:44 destination > 2022-04-06 16:23:44 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):125 - Preparing tmp table in destination started for stream time_tasks. schema: bstroharvest, tmp table name: _airbyte_tmp_ogl_time_tasks 2022-04-06 16:23:44 destination > 2022-04-06 16:23:44 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):125 - Preparing tmp table in destination started for stream time_team. schema: bstroharvest, tmp table name: _airbyte_tmp_zre_time_team 2022-04-06 16:23:44 destination > 2022-04-06 16:23:44 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):125 - Preparing tmp table in destination started for stream uninvoiced. schema: bstroharvest, tmp table name: _airbyte_tmp_ffr_uninvoiced 2022-04-06 16:23:45 destination > 2022-04-06 16:23:45 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):125 - Preparing tmp table in destination started for stream user_assignments. schema: bstroharvest, tmp table name: _airbyte_tmp_vcl_user_assignments 2022-04-06 16:23:45 destination > 2022-04-06 16:23:45 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):125 - Preparing tmp table in destination started for stream users. schema: bstroharvest, tmp table name: _airbyte_tmp_yep_users 2022-04-06 16:23:45 destination > 2022-04-06 16:23:45 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):131 - Preparing tables in destination completed. 2022-04-06 16:23:45 destination > 2022-04-06 16:23:45 INFO i.a.i.b.FailureTrackingAirbyteMessageConsumer(close):65 - Airbyte message consumer: succeeded. 2022-04-06 16:23:45 destination > 2022-04-06 16:23:45 INFO i.a.i.d.b.BufferedStreamConsumer(close):217 - executing on success close procedure. 2022-04-06 16:23:45 destination > 2022-04-06 16:23:45 INFO i.a.i.d.b.BufferedStreamConsumer(flushQueueToDestination):181 - Flushing buffer: 44959 bytes 2022-04-06 16:23:45 destination > 2022-04-06 16:23:45 INFO i.a.i.d.b.BufferedStreamConsumer(lambda$flushQueueToDestination$1):185 - Flushing billable_rates: 1 records 2022-04-06 16:23:46 destination > 2022-04-06 16:23:46 INFO i.a.i.d.b.BufferedStreamConsumer(lambda$flushQueueToDestination$1):185 - Flushing company: 1 records 2022-04-06 16:23:47 destination > 2022-04-06 16:23:47 INFO i.a.i.d.b.BufferedStreamConsumer(lambda$flushQueueToDestination$1):185 - Flushing cost_rates: 1 records 2022-04-06 16:23:47 destination > 2022-04-06 16:23:47 INFO i.a.i.d.b.BufferedStreamConsumer(lambda$flushQueueToDestination$1):185 - Flushing clients: 49 records 2022-04-06 16:23:47 destination > 2022-04-06 16:23:47 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):160 - Finalizing tables in destination started for 32 streams 2022-04-06 16:23:47 destination > 2022-04-06 16:23:47 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):165 - Finalizing stream billable_rates. schema bstroharvest, tmp table _airbyte_tmp_jmi_billable_rates, final table _airbyte_raw_billable_rates 2022-04-06 16:23:47 destination > 2022-04-06 16:23:47 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):165 - Finalizing stream clients. schema bstroharvest, tmp table _airbyte_tmp_lgo_clients, final table _airbyte_raw_clients 2022-04-06 16:23:47 destination > 2022-04-06 16:23:47 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):165 - Finalizing stream company. schema bstroharvest, tmp table _airbyte_tmp_axs_company, final table _airbyte_raw_company 2022-04-06 16:23:48 destination > 2022-04-06 16:23:48 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):165 - Finalizing stream contacts. schema bstroharvest, tmp table _airbyte_tmp_crh_contacts, final table _airbyte_raw_contacts 2022-04-06 16:23:48 destination > 2022-04-06 16:23:48 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):165 - Finalizing stream cost_rates. schema bstroharvest, tmp table _airbyte_tmp_fxn_cost_rates, final table _airbyte_raw_cost_rates 2022-04-06 16:23:48 destination > 2022-04-06 16:23:48 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):165 - Finalizing stream estimate_item_categories. schema bstroharvest, tmp table _airbyte_tmp_wfo_estimate_item_categories, final table _airbyte_raw_estimate_item_categories 2022-04-06 16:23:48 destination > 2022-04-06 16:23:48 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):165 - Finalizing stream estimate_messages. schema bstroharvest, tmp table _airbyte_tmp_whb_estimate_messages, final table _airbyte_raw_estimate_messages 2022-04-06 16:23:48 destination > 2022-04-06 16:23:48 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):165 - Finalizing stream estimates. schema bstroharvest, tmp table _airbyte_tmp_iad_estimates, final table _airbyte_raw_estimates 2022-04-06 16:23:48 destination > 2022-04-06 16:23:48 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):165 - Finalizing stream expense_categories. schema bstroharvest, tmp table _airbyte_tmp_wno_expense_categories, final table _airbyte_raw_expense_categories 2022-04-06 16:23:48 destination > 2022-04-06 16:23:48 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):165 - Finalizing stream expenses. schema bstroharvest, tmp table _airbyte_tmp_mxu_expenses, final table _airbyte_raw_expenses 2022-04-06 16:23:49 destination > 2022-04-06 16:23:49 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):165 - Finalizing stream expenses_categories. schema bstroharvest, tmp table _airbyte_tmp_lpj_expenses_categories, final table _airbyte_raw_expenses_categories 2022-04-06 16:23:49 destination > 2022-04-06 16:23:49 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):165 - Finalizing stream expenses_clients. schema bstroharvest, tmp table _airbyte_tmp_shg_expenses_clients, final table _airbyte_raw_expenses_clients 2022-04-06 16:23:49 destination > 2022-04-06 16:23:49 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):165 - Finalizing stream expenses_projects. schema bstroharvest, tmp table _airbyte_tmp_fwt_expenses_projects, final table _airbyte_raw_expenses_projects 2022-04-06 16:23:49 destination > 2022-04-06 16:23:49 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):165 - Finalizing stream expenses_team. schema bstroharvest, tmp table _airbyte_tmp_jsp_expenses_team, final table _airbyte_raw_expenses_team 2022-04-06 16:23:49 destination > 2022-04-06 16:23:49 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):165 - Finalizing stream invoice_item_categories. schema bstroharvest, tmp table _airbyte_tmp_ken_invoice_item_categories, final table _airbyte_raw_invoice_item_categories 2022-04-06 16:23:49 destination > 2022-04-06 16:23:49 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):165 - Finalizing stream invoice_messages. schema bstroharvest, tmp table _airbyte_tmp_szl_invoice_messages, final table _airbyte_raw_invoice_messages 2022-04-06 16:23:50 destination > 2022-04-06 16:23:50 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):165 - Finalizing stream invoice_payments. schema bstroharvest, tmp table _airbyte_tmp_snm_invoice_payments, final table _airbyte_raw_invoice_payments 2022-04-06 16:23:50 destination > 2022-04-06 16:23:50 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):165 - Finalizing stream invoices. schema bstroharvest, tmp table _airbyte_tmp_ijs_invoices, final table _airbyte_raw_invoices 2022-04-06 16:23:50 destination > 2022-04-06 16:23:50 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):165 - Finalizing stream project_assignments. schema bstroharvest, tmp table _airbyte_tmp_zju_project_assignments, final table _airbyte_raw_project_assignments 2022-04-06 16:23:50 destination > 2022-04-06 16:23:50 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):165 - Finalizing stream project_budget. schema bstroharvest, tmp table _airbyte_tmp_aef_project_budget, final table _airbyte_raw_project_budget 2022-04-06 16:23:50 destination > 2022-04-06 16:23:50 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):165 - Finalizing stream projects. schema bstroharvest, tmp table _airbyte_tmp_vve_projects, final table _airbyte_raw_projects 2022-04-06 16:23:50 destination > 2022-04-06 16:23:50 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):165 - Finalizing stream roles. schema bstroharvest, tmp table _airbyte_tmp_jdm_roles, final table _airbyte_raw_roles 2022-04-06 16:23:50 destination > 2022-04-06 16:23:50 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):165 - Finalizing stream task_assignments. schema bstroharvest, tmp table _airbyte_tmp_fgz_task_assignments, final table _airbyte_raw_task_assignments 2022-04-06 16:23:51 destination > 2022-04-06 16:23:51 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):165 - Finalizing stream tasks. schema bstroharvest, tmp table _airbyte_tmp_jdi_tasks, final table _airbyte_raw_tasks 2022-04-06 16:23:51 destination > 2022-04-06 16:23:51 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):165 - Finalizing stream time_clients. schema bstroharvest, tmp table _airbyte_tmp_dxy_time_clients, final table _airbyte_raw_time_clients 2022-04-06 16:23:51 destination > 2022-04-06 16:23:51 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):165 - Finalizing stream time_entries. schema bstroharvest, tmp table _airbyte_tmp_kmz_time_entries, final table _airbyte_raw_time_entries 2022-04-06 16:23:51 destination > 2022-04-06 16:23:51 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):165 - Finalizing stream time_projects. schema bstroharvest, tmp table _airbyte_tmp_fdb_time_projects, final table _airbyte_raw_time_projects 2022-04-06 16:23:51 destination > 2022-04-06 16:23:51 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):165 - Finalizing stream time_tasks. schema bstroharvest, tmp table _airbyte_tmp_ogl_time_tasks, final table _airbyte_raw_time_tasks 2022-04-06 16:23:51 destination > 2022-04-06 16:23:51 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):165 - Finalizing stream time_team. schema bstroharvest, tmp table _airbyte_tmp_zre_time_team, final table _airbyte_raw_time_team 2022-04-06 16:23:52 destination > 2022-04-06 16:23:52 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):165 - Finalizing stream uninvoiced. schema bstroharvest, tmp table _airbyte_tmp_ffr_uninvoiced, final table _airbyte_raw_uninvoiced 2022-04-06 16:23:52 destination > 2022-04-06 16:23:52 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):165 - Finalizing stream user_assignments. schema bstroharvest, tmp table _airbyte_tmp_vcl_user_assignments, final table _airbyte_raw_user_assignments 2022-04-06 16:23:52 destination > 2022-04-06 16:23:52 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):165 - Finalizing stream users. schema bstroharvest, tmp table _airbyte_tmp_yep_users, final table _airbyte_raw_users 2022-04-06 16:23:52 destination > 2022-04-06 16:23:52 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):178 - Executing finalization of tables. 2022-04-06 16:23:55 destination > 2022-04-06 16:23:55 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):180 - Finalizing tables in destination completed. 2022-04-06 16:23:55 destination > 2022-04-06 16:23:55 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):183 - Cleaning tmp tables in destination started for 32 streams 2022-04-06 16:23:55 destination > 2022-04-06 16:23:55 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):187 - Cleaning tmp table in destination started for stream billable_rates. schema bstroharvest, tmp table name: _airbyte_tmp_jmi_billable_rates 2022-04-06 16:23:55 destination > 2022-04-06 16:23:55 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):187 - Cleaning tmp table in destination started for stream clients. schema bstroharvest, tmp table name: _airbyte_tmp_lgo_clients 2022-04-06 16:23:55 destination > 2022-04-06 16:23:55 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):187 - Cleaning tmp table in destination started for stream company. schema bstroharvest, tmp table name: _airbyte_tmp_axs_company 2022-04-06 16:23:55 destination > 2022-04-06 16:23:55 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):187 - Cleaning tmp table in destination started for stream contacts. schema bstroharvest, tmp table name: _airbyte_tmp_crh_contacts 2022-04-06 16:23:55 destination > 2022-04-06 16:23:55 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):187 - Cleaning tmp table in destination started for stream cost_rates. schema bstroharvest, tmp table name: _airbyte_tmp_fxn_cost_rates 2022-04-06 16:23:55 destination > 2022-04-06 16:23:55 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):187 - Cleaning tmp table in destination started for stream estimate_item_categories. schema bstroharvest, tmp table name: _airbyte_tmp_wfo_estimate_item_categories 2022-04-06 16:23:56 destination > 2022-04-06 16:23:56 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):187 - Cleaning tmp table in destination started for stream estimate_messages. schema bstroharvest, tmp table name: _airbyte_tmp_whb_estimate_messages 2022-04-06 16:23:56 destination > 2022-04-06 16:23:56 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):187 - Cleaning tmp table in destination started for stream estimates. schema bstroharvest, tmp table name: _airbyte_tmp_iad_estimates 2022-04-06 16:23:56 destination > 2022-04-06 16:23:56 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):187 - Cleaning tmp table in destination started for stream expense_categories. schema bstroharvest, tmp table name: _airbyte_tmp_wno_expense_categories 2022-04-06 16:23:56 destination > 2022-04-06 16:23:56 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):187 - Cleaning tmp table in destination started for stream expenses. schema bstroharvest, tmp table name: _airbyte_tmp_mxu_expenses 2022-04-06 16:23:56 destination > 2022-04-06 16:23:56 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):187 - Cleaning tmp table in destination started for stream expenses_categories. schema bstroharvest, tmp table name: _airbyte_tmp_lpj_expenses_categories 2022-04-06 16:23:56 destination > 2022-04-06 16:23:56 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):187 - Cleaning tmp table in destination started for stream expenses_clients. schema bstroharvest, tmp table name: _airbyte_tmp_shg_expenses_clients 2022-04-06 16:23:57 destination > 2022-04-06 16:23:57 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):187 - Cleaning tmp table in destination started for stream expenses_projects. schema bstroharvest, tmp table name: _airbyte_tmp_fwt_expenses_projects 2022-04-06 16:23:57 destination > 2022-04-06 16:23:57 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):187 - Cleaning tmp table in destination started for stream expenses_team. schema bstroharvest, tmp table name: _airbyte_tmp_jsp_expenses_team 2022-04-06 16:23:57 destination > 2022-04-06 16:23:57 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):187 - Cleaning tmp table in destination started for stream invoice_item_categories. schema bstroharvest, tmp table name: _airbyte_tmp_ken_invoice_item_categories 2022-04-06 16:23:57 destination > 2022-04-06 16:23:57 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):187 - Cleaning tmp table in destination started for stream invoice_messages. schema bstroharvest, tmp table name: _airbyte_tmp_szl_invoice_messages 2022-04-06 16:23:57 destination > 2022-04-06 16:23:57 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):187 - Cleaning tmp table in destination started for stream invoice_payments. schema bstroharvest, tmp table name: _airbyte_tmp_snm_invoice_payments 2022-04-06 16:23:57 destination > 2022-04-06 16:23:57 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):187 - Cleaning tmp table in destination started for stream invoices. schema bstroharvest, tmp table name: _airbyte_tmp_ijs_invoices 2022-04-06 16:23:58 destination > 2022-04-06 16:23:58 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):187 - Cleaning tmp table in destination started for stream project_assignments. schema bstroharvest, tmp table name: _airbyte_tmp_zju_project_assignments 2022-04-06 16:23:58 destination > 2022-04-06 16:23:58 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):187 - Cleaning tmp table in destination started for stream project_budget. schema bstroharvest, tmp table name: _airbyte_tmp_aef_project_budget 2022-04-06 16:23:58 destination > 2022-04-06 16:23:58 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):187 - Cleaning tmp table in destination started for stream projects. schema bstroharvest, tmp table name: _airbyte_tmp_vve_projects 2022-04-06 16:23:58 destination > 2022-04-06 16:23:58 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):187 - Cleaning tmp table in destination started for stream roles. schema bstroharvest, tmp table name: _airbyte_tmp_jdm_roles 2022-04-06 16:23:58 destination > 2022-04-06 16:23:58 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):187 - Cleaning tmp table in destination started for stream task_assignments. schema bstroharvest, tmp table name: _airbyte_tmp_fgz_task_assignments 2022-04-06 16:23:58 destination > 2022-04-06 16:23:58 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):187 - Cleaning tmp table in destination started for stream tasks. schema bstroharvest, tmp table name: _airbyte_tmp_jdi_tasks 2022-04-06 16:23:58 destination > 2022-04-06 16:23:58 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):187 - Cleaning tmp table in destination started for stream time_clients. schema bstroharvest, tmp table name: _airbyte_tmp_dxy_time_clients 2022-04-06 16:23:59 destination > 2022-04-06 16:23:59 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):187 - Cleaning tmp table in destination started for stream time_entries. schema bstroharvest, tmp table name: _airbyte_tmp_kmz_time_entries 2022-04-06 16:23:59 destination > 2022-04-06 16:23:59 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):187 - Cleaning tmp table in destination started for stream time_projects. schema bstroharvest, tmp table name: _airbyte_tmp_fdb_time_projects 2022-04-06 16:23:59 destination > 2022-04-06 16:23:59 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):187 - Cleaning tmp table in destination started for stream time_tasks. schema bstroharvest, tmp table name: _airbyte_tmp_ogl_time_tasks 2022-04-06 16:23:59 destination > 2022-04-06 16:23:59 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):187 - Cleaning tmp table in destination started for stream time_team. schema bstroharvest, tmp table name: _airbyte_tmp_zre_time_team 2022-04-06 16:23:59 destination > 2022-04-06 16:23:59 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):187 - Cleaning tmp table in destination started for stream uninvoiced. schema bstroharvest, tmp table name: _airbyte_tmp_ffr_uninvoiced 2022-04-06 16:23:59 destination > 2022-04-06 16:23:59 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):187 - Cleaning tmp table in destination started for stream user_assignments. schema bstroharvest, tmp table name: _airbyte_tmp_vcl_user_assignments 2022-04-06 16:24:00 destination > 2022-04-06 16:24:00 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):187 - Cleaning tmp table in destination started for stream users. schema bstroharvest, tmp table name: _airbyte_tmp_yep_users 2022-04-06 16:24:00 destination > 2022-04-06 16:24:00 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):192 - Cleaning tmp tables in destination completed. 2022-04-06 16:24:00 destination > 2022-04-06 16:24:00 INFO i.a.i.b.IntegrationRunner(runInternal):154 - Completed integration: io.airbyte.integrations.base.ssh.SshWrappedDestination 2022-04-06 16:24:00 destination > 2022-04-06 16:24:00 INFO i.a.i.d.m.MySQLDestination(main):127 - completed destination: class io.airbyte.integrations.destination.mysql.MySQLDestination 2022-04-06 16:24:00 ERROR i.a.w.DefaultReplicationWorker(run):169 - Sync worker failed. java.util.concurrent.ExecutionException: io.airbyte.workers.DefaultReplicationWorker$SourceException: Source 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.DefaultReplicationWorker.run(DefaultReplicationWorker.java:162) ~[io.airbyte-airbyte-workers-0.35.65-alpha.jar:?] at io.airbyte.workers.DefaultReplicationWorker.run(DefaultReplicationWorker.java:57) ~[io.airbyte-airbyte-workers-0.35.65-alpha.jar:?] at io.airbyte.workers.temporal.TemporalAttemptExecution.lambda$getWorkerThread$2(TemporalAttemptExecution.java:155) ~[io.airbyte-airbyte-workers-0.35.65-alpha.jar:?] at java.lang.Thread.run(Thread.java:833) [?:?] Suppressed: io.airbyte.workers.WorkerException: Source process exit with code 1. This warning is normal if the job was cancelled. at io.airbyte.workers.protocols.airbyte.DefaultAirbyteSource.close(DefaultAirbyteSource.java:136) ~[io.airbyte-airbyte-workers-0.35.65-alpha.jar:?] at io.airbyte.workers.DefaultReplicationWorker.run(DefaultReplicationWorker.java:126) ~[io.airbyte-airbyte-workers-0.35.65-alpha.jar:?] at io.airbyte.workers.DefaultReplicationWorker.run(DefaultReplicationWorker.java:57) ~[io.airbyte-airbyte-workers-0.35.65-alpha.jar:?] at io.airbyte.workers.temporal.TemporalAttemptExecution.lambda$getWorkerThread$2(TemporalAttemptExecution.java:155) ~[io.airbyte-airbyte-workers-0.35.65-alpha.jar:?] at java.lang.Thread.run(Thread.java:833) [?:?] Caused by: io.airbyte.workers.DefaultReplicationWorker$SourceException: Source process exited with non-zero exit code 1 at io.airbyte.workers.DefaultReplicationWorker.lambda$getReplicationRunnable$5(DefaultReplicationWorker.java:312) ~[io.airbyte-airbyte-workers-0.35.65-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-04-06 16:24:00 INFO i.a.w.DefaultReplicationWorker(run):228 - sync summary: io.airbyte.config.ReplicationAttemptSummary@69d6de74[status=failed,recordsSynced=52,bytesSynced=11166,startTime=1649262210772,endTime=1649262240310,totalStats=io.airbyte.config.SyncStats@50cb2c9b[recordsEmitted=52,bytesEmitted=11166,stateMessagesEmitted=0,recordsCommitted=0],streamStats=[io.airbyte.config.StreamSyncStats@4c64e8ee[streamName=clients,stats=io.airbyte.config.SyncStats@74d9578c[recordsEmitted=49,bytesEmitted=10425,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@2ba3121d[streamName=billable_rates,stats=io.airbyte.config.SyncStats@22055c06[recordsEmitted=1,bytesEmitted=133,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@494df330[streamName=company,stats=io.airbyte.config.SyncStats@7716b8a2[recordsEmitted=1,bytesEmitted=475,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@44966fa7[streamName=cost_rates,stats=io.airbyte.config.SyncStats@4cfbee5f[recordsEmitted=1,bytesEmitted=133,stateMessagesEmitted=,recordsCommitted=]]]] 2022-04-06 16:24:00 INFO i.a.w.DefaultReplicationWorker(run):250 - Source did not output any state messages 2022-04-06 16:24:00 WARN i.a.w.DefaultReplicationWorker(run):258 - State capture: No new state, falling back on input state: io.airbyte.config.State@6a895083[state={}] 2022-04-06 16:24:00 INFO i.a.w.t.TemporalAttemptExecution(get):131 - Stopping cancellation check scheduling... 2022-04-06 16:24:00 INFO i.a.w.t.s.ReplicationActivityImpl(lambda$replicate$1):147 - sync summary: io.airbyte.config.StandardSyncOutput@7bb8cc5a[standardSyncSummary=io.airbyte.config.StandardSyncSummary@3bcc85ac[status=failed,recordsSynced=52,bytesSynced=11166,startTime=1649262210772,endTime=1649262240310,totalStats=io.airbyte.config.SyncStats@50cb2c9b[recordsEmitted=52,bytesEmitted=11166,stateMessagesEmitted=0,recordsCommitted=0],streamStats=[io.airbyte.config.StreamSyncStats@4c64e8ee[streamName=clients,stats=io.airbyte.config.SyncStats@74d9578c[recordsEmitted=49,bytesEmitted=10425,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@2ba3121d[streamName=billable_rates,stats=io.airbyte.config.SyncStats@22055c06[recordsEmitted=1,bytesEmitted=133,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@494df330[streamName=company,stats=io.airbyte.config.SyncStats@7716b8a2[recordsEmitted=1,bytesEmitted=475,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@44966fa7[streamName=cost_rates,stats=io.airbyte.config.SyncStats@4cfbee5f[recordsEmitted=1,bytesEmitted=133,stateMessagesEmitted=,recordsCommitted=]]]],state=io.airbyte.config.State@6a895083[state={}],outputCatalog=io.airbyte.protocol.models.ConfiguredAirbyteCatalog@22fd7768[streams=[io.airbyte.protocol.models.ConfiguredAirbyteStream@5d5b9f62[stream=io.airbyte.protocol.models.AirbyteStream@60bc428f[name=billable_rates,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["null","integer"]},"amount":{"type":["null","number"]},"end_date":{"type":["null","string"],"format":"date"},"created_at":{"type":["null","string"],"format":"date-time"},"start_date":{"type":["null","string"],"format":"date"},"updated_at":{"type":["null","string"],"format":"date-time"}}},supportedSyncModes=[full_refresh],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[id]],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=append,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@3f825ad1[stream=io.airbyte.protocol.models.AirbyteStream@768d2c7e[name=clients,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]},"address":{"type":["null","string"]},"currency":{"type":["null","string"]},"is_active":{"type":["null","boolean"]},"created_at":{"type":["null","string"],"format":"date-time"},"updated_at":{"type":["null","string"],"format":"date-time"},"statement_key":{"type":["null","string"]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[updated_at],sourceDefinedPrimaryKey=[[id]],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[updated_at],destinationSyncMode=append,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@772c0d42[stream=io.airbyte.protocol.models.AirbyteStream@75869112[name=company,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"name":{"type":["null","string"]},"clock":{"type":["null","string"]},"base_uri":{"type":["null","string"]},"is_active":{"type":["null","boolean"]},"plan_type":{"type":["null","string"]},"full_domain":{"type":["null","string"]},"time_format":{"type":["null","string"]},"color_scheme":{"type":["null","string"]},"decimal_symbol":{"type":["null","string"]},"week_start_day":{"type":["null","string"]},"expense_feature":{"type":["null","boolean"]},"invoice_feature":{"type":["null","boolean"]},"weekly_capacity":{"type":["null","integer"]},"estimate_feature":{"type":["null","boolean"]},"approval_required":{"type":["null","boolean"]},"thousands_separator":{"type":["null","string"]},"wants_timestamp_timers":{"type":["null","boolean"]}}},supportedSyncModes=[full_refresh],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=append,primaryKey=[],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@58ff19a1[stream=io.airbyte.protocol.models.AirbyteStream@470e201c[name=contacts,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["null","integer"]},"fax":{"type":["null","string"]},"email":{"type":["null","string"]},"title":{"type":["null","string"]},"client":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]}}},"last_name":{"type":["null","string"]},"created_at":{"type":["null","string"],"format":"date-time"},"first_name":{"type":["null","string"]},"updated_at":{"type":["null","string"],"format":"date-time"},"phone_mobile":{"type":["null","string"]},"phone_office":{"type":["null","string"]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[updated_at],sourceDefinedPrimaryKey=[[id]],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[updated_at],destinationSyncMode=append,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@505f73a2[stream=io.airbyte.protocol.models.AirbyteStream@111076ba[name=cost_rates,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["null","integer"]},"amount":{"type":["null","number"]},"end_date":{"type":["null","string"],"format":"date"},"created_at":{"type":["null","string"],"format":"date-time"},"start_date":{"type":["null","string"],"format":"date"},"updated_at":{"type":["null","string"],"format":"date-time"}}},supportedSyncModes=[full_refresh],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[id]],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=append,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@31825728[stream=io.airbyte.protocol.models.AirbyteStream@7ba8fc4[name=estimate_item_categories,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]},"created_at":{"type":["null","string"],"format":"date-time"},"updated_at":{"type":["null","string"],"format":"date-time"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[updated_at],sourceDefinedPrimaryKey=[[id]],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[updated_at],destinationSyncMode=append,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@2cd33ef2[stream=io.airbyte.protocol.models.AirbyteStream@3ee43874[name=estimate_messages,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["null","integer"]},"body":{"type":["null","string"]},"sent_by":{"type":["null","string"]},"subject":{"type":["null","string"]},"sent_from":{"type":["null","string"]},"created_at":{"type":["null","string"],"format":"date-time"},"event_type":{"type":["null","string"]},"recipients":{"type":["null","array"],"items":{"type":"object","properties":{"name":{"type":["string","null"]},"email":{"type":["string","null"]}}}},"updated_at":{"type":["null","string"],"format":"date-time"},"sent_by_email":{"type":["null","string"]},"send_me_a_copy":{"type":["null","boolean"]},"sent_from_email":{"type":["null","string"]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[updated_at],sourceDefinedPrimaryKey=[[id]],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[updated_at],destinationSyncMode=append,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@1d7c0397[stream=io.airbyte.protocol.models.AirbyteStream@4eeb6b53[name=estimates,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["null","integer"]},"tax":{"type":["null","number"]},"tax2":{"type":["null","number"]},"notes":{"type":["null","string"]},"state":{"type":["null","string"]},"amount":{"type":["null","number"]},"client":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]}}},"number":{"type":["null","string"]},"creator":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]}}},"sent_at":{"type":["null","string"],"format":"date-time"},"subject":{"type":["null","string"]},"currency":{"type":["null","string"]},"discount":{"type":["null","number"]},"client_key":{"type":["null","string"]},"created_at":{"type":["null","string"],"format":"date-time"},"issue_date":{"type":["null","string"],"format":"date"},"line_items":{"type":["null","array"]},"tax_amount":{"type":["null","number"]},"updated_at":{"type":["null","string"],"format":"date-time"},"accepted_at":{"type":["null","string"]},"declined_at":{"type":["null","string"]},"tax2_amount":{"type":["null","number"]},"purchase_order":{"type":["null","string"]},"discount_amount":{"type":["null","number"]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[updated_at],sourceDefinedPrimaryKey=[[id]],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[updated_at],destinationSyncMode=append,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@7b7ae8d2[stream=io.airbyte.protocol.models.AirbyteStream@64c24851[name=expense_categories,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]},"is_active":{"type":["null","boolean"]},"unit_name":{"type":["null","string"]},"created_at":{"type":["null","string"],"format":"date-time"},"unit_price":{"type":["null","number"]},"updated_at":{"type":["null","string"],"format":"date-time"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[updated_at],sourceDefinedPrimaryKey=[[id]],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[updated_at],destinationSyncMode=append,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@195f9fe5[stream=io.airbyte.protocol.models.AirbyteStream@cfbce6e[name=expenses,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["null","integer"]},"user":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]}}},"notes":{"type":["null","string"]},"units":{"type":["null","number"]},"client":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]},"currency":{"type":["null","string"]}}},"invoice":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"number":{"type":["null","string"]}}},"project":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"code":{"type":["null","string"]},"name":{"type":["null","string"]}}},"receipt":{"type":["null","object"],"properties":{"url":{"type":["null","string"]},"file_name":{"type":["null","string"]},"file_size":{"type":["null","integer"]},"content_type":{"type":["null","string"]}}},"billable":{"type":["null","boolean"]},"is_billed":{"type":["null","boolean"]},"is_closed":{"type":["null","boolean"]},"is_locked":{"type":["null","boolean"]},"created_at":{"type":["null","string"],"format":"date-time"},"spent_date":{"type":["null","string"],"format":"date"},"total_cost":{"type":["null","number"]},"updated_at":{"type":["null","string"],"format":"date-time"},"locked_reason":{"type":["null","string"]},"user_assignment":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"budget":{"type":["null","number"]},"is_active":{"type":["null","boolean"]},"created_at":{"type":["null","string"],"format":"date-time"},"updated_at":{"type":["null","string"],"format":"date-time"},"hourly_rate":{"type":["null","number"]},"use_default_rates":{"type":["null","boolean"]},"is_project_manager":{"type":["null","boolean"]}}},"expense_category":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]},"unit_name":{"type":["null","string"]},"unit_price":{"type":["null","number"]}}}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[updated_at],sourceDefinedPrimaryKey=[[id]],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[updated_at],destinationSyncMode=append,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@20eb9b5b[stream=io.airbyte.protocol.models.AirbyteStream@561dcfd7[name=expenses_categories,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"to":{"type":["null","string"]},"from":{"type":["null","string"]},"currency":{"type":["null","string"]},"total_amount":{"type":["null","number"]},"billable_amount":{"type":["null","number"]},"expense_category_id":{"type":["null","integer"]},"expense_category_name":{"type":["null","string"]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[to],sourceDefinedPrimaryKey=[],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[to],destinationSyncMode=append,primaryKey=[],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@33d8c246[stream=io.airbyte.protocol.models.AirbyteStream@6102e2ed[name=expenses_clients,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"to":{"type":["null","string"]},"from":{"type":["null","string"]},"currency":{"type":["null","string"]},"client_id":{"type":["null","integer"]},"client_name":{"type":["null","string"]},"total_amount":{"type":["null","number"]},"billable_amount":{"type":["null","number"]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[to],sourceDefinedPrimaryKey=[],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[to],destinationSyncMode=append,primaryKey=[],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@1dcf8cd5[stream=io.airbyte.protocol.models.AirbyteStream@25949bcc[name=expenses_projects,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"to":{"type":["null","string"]},"from":{"type":["null","string"]},"currency":{"type":["null","string"]},"client_id":{"type":["null","integer"]},"project_id":{"type":["null","integer"]},"client_name":{"type":["null","string"]},"project_name":{"type":["null","string"]},"total_amount":{"type":["null","number"]},"billable_amount":{"type":["null","number"]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[to],sourceDefinedPrimaryKey=[],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[to],destinationSyncMode=append,primaryKey=[],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@502ba7ca[stream=io.airbyte.protocol.models.AirbyteStream@26c832a8[name=expenses_team,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"to":{"type":["null","string"]},"from":{"type":["null","string"]},"user_id":{"type":["null","integer"]},"currency":{"type":["null","string"]},"user_name":{"type":["null","string"]},"total_amount":{"type":["null","number"]},"is_contractor":{"type":["null","boolean"]},"billable_amount":{"type":["null","number"]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[to],sourceDefinedPrimaryKey=[],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[to],destinationSyncMode=append,primaryKey=[],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@4700ab80[stream=io.airbyte.protocol.models.AirbyteStream@46cb0257[name=invoice_item_categories,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]},"created_at":{"type":["null","string"],"format":"date-time"},"updated_at":{"type":["null","string"],"format":"date-time"},"use_as_expense":{"type":["null","boolean"]},"use_as_service":{"type":["null","boolean"]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[updated_at],sourceDefinedPrimaryKey=[[id]],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[updated_at],destinationSyncMode=append,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@4bd3e8b3[stream=io.airbyte.protocol.models.AirbyteStream@2c69ce13[name=invoice_messages,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["null","integer"]},"body":{"type":["null","string"]},"sent_by":{"type":["null","string"]},"subject":{"type":["null","string"]},"reminder":{"type":["null","boolean"]},"sent_from":{"type":["null","string"]},"thank_you":{"type":["null","boolean"]},"attach_pdf":{"type":["null","boolean"]},"created_at":{"type":["null","string"],"format":"date-time"},"event_type":{"type":["null","string"]},"recipients":{"type":["null","array"],"items":{"type":"object","properties":{"name":{"type":"string"},"email":{"type":"string"}}}},"updated_at":{"type":["null","string"],"format":"date-time"},"sent_by_email":{"type":["null","string"]},"send_me_a_copy":{"type":["null","boolean"]},"sent_from_email":{"type":["null","string"]},"send_reminder_on":{"type":["null","string"]},"include_link_to_client_invoice":{"type":["null","boolean"]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[updated_at],sourceDefinedPrimaryKey=[[id]],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[updated_at],destinationSyncMode=append,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@6ef72cb5[stream=io.airbyte.protocol.models.AirbyteStream@70304286[name=invoice_payments,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["null","integer"]},"notes":{"type":["null","string"]},"amount":{"type":["null","number"]},"paid_at":{"type":["null","string"],"format":"date-time"},"paid_date":{"type":["null","string"],"format":"date"},"created_at":{"type":["null","string"],"format":"date-time"},"updated_at":{"type":["null","string"],"format":"date-time"},"recorded_by":{"type":["null","string"]},"transaction_id":{"type":["null","string"]},"payment_gateway":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]}}},"recorded_by_email":{"type":["null","string"]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[updated_at],sourceDefinedPrimaryKey=[[id]],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[updated_at],destinationSyncMode=append,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@2472aa43[stream=io.airbyte.protocol.models.AirbyteStream@4689f188[name=invoices,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["null","integer"]},"tax":{"type":["null","number"]},"tax2":{"type":["null","number"]},"notes":{"type":["null","string"]},"state":{"type":["null","string"]},"amount":{"type":["null","number"]},"client":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]}}},"number":{"type":["null","string"]},"creator":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]}}},"paid_at":{"type":["null","string"]},"sent_at":{"type":["null","string"],"format":"date-time"},"subject":{"type":["null","string"]},"currency":{"type":["null","string"]},"discount":{"type":["null","number"]},"due_date":{"type":["null","string"]},"estimate":{"type":["null","string"]},"retainer":{"type":["null","string"]},"closed_at":{"type":["null","string"]},"paid_date":{"type":["null","string"]},"client_key":{"type":["null","string"]},"created_at":{"type":["null","string"],"format":"date-time"},"due_amount":{"type":["null","number"]},"issue_date":{"type":["null","string"]},"line_items":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"kind":{"type":["null","string"]},"taxed":{"type":["null","boolean"]},"amount":{"type":["null","number"]},"taxed2":{"type":["null","boolean"]},"project":{"type":["null","object"],"properties":{"id":{"type":["integer","null"]},"code":{"type":["null","string"]},"name":{"type":["null","string"]}}},"quantity":{"type":["null","number"]},"unit_price":{"type":["null","number"]},"description":{"type":["null","string"]}}}},"period_end":{"type":["null","string"]},"tax_amount":{"type":["null","number"]},"updated_at":{"type":["null","string"],"format":"date-time"},"tax2_amount":{"type":["null","number"]},"payment_term":{"type":["null","string"]},"period_start":{"type":["null","string"]},"purchase_order":{"type":["null","string"]},"discount_amount":{"type":["null","number"]},"recurring_invoice_id":{"type":["null","string"]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[updated_at],sourceDefinedPrimaryKey=[[id]],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[updated_at],destinationSyncMode=append,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@11ccef68[stream=io.airbyte.protocol.models.AirbyteStream@631aaba5[name=project_assignments,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["null","integer"]},"budget":{"type":["null","number"]},"client":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]},"currency":{"type":["null","string"]}}},"project":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"code":{"type":["null","string"]},"name":{"type":["null","string"]}}},"is_active":{"type":["null","boolean"]},"created_at":{"type":["null","string"],"format":"date-time"},"updated_at":{"type":["null","string"],"format":"date-time"},"hourly_rate":{"type":["null","number"]},"task_assignments":{"type":["null","array"],"items":{"type":"object","properties":{"id":{"type":["null","integer"]},"task":{"type":["object","null"],"properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]}}},"budget":{"type":["null","number"]},"billable":{"type":["null","boolean"]},"is_active":{"type":["null","boolean"]},"created_at":{"type":["string","null"]},"updated_at":{"type":["null","string"]},"hourly_rate":{"type":["null","number"]}}}},"use_default_rates":{"type":["null","boolean"]},"is_project_manager":{"type":["null","boolean"]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[updated_at],sourceDefinedPrimaryKey=[[id]],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[updated_at],destinationSyncMode=append,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@520b3537[stream=io.airbyte.protocol.models.AirbyteStream@5b078b4f[name=project_budget,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"to":{"type":["null","string"]},"from":{"type":["null","string"]},"budget":{"type":["null","number"]},"budget_by":{"type":["null","string"]},"client_id":{"type":["null","integer"]},"is_active":{"type":["null","boolean"]},"project_id":{"type":["null","integer"]},"client_name":{"type":["null","string"]},"budget_spent":{"type":["null","number"]},"project_name":{"type":["null","string"]},"budget_remaining":{"type":["null","number"]},"budget_is_monthly":{"type":["null","boolean"]}}},supportedSyncModes=[full_refresh],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=append,primaryKey=[],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@2d4698e8[stream=io.airbyte.protocol.models.AirbyteStream@1bb74966[name=projects,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["null","integer"]},"fee":{"type":["null","number"]},"code":{"type":["null","string"]},"name":{"type":["null","string"]},"notes":{"type":["null","string"]},"budget":{"type":["null","number"]},"client":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]},"currency":{"type":["null","string"]}}},"bill_by":{"type":["null","string"]},"ends_on":{"type":["null","string"]},"budget_by":{"type":["null","string"]},"is_active":{"type":["null","boolean"]},"starts_on":{"type":["null","string"],"format":"date"},"created_at":{"type":["null","string"],"format":"date-time"},"updated_at":{"type":["null","string"],"format":"date-time"},"cost_budget":{"type":["null","number"]},"hourly_rate":{"type":["null","number"]},"is_billable":{"type":["null","boolean"]},"is_fixed_fee":{"type":["null","boolean"]},"budget_is_monthly":{"type":["null","boolean"]},"show_budget_to_all":{"type":["null","boolean"]},"notify_when_over_budget":{"type":["null","boolean"]},"cost_budget_include_expenses":{"type":["null","boolean"]},"over_budget_notification_date":{"type":["null","string"],"format":"date"},"over_budget_notification_percentage":{"type":["null","number"]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[updated_at],sourceDefinedPrimaryKey=[[id]],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[updated_at],destinationSyncMode=append,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@101e65aa[stream=io.airbyte.protocol.models.AirbyteStream@7724c915[name=roles,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]},"user_ids":{"type":["null","array"],"items":{"type":"integer"}},"created_at":{"type":["null","string"],"format":"date-time"},"updated_at":{"type":["null","string"],"format":"date-time"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[updated_at],sourceDefinedPrimaryKey=[[id]],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[updated_at],destinationSyncMode=append,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@6e3c9ec1[stream=io.airbyte.protocol.models.AirbyteStream@4f610619[name=task_assignments,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["null","integer"]},"task":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]}}},"budget":{"type":["null","string"]},"project":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"code":{"type":["null","string"]},"name":{"type":["null","string"]}}},"billable":{"type":["null","boolean"]},"is_active":{"type":["null","boolean"]},"created_at":{"type":["null","string"],"format":"date-time"},"updated_at":{"type":["null","string"],"format":"date-time"},"hourly_rate":{"type":["null","number"]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[updated_at],sourceDefinedPrimaryKey=[[id]],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[updated_at],destinationSyncMode=append,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@2cb1096a[stream=io.airbyte.protocol.models.AirbyteStream@7d8c1188[name=tasks,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]},"is_active":{"type":["null","boolean"]},"created_at":{"type":["null","string"],"format":"date-time"},"is_default":{"type":["null","boolean"]},"updated_at":{"type":["null","string"],"format":"date-time"},"billable_by_default":{"type":["null","boolean"]},"default_hourly_rate":{"type":["null","number"]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[updated_at],sourceDefinedPrimaryKey=[[id]],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[updated_at],destinationSyncMode=append,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@774c526e[stream=io.airbyte.protocol.models.AirbyteStream@305ad350[name=time_clients,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"to":{"type":["null","string"]},"from":{"type":["null","string"]},"currency":{"type":["null","string"]},"client_id":{"type":["null","integer"]},"client_name":{"type":["null","string"]},"total_hours":{"type":["null","number"]},"billable_hours":{"type":["null","number"]},"billable_amount":{"type":["null","number"]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[to],sourceDefinedPrimaryKey=[],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[to],destinationSyncMode=append,primaryKey=[],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@14846668[stream=io.airbyte.protocol.models.AirbyteStream@9192521[name=time_entries,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["null","integer"]},"task":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]}}},"user":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]}}},"hours":{"type":["null","number"]},"notes":{"type":["null","string"]},"client":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]},"currency":{"type":["null","string"]}}},"invoice":{"type":["null","object"],"properties":{"id":{"type":"integer"},"number":{"type":"string"}}},"project":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"code":{"type":["null","string"]},"name":{"type":["null","string"]}}},"billable":{"type":["null","boolean"]},"budgeted":{"type":["null","boolean"]},"cost_rate":{"type":["null","number"]},"is_billed":{"type":["null","boolean"]},"is_closed":{"type":["null","boolean"]},"is_locked":{"type":["null","boolean"]},"created_at":{"type":["null","string"],"format":"date-time"},"ended_time":{"type":["null","string"],"format":"date-time"},"is_running":{"type":["null","boolean"]},"spent_date":{"type":["null","string"],"format":"date"},"updated_at":{"type":["null","string"],"format":"date-time"},"started_time":{"type":["null","string"],"format":"date-time"},"billable_rate":{"type":["null","number"]},"locked_reason":{"type":["null","string"]},"rounded_hours":{"type":["null","number"]},"task_assignment":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"budget":{"type":["null","number"]},"billable":{"type":["null","boolean"]},"is_active":{"type":["null","boolean"]},"created_at":{"type":["null","string"],"format":"date-time"},"updated_at":{"type":["null","string"],"format":"date-time"},"hourly_rate":{"type":["null","number"]}}},"user_assignment":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"budget":{"type":["null","number"]},"is_active":{"type":["null","boolean"]},"created_at":{"type":["null","string"],"format":"date-time"},"updated_at":{"type":["null","string"],"format":"date-time"},"hourly_rate":{"type":["null","number"]},"is_project_manager":{"type":["null","boolean"]}}},"timer_started_at":{"type":["null","string"]},"external_reference":{"type":["null","string"]},"hours_without_timer":{"type":["null","number"]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[updated_at],sourceDefinedPrimaryKey=[[id]],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[updated_at],destinationSyncMode=append,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@1c53d94e[stream=io.airbyte.protocol.models.AirbyteStream@7af559c7[name=time_projects,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"to":{"type":["null","string"]},"from":{"type":["null","string"]},"currency":{"type":["null","string"]},"client_id":{"type":["null","integer"]},"project_id":{"type":["null","integer"]},"client_name":{"type":["null","string"]},"total_hours":{"type":["null","number"]},"project_name":{"type":["null","string"]},"billable_hours":{"type":["null","number"]},"billable_amount":{"type":["null","number"]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[to],sourceDefinedPrimaryKey=[],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[to],destinationSyncMode=append,primaryKey=[],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@4df5d7d7[stream=io.airbyte.protocol.models.AirbyteStream@d05c365[name=time_tasks,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"to":{"type":["null","string"]},"from":{"type":["null","string"]},"task_id":{"type":["null","integer"]},"currency":{"type":["null","string"]},"task_name":{"type":["null","string"]},"total_hours":{"type":["null","number"]},"billable_hours":{"type":["null","number"]},"billable_amount":{"type":["null","number"]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[to],sourceDefinedPrimaryKey=[],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[to],destinationSyncMode=append,primaryKey=[],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@f9ee222[stream=io.airbyte.protocol.models.AirbyteStream@5ff5a977[name=time_team,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"to":{"type":["null","string"]},"from":{"type":["null","string"]},"user_id":{"type":["null","integer"]},"currency":{"type":["null","string"]},"user_name":{"type":["null","string"]},"total_hours":{"type":["null","number"]},"is_contractor":{"type":["null","boolean"]},"billable_hours":{"type":["null","number"]},"billable_amount":{"type":["null","number"]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[to],sourceDefinedPrimaryKey=[],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[to],destinationSyncMode=append,primaryKey=[],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@3c5d9631[stream=io.airbyte.protocol.models.AirbyteStream@1fe06434[name=uninvoiced,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"to":{"type":["null","string"]},"from":{"type":["null","string"]},"currency":{"type":["null","string"]},"client_id":{"type":["null","integer"]},"project_id":{"type":["null","integer"]},"client_name":{"type":["null","string"]},"total_hours":{"type":["null","number"]},"project_name":{"type":["null","string"]},"uninvoiced_hours":{"type":["null","number"]},"uninvoiced_amount":{"type":["null","number"]},"uninvoiced_expenses":{"type":["null","number"]}}},supportedSyncModes=[full_refresh],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=append,primaryKey=[],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@67170a18[stream=io.airbyte.protocol.models.AirbyteStream@15dbb99c[name=user_assignments,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["null","integer"]},"user":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]}}},"budget":{"type":["null","number"]},"project":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"code":{"type":["null","string"]},"name":{"type":["null","string"]}}},"is_active":{"type":["null","boolean"]},"created_at":{"type":["null","string"],"format":"date-time"},"updated_at":{"type":["null","string"],"format":"date-time"},"hourly_rate":{"type":["null","number"]},"use_default_rates":{"type":["null","boolean"]},"is_project_manager":{"type":["null","boolean"]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[updated_at],sourceDefinedPrimaryKey=[[id]],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[updated_at],destinationSyncMode=append,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@45e75908[stream=io.airbyte.protocol.models.AirbyteStream@59ba5444[name=users,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["null","integer"]},"email":{"type":["null","string"]},"roles":{"type":["null","array"],"items":{"type":"string"}},"is_admin":{"type":["null","boolean"]},"timezone":{"type":["null","string"]},"cost_rate":{"type":["null","number"]},"is_active":{"type":["null","boolean"]},"last_name":{"type":["null","string"]},"telephone":{"type":["null","string"]},"avatar_url":{"type":["null","string"]},"created_at":{"type":["null","string"],"format":"date-time"},"first_name":{"type":["null","string"]},"updated_at":{"type":["null","string"],"format":"date-time"},"can_see_rates":{"type":["null","boolean"]},"is_contractor":{"type":["null","boolean"]},"weekly_capacity":{"type":["null","integer"]},"is_project_manager":{"type":["null","boolean"]},"can_create_invoices":{"type":["null","boolean"]},"can_create_projects":{"type":["null","boolean"]},"default_hourly_rate":{"type":["null","number"]},"calendar_integration_source":{"type":["null","string"]},"calendar_integration_enabled":{"type":["null","boolean"]},"has_access_to_all_future_projects":{"type":["null","boolean"]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[updated_at],sourceDefinedPrimaryKey=[[id]],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[updated_at],destinationSyncMode=append,primaryKey=[[id]],additionalProperties={}]],additionalProperties={}],failures=[io.airbyte.config.FailureReason@6a2c2a1[failureOrigin=source,failureType=,internalMessage=io.airbyte.workers.DefaultReplicationWorker$SourceException: Source process exited with non-zero exit code 1,externalMessage=Something went wrong within the source connector,metadata=io.airbyte.config.Metadata@4efd9cb0[additionalProperties={attemptNumber=0, jobId=19}],stacktrace=java.util.concurrent.CompletionException: io.airbyte.workers.DefaultReplicationWorker$SourceException: Source 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.DefaultReplicationWorker$SourceException: Source process exited with non-zero exit code 1 at io.airbyte.workers.DefaultReplicationWorker.lambda$getReplicationRunnable$5(DefaultReplicationWorker.java:312) at java.base/java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1804) ... 3 more ,retryable=,timestamp=1649262220735]]] 2022-04-06 16:24:00 INFO i.a.w.t.TemporalUtils(withBackgroundHeartbeat):235 - Stopping temporal heartbeating... 2022-04-06 16:24:00 INFO i.a.c.p.ConfigRepository(updateConnectionState):731 - Updating connection b9d54989-9024-4513-a213-c7c6ad9d5268 state: io.airbyte.config.State@40a537b9[state={}] 2022-04-06 16:24:00 INFO i.a.v.j.JsonSchemaValidator(test):56 - JSON schema validation failed. errors: $.client_id: is missing but it is required, $.client_secret: is missing but it is required, $.refresh_token: is missing but it is required, $.api_token: is not defined in the schema and the schema does not allow additional properties, $.auth_type: must be a constant value Client, $.auth_type: does not have a value in the enumeration [Client]