2022-11-03 13:31:28 INFO i.a.w.t.TemporalAttemptExecution(get):136 - Docker volume job log path: /tmp/workspace/887/0/logs.log 2022-11-03 13:31:28 INFO i.a.w.t.TemporalAttemptExecution(get):141 - Executing worker wrapper. Airbyte version: 0.40.16 2022-11-03 13:31:28 INFO i.a.c.f.EnvVariableFeatureFlags(getEnvOrDefault):50 - Using default value for environment variable LOG_CONNECTOR_MESSAGES: 'false' 2022-11-03 13:31:28 INFO i.a.c.EnvConfigs(getEnvOrDefault):1091 - Using default value for environment variable METRIC_CLIENT: '' 2022-11-03 13:31:28 WARN i.a.m.l.MetricClientFactory(initialize):60 - Metric client is already initialized to 2022-11-03 13:31:28 INFO i.a.c.f.EnvVariableFeatureFlags(getEnvOrDefault):50 - Using default value for environment variable LOG_CONNECTOR_MESSAGES: 'false' 2022-11-03 13:31:28 INFO i.a.w.g.DefaultReplicationWorker(run):125 - start sync worker. job id: 887 attempt id: 0 2022-11-03 13:31:28 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-11-03 13:31:28 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- START REPLICATION ----- 2022-11-03 13:31:28 INFO i.a.w.g.DefaultReplicationWorker(run):141 - configured sync modes: {null.media_insights=full_refresh - overwrite, null.stories=full_refresh - overwrite, null.story_insights=full_refresh - overwrite, null.user_lifetime_insights=full_refresh - append, null.users=full_refresh - overwrite, null.media=full_refresh - overwrite, null.user_insights=incremental - append} 2022-11-03 13:31:28 INFO i.a.w.i.DefaultAirbyteDestination(start):65 - Running destination... 2022-11-03 13:31:28 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-11-03 13:31:28 INFO i.a.c.i.LineGobbler(voidCall):114 - Checking if airbyte/destination-bigquery:1.2.5 exists... 2022-11-03 13:31:28 INFO i.a.c.i.LineGobbler(voidCall):114 - airbyte/destination-bigquery:1.2.5 was found locally. 2022-11-03 13:31:28 INFO i.a.w.p.DockerProcessFactory(create):119 - Creating docker container = destination-bigquery-write-887-0-eireh with resources io.airbyte.config.ResourceRequirements@2a1f7045[cpuRequest=,cpuLimit=,memoryRequest=,memoryLimit=] 2022-11-03 13:31:28 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/887/0 --log-driver none --name destination-bigquery-write-887-0-eireh --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=true -e WORKER_ENVIRONMENT=DOCKER -e AIRBYTE_ROLE= -e WORKER_JOB_ATTEMPT=0 -e WORKER_CONNECTOR_IMAGE=airbyte/destination-bigquery:1.2.5 -e AIRBYTE_VERSION=0.40.16 -e WORKER_JOB_ID=887 airbyte/destination-bigquery:1.2.5 write --config destination_config.json --catalog destination_catalog.json 2022-11-03 13:31:28 INFO i.a.c.i.LineGobbler(voidCall):114 - Checking if airbyte/source-instagram:1.0.0 exists... 2022-11-03 13:31:28 INFO i.a.c.i.LineGobbler(voidCall):114 - airbyte/source-instagram:1.0.0 was found locally. 2022-11-03 13:31:28 INFO i.a.w.p.DockerProcessFactory(create):119 - Creating docker container = source-instagram-read-887-0-hgaju with resources io.airbyte.config.ResourceRequirements@67a53af0[cpuRequest=,cpuLimit=,memoryRequest=,memoryLimit=] 2022-11-03 13:31:28 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/887/0 --log-driver none --name source-instagram-read-887-0-hgaju --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=true -e WORKER_ENVIRONMENT=DOCKER -e AIRBYTE_ROLE= -e WORKER_JOB_ATTEMPT=0 -e WORKER_CONNECTOR_IMAGE=airbyte/source-instagram:1.0.0 -e AIRBYTE_VERSION=0.40.16 -e WORKER_JOB_ID=887 airbyte/source-instagram:1.0.0 read --config source_config.json --catalog source_catalog.json --state input_state.json 2022-11-03 13:31:28 INFO i.a.w.g.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$7):454 - Destination output thread started. 2022-11-03 13:31:28 INFO i.a.w.g.DefaultReplicationWorker(run):185 - Waiting for source and destination threads to complete. 2022-11-03 13:31:28 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):339 - Replication thread started. 2022-11-03 13:31:30 source > Starting syncing SourceInstagram 2022-11-03 13:31:30 source > Syncing stream: media 2022-11-03 13:31:32 destination > integration args: {catalog=destination_catalog.json, write=null, config=destination_config.json} 2022-11-03 13:31:32 destination > Running integration: io.airbyte.integrations.destination.bigquery.BigQueryDestination 2022-11-03 13:31:32 destination > Command: WRITE 2022-11-03 13:31:32 destination > Integration config: IntegrationConfig{command=WRITE, configPath='destination_config.json', catalogPath='destination_catalog.json', statePath='null'} 2022-11-03 13:31:32 source > /usr/local/lib/python3.9/site-packages/facebook_business/utils/api_utils.py:30: UserWarning: media does not allow field children 2022-11-03 13:31:32 source > warnings.warn(message) 2022-11-03 13:31:32 destination > Unknown keyword order - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-11-03 13:31:32 destination > Unknown keyword airbyte_secret - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-11-03 13:31:32 destination > Selected loading method is set to: STANDARD 2022-11-03 13:31:32 destination > The "standard" upload mode is not performant, and is not recommended for production. Please use the GCS upload mode if you are syncing a large amount of data. 2022-11-03 13:31:32 destination > Selected loading method is set to: STANDARD 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 destination > Partitioned table created successfully: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, tableId=_airbyte_tmp_lgl_instagram_media}} 2022-11-03 13:31:34 destination > Selected loading method is set to: STANDARD 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 13:31:34 destination > Selected loading method is set to: STANDARD 2022-11-03 13:31:35 destination > Partitioned table created successfully: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, tableId=_airbyte_tmp_xot_instagram_media_insights}} 2022-11-03 13:31:35 destination > Selected loading method is set to: STANDARD 2022-11-03 13:31:35 destination > Selected loading method is set to: STANDARD 2022-11-03 13:31:36 destination > Partitioned table created successfully: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, tableId=_airbyte_tmp_izy_instagram_stories}} 2022-11-03 13:31:36 destination > Selected loading method is set to: STANDARD 2022-11-03 13:31:36 destination > Selected loading method is set to: STANDARD 2022-11-03 13:31:36 destination > Partitioned table created successfully: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, tableId=_airbyte_tmp_gmb_instagram_story_insights}} 2022-11-03 13:31:36 destination > Selected loading method is set to: STANDARD 2022-11-03 13:31:37 destination > Selected loading method is set to: STANDARD 2022-11-03 13:31:37 destination > Partitioned table created successfully: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, tableId=_airbyte_tmp_obs_instagram_user_insights}} 2022-11-03 13:31:37 destination > Selected loading method is set to: STANDARD 2022-11-03 13:31:38 destination > Selected loading method is set to: STANDARD 2022-11-03 13:31:38 destination > Partitioned table created successfully: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, tableId=_airbyte_tmp_kvd_instagram_user_lifetime_insights}} 2022-11-03 13:31:38 destination > Selected loading method is set to: STANDARD 2022-11-03 13:31:38 destination > Selected loading method is set to: STANDARD 2022-11-03 13:31:39 destination > Partitioned table created successfully: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, tableId=_airbyte_tmp_fxh_instagram_users}} 2022-11-03 13:31:39 destination > Selected loading method is set to: STANDARD 2022-11-03 13:32:00 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):369 - Records read: 1000 (925 KB) 2022-11-03 13:33:23 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):369 - Records read: 2000 (2 MB) 2022-11-03 13:35:13 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):369 - Records read: 3000 (3 MB) 2022-11-03 13:35:18 source > Read 3487 records from media stream 2022-11-03 13:35:18 source > Finished syncing media 2022-11-03 13:35:18 source > SourceInstagram runtimes: Syncing stream media 0:03:48.043881 2022-11-03 13:35:18 source > Syncing stream: media_insights 2022-11-03 13:36:32 source > /usr/local/lib/python3.9/site-packages/facebook_business/utils/api_utils.py:30: UserWarning: value of metric might not be compatible. Expect list; got 2022-11-03 13:36:32 source > warnings.warn(message) 2022-11-03 13:37:49 source > Backing off call(...) for 5.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17866676527332611/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AZll11biHBBOyYmXMQenbAS" } }) 2022-11-03 13:37:55 source > Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17866676527332611/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AZll11biHBBOyYmXMQenbAS" } } 2022-11-03 13:37:55 source > Caught retryable error after 1 tries. Waiting 5 more seconds then retrying... 2022-11-03 13:37:55 source > Backing off call(...) for 10.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17866676527332611/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "A481qkEwS6yP1ef5UMHMmEd" } }) 2022-11-03 13:38:05 source > Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17866676527332611/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "A481qkEwS6yP1ef5UMHMmEd" } } 2022-11-03 13:38:05 source > Caught retryable error after 2 tries. Waiting 10 more seconds then retrying... 2022-11-03 13:38:05 source > Backing off call(...) for 20.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17866676527332611/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AnPdfzANnP_VZnm5EjKgd2O" } }) 2022-11-03 13:38:25 source > Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17866676527332611/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AnPdfzANnP_VZnm5EjKgd2O" } } 2022-11-03 13:38:25 source > Caught retryable error after 3 tries. Waiting 20 more seconds then retrying... 2022-11-03 13:38:25 source > Backing off call(...) for 40.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17866676527332611/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AWWocZeTz0-PvHFO0SdVeOb" } }) 2022-11-03 13:39:05 source > Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17866676527332611/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AWWocZeTz0-PvHFO0SdVeOb" } } 2022-11-03 13:39:05 source > Caught retryable error after 4 tries. Waiting 40 more seconds then retrying... 2022-11-03 13:39:05 source > Backing off call(...) for 80.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17866676527332611/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "ASG42RuWaITZDBWpmOTDZrc" } }) 2022-11-03 13:40:25 source > Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17866676527332611/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "ASG42RuWaITZDBWpmOTDZrc" } } 2022-11-03 13:40:25 source > Caught retryable error after 5 tries. Waiting 80 more seconds then retrying... 2022-11-03 13:40:25 source > Backing off call(...) for 160.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17866676527332611/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AatihZ5krIt146O_SVrAvI6" } }) 2022-11-03 13:43:06 source > Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17866676527332611/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AatihZ5krIt146O_SVrAvI6" } } 2022-11-03 13:43:06 source > Caught retryable error after 6 tries. Waiting 160 more seconds then retrying... 2022-11-03 13:43:06 source > Giving up call(...) after 7 tries (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17866676527332611/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AGhplzyh8J2VuHx0pLjYbgl" } }) 2022-11-03 13:43:06 source > Insights error for business_account_id 17841400844997659: Media posted before business account conversion 2022-11-03 13:44:09 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):369 - Records read: 4000 (3 MB) 2022-11-03 13:47:33 source > Backing off call(...) for 5.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17844517699238475/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AtPGsOK5IS0-6hDzDD7jZ93" } }) 2022-11-03 13:47:38 source > Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17844517699238475/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AtPGsOK5IS0-6hDzDD7jZ93" } } 2022-11-03 13:47:38 source > Caught retryable error after 1 tries. Waiting 5 more seconds then retrying... 2022-11-03 13:47:38 source > Backing off call(...) for 10.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17844517699238475/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AxjEYUrB82vBCEd5h7MAYkK" } }) 2022-11-03 13:47:48 source > Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17844517699238475/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AxjEYUrB82vBCEd5h7MAYkK" } } 2022-11-03 13:47:48 source > Caught retryable error after 2 tries. Waiting 10 more seconds then retrying... 2022-11-03 13:47:48 source > Backing off call(...) for 20.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17844517699238475/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AGnxsbVI86frHsMZodU6soj" } }) 2022-11-03 13:48:08 source > Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17844517699238475/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AGnxsbVI86frHsMZodU6soj" } } 2022-11-03 13:48:08 source > Caught retryable error after 3 tries. Waiting 20 more seconds then retrying... 2022-11-03 13:48:08 source > Backing off call(...) for 40.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17844517699238475/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AEIRX5HYiUF5-xPBR2oEjAB" } }) 2022-11-03 13:48:48 source > Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17844517699238475/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AEIRX5HYiUF5-xPBR2oEjAB" } } 2022-11-03 13:48:48 source > Caught retryable error after 4 tries. Waiting 40 more seconds then retrying... 2022-11-03 13:48:48 source > Backing off call(...) for 80.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17844517699238475/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AzOVPrsH8GyIxAqoTtd1WaD" } }) 2022-11-03 13:50:09 source > Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17844517699238475/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AzOVPrsH8GyIxAqoTtd1WaD" } } 2022-11-03 13:50:09 source > Caught retryable error after 5 tries. Waiting 80 more seconds then retrying... 2022-11-03 13:50:09 source > Backing off call(...) for 160.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17844517699238475/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AUwjTEDBARAFxzlK73w3R5n" } }) 2022-11-03 13:52:49 source > Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17844517699238475/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AUwjTEDBARAFxzlK73w3R5n" } } 2022-11-03 13:52:49 source > Caught retryable error after 6 tries. Waiting 160 more seconds then retrying... 2022-11-03 13:52:49 source > Giving up call(...) after 7 tries (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17844517699238475/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AuA5FHEQAxGmL9vTOwZ3T8T" } }) 2022-11-03 13:52:49 source > Insights error for business_account_id 17841406448385387: Media posted before business account conversion 2022-11-03 13:54:48 source > Backing off call(...) for 5.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17862901051076051/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AxoV7qUrR7nqDudY6HDTLUo" } }) 2022-11-03 13:54:54 source > Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17862901051076051/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AxoV7qUrR7nqDudY6HDTLUo" } } 2022-11-03 13:54:54 source > Caught retryable error after 1 tries. Waiting 5 more seconds then retrying... 2022-11-03 13:54:54 source > Backing off call(...) for 10.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17862901051076051/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AJvDhHYmduuybByNta9kKbz" } }) 2022-11-03 13:55:04 source > Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17862901051076051/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AJvDhHYmduuybByNta9kKbz" } } 2022-11-03 13:55:04 source > Caught retryable error after 2 tries. Waiting 10 more seconds then retrying... 2022-11-03 13:55:04 source > Backing off call(...) for 20.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17862901051076051/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AR-CbRE0PsjFPheHIPU8ZXf" } }) 2022-11-03 13:55:24 source > Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17862901051076051/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AR-CbRE0PsjFPheHIPU8ZXf" } } 2022-11-03 13:55:24 source > Caught retryable error after 3 tries. Waiting 20 more seconds then retrying... 2022-11-03 13:55:24 source > Backing off call(...) for 40.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17862901051076051/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AdTWMoTgw9CYAUgdLP_G8ep" } }) 2022-11-03 13:56:04 source > Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17862901051076051/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AdTWMoTgw9CYAUgdLP_G8ep" } } 2022-11-03 13:56:04 source > Caught retryable error after 4 tries. Waiting 40 more seconds then retrying... 2022-11-03 13:56:04 source > Backing off call(...) for 80.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17862901051076051/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "A7PHSPKLMGJBVs5JJmkJYgG" } }) 2022-11-03 13:57:24 source > Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17862901051076051/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "A7PHSPKLMGJBVs5JJmkJYgG" } } 2022-11-03 13:57:24 source > Caught retryable error after 5 tries. Waiting 80 more seconds then retrying... 2022-11-03 13:57:24 source > Backing off call(...) for 160.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17862901051076051/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AjAGrtxZiuxaokXJB2DVl2T" } }) 2022-11-03 14:00:05 source > Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17862901051076051/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AjAGrtxZiuxaokXJB2DVl2T" } } 2022-11-03 14:00:05 source > Caught retryable error after 6 tries. Waiting 160 more seconds then retrying... 2022-11-03 14:00:05 source > Giving up call(...) after 7 tries (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17862901051076051/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AFXFRVrETDorI7tHV6XZlCF" } }) 2022-11-03 14:00:05 source > Insights error for business_account_id 17841400657993479: Media posted before business account conversion 2022-11-03 14:01:00 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):369 - Records read: 5000 (3 MB) 2022-11-03 14:04:38 source > Backing off call(...) for 5.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17864151274064454/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AGkM-EznqiEjZbOPC4U5wc1" } }) 2022-11-03 14:04:43 source > Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17864151274064454/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AGkM-EznqiEjZbOPC4U5wc1" } } 2022-11-03 14:04:43 source > Caught retryable error after 1 tries. Waiting 5 more seconds then retrying... 2022-11-03 14:04:43 source > Backing off call(...) for 10.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17864151274064454/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AN1DID36sNW_8nqUKB1Quog" } }) 2022-11-03 14:04:53 source > Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17864151274064454/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AN1DID36sNW_8nqUKB1Quog" } } 2022-11-03 14:04:53 source > Caught retryable error after 2 tries. Waiting 10 more seconds then retrying... 2022-11-03 14:04:53 source > Backing off call(...) for 20.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17864151274064454/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "Aqj6XEXyaVWnT7gR7xFhNmW" } }) 2022-11-03 14:05:13 source > Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17864151274064454/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "Aqj6XEXyaVWnT7gR7xFhNmW" } } 2022-11-03 14:05:13 source > Caught retryable error after 3 tries. Waiting 20 more seconds then retrying... 2022-11-03 14:05:13 source > Backing off call(...) for 40.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17864151274064454/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AAmVoinvgLcDYhTyGpSH7A8" } }) 2022-11-03 14:05:53 source > Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17864151274064454/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AAmVoinvgLcDYhTyGpSH7A8" } } 2022-11-03 14:05:53 source > Caught retryable error after 4 tries. Waiting 40 more seconds then retrying... 2022-11-03 14:05:53 source > Backing off call(...) for 80.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17864151274064454/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AuJBsDK9QJ-U-y6ESZzLqCo" } }) 2022-11-03 14:07:13 source > Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17864151274064454/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AuJBsDK9QJ-U-y6ESZzLqCo" } } 2022-11-03 14:07:13 source > Caught retryable error after 5 tries. Waiting 80 more seconds then retrying... 2022-11-03 14:07:13 source > Backing off call(...) for 160.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17864151274064454/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "A3DVmBYKPDH36joBnwQz8aB" } }) 2022-11-03 14:09:54 source > Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17864151274064454/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "A3DVmBYKPDH36joBnwQz8aB" } } 2022-11-03 14:09:54 source > Caught retryable error after 6 tries. Waiting 160 more seconds then retrying... 2022-11-03 14:09:54 source > Giving up call(...) after 7 tries (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17864151274064454/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AKMmyb2Z63vuiBV1H-Ohgln" } }) 2022-11-03 14:09:54 source > Insights error for business_account_id 17841403860219174: Media posted before business account conversion 2022-11-03 14:12:39 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):369 - Records read: 6000 (4 MB) 2022-11-03 14:15:34 source > Backing off call(...) for 5.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17897537821166464/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "An8dHaqk8UObfYhzDs3HOPy" } }) 2022-11-03 14:15:39 source > Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17897537821166464/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "An8dHaqk8UObfYhzDs3HOPy" } } 2022-11-03 14:15:39 source > Caught retryable error after 1 tries. Waiting 5 more seconds then retrying... 2022-11-03 14:15:39 source > Backing off call(...) for 10.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17897537821166464/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "ADSRbFG48G4AFigQdWvWkQH" } }) 2022-11-03 14:15:49 source > Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17897537821166464/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "ADSRbFG48G4AFigQdWvWkQH" } } 2022-11-03 14:15:49 source > Caught retryable error after 2 tries. Waiting 10 more seconds then retrying... 2022-11-03 14:15:49 source > Backing off call(...) for 20.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17897537821166464/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AG-N-ehI1g0NXA5a9W18IzI" } }) 2022-11-03 14:16:09 source > Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17897537821166464/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AG-N-ehI1g0NXA5a9W18IzI" } } 2022-11-03 14:16:09 source > Caught retryable error after 3 tries. Waiting 20 more seconds then retrying... 2022-11-03 14:16:09 source > Backing off call(...) for 40.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17897537821166464/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AJBdKtP83Mrx3yyc2BZI71s" } }) 2022-11-03 14:16:49 source > Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17897537821166464/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AJBdKtP83Mrx3yyc2BZI71s" } } 2022-11-03 14:16:49 source > Caught retryable error after 4 tries. Waiting 40 more seconds then retrying... 2022-11-03 14:16:49 source > Backing off call(...) for 80.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17897537821166464/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AJEVayB5GYPqGX2Vwrrfpka" } }) 2022-11-03 14:18:09 source > Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17897537821166464/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AJEVayB5GYPqGX2Vwrrfpka" } } 2022-11-03 14:18:09 source > Caught retryable error after 5 tries. Waiting 80 more seconds then retrying... 2022-11-03 14:18:09 source > Backing off call(...) for 160.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17897537821166464/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AelIk4vAwX8xPnEv5Phsgbd" } }) 2022-11-03 14:20:50 source > Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17897537821166464/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AelIk4vAwX8xPnEv5Phsgbd" } } 2022-11-03 14:20:50 source > Caught retryable error after 6 tries. Waiting 160 more seconds then retrying... 2022-11-03 14:20:50 source > Giving up call(...) after 7 tries (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17897537821166464/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AmbPmAoxU6uwJyAK8rUPW70" } }) 2022-11-03 14:20:50 source > Insights error for business_account_id 17841401993121167: Media posted before business account conversion 2022-11-03 14:20:50 source > Read 3003 records from media_insights stream 2022-11-03 14:20:50 source > Finished syncing media_insights 2022-11-03 14:20:50 source > SourceInstagram runtimes: Syncing stream media 0:03:48.043881 Syncing stream media_insights 0:45:31.955155 2022-11-03 14:20:50 source > Syncing stream: stories 2022-11-03 14:20:52 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:20:52 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:20:52 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:20:52 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:20:52 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:20:52 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:20:52 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:20:52 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:20:52 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:20:52 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:20:52 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:20:52 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:20:52 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:20:52 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:20:52 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:20:52 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:20:52 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:20:52 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:20:52 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:20:52 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:20:52 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:20:52 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:20:52 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:20:52 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:20:52 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:20:52 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:20:52 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:20:52 source > Read 9 records from stories stream 2022-11-03 14:20:52 source > Finished syncing stories 2022-11-03 14:20:52 source > SourceInstagram runtimes: Syncing stream media 0:03:48.043881 Syncing stream media_insights 0:45:31.955155 Syncing stream stories 0:00:01.863602 2022-11-03 14:20:52 source > Syncing stream: story_insights 2022-11-03 14:20:59 source > Read 9 records from story_insights stream 2022-11-03 14:20:59 source > Finished syncing story_insights 2022-11-03 14:20:59 source > SourceInstagram runtimes: Syncing stream media 0:03:48.043881 Syncing stream media_insights 0:45:31.955155 Syncing stream stories 0:00:01.863602 Syncing stream story_insights 0:00:06.857616 2022-11-03 14:20:59 source > Syncing stream: user_insights 2022-11-03 14:20:59 source > Reading insights between 2022-11-03 and 2022-11-04 2022-11-03 14:21:02 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:21:02 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:21:02 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:21:02 source > Reading insights between 2022-11-03 and 2022-11-04 2022-11-03 14:21:04 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:21:04 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:21:04 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:21:04 source > Reading insights between 2022-11-03 and 2022-11-04 2022-11-03 14:21:06 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:21:06 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:21:06 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:21:06 source > Reading insights between 2022-11-03 and 2022-11-04 2022-11-03 14:21:08 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:21:08 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:21:08 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:21:08 source > Reading insights between 2022-11-03 and 2022-11-04 2022-11-03 14:21:09 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:21:09 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:21:09 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:21:09 source > Reading insights between 2022-11-03 and 2022-11-04 2022-11-03 14:21:11 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:21:11 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:21:11 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:21:11 source > Reading insights between 2022-11-03 and 2022-11-04 2022-11-03 14:21:12 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:21:12 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:21:12 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:21:12 source > Reading insights between 2022-11-03 and 2022-11-04 2022-11-03 14:21:12 INFO i.a.w.g.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$7):464 - State in DefaultReplicationWorker from destination: io.airbyte.protocol.models.AirbyteMessage@5da7339c[type=STATE,log=,spec=,connectionStatus=,catalog=,record=,state=io.airbyte.protocol.models.AirbyteStateMessage@5360c658[type=STREAM,stream=io.airbyte.protocol.models.AirbyteStreamState@575f58ec[streamDescriptor=io.airbyte.protocol.models.StreamDescriptor@125dcc63[name=user_insights,namespace=,additionalProperties={}],streamState={"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}},additionalProperties={}],global=,data={"user_insights":{"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}}},additionalProperties={}],trace=,additionalProperties={}] 2022-11-03 14:21:12 INFO i.a.w.g.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$7):464 - State in DefaultReplicationWorker from destination: io.airbyte.protocol.models.AirbyteMessage@76023667[type=STATE,log=,spec=,connectionStatus=,catalog=,record=,state=io.airbyte.protocol.models.AirbyteStateMessage@23857cf9[type=STREAM,stream=io.airbyte.protocol.models.AirbyteStreamState@e30d85d[streamDescriptor=io.airbyte.protocol.models.StreamDescriptor@7272332c[name=user_insights,namespace=,additionalProperties={}],streamState={"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}},additionalProperties={}],global=,data={"user_insights":{"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}}},additionalProperties={}],trace=,additionalProperties={}] 2022-11-03 14:21:12 WARN i.a.w.i.AirbyteMessageTracker(handleDestinationEmittedState):196 - The message tracker encountered an issue that prevents committed record counts from being reliably computed. 2022-11-03 14:21:12 WARN i.a.w.i.AirbyteMessageTracker(handleDestinationEmittedState):197 - This only impacts metadata and does not indicate a problem with actual sync data. 2022-11-03 14:21:12 WARN i.a.w.i.AirbyteMessageTracker(handleDestinationEmittedState):198 - State hash 2047215398 was already committed, likely indicating a state hash collision io.airbyte.workers.internal.StateDeltaTracker$StateDeltaTrackerException: State hash 2047215398 was already committed, likely indicating a state hash collision at io.airbyte.workers.internal.StateDeltaTracker.commitStateHash(StateDeltaTracker.java:114) ~[io.airbyte-airbyte-commons-worker-0.40.16.jar:?] at io.airbyte.workers.internal.AirbyteMessageTracker.handleDestinationEmittedState(AirbyteMessageTracker.java:193) ~[io.airbyte-airbyte-commons-worker-0.40.16.jar:?] at io.airbyte.workers.internal.AirbyteMessageTracker.acceptFromDestination(AirbyteMessageTracker.java:119) ~[io.airbyte-airbyte-commons-worker-0.40.16.jar:?] at io.airbyte.workers.general.DefaultReplicationWorker.lambda$getDestinationOutputRunnable$7(DefaultReplicationWorker.java:465) ~[io.airbyte-airbyte-commons-worker-0.40.16.jar:?] at java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1804) ~[?:?] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) ~[?:?] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) ~[?:?] at java.lang.Thread.run(Thread.java:1589) ~[?:?] 2022-11-03 14:21:14 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:21:14 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:21:14 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:21:14 source > Reading insights between 2022-11-03 and 2022-11-04 2022-11-03 14:21:16 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:21:16 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:21:16 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:21:16 source > Reading insights between 2022-11-03 and 2022-11-04 2022-11-03 14:21:18 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:21:18 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:21:18 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:21:18 source > Read 10 records from user_insights stream 2022-11-03 14:21:18 source > Finished syncing user_insights 2022-11-03 14:21:18 source > SourceInstagram runtimes: Syncing stream media 0:03:48.043881 Syncing stream media_insights 0:45:31.955155 Syncing stream stories 0:00:01.863602 Syncing stream story_insights 0:00:06.857616 Syncing stream user_insights 0:00:19.162522 2022-11-03 14:21:18 source > Syncing stream: user_lifetime_insights 2022-11-03 14:21:18 source > /usr/local/lib/python3.9/site-packages/facebook_business/utils/api_utils.py:30: UserWarning: value of period might not be compatible. Expect list; got 2022-11-03 14:21:18 source > warnings.warn(message) 2022-11-03 14:21:18 source > Encountered an exception while reading stream user_lifetime_insights Traceback (most recent call last): File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py", line 113, in read yield from self._read_stream( File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py", line 182, in _read_stream for record in record_iterator: File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py", line 285, in _read_full_refresh for record in records: File "/airbyte/integration_code/source_instagram/streams.py", line 124, in read_records "date": insight["values"][0]["end_time"], KeyError: 'end_time' 2022-11-03 14:21:18 source > Finished syncing user_lifetime_insights 2022-11-03 14:21:18 source > SourceInstagram runtimes: Syncing stream media 0:03:48.043881 Syncing stream media_insights 0:45:31.955155 Syncing stream stories 0:00:01.863602 Syncing stream story_insights 0:00:06.857616 Syncing stream user_insights 0:00:19.162522 Syncing stream user_lifetime_insights 0:00:00.404483 2022-11-03 14:21:18 source > 'end_time' Traceback (most recent call last): File "/airbyte/integration_code/main.py", line 13, in launch(source, sys.argv[1:]) File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/entrypoint.py", line 123, in launch for message in source_entrypoint.run(parsed_args): File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/entrypoint.py", line 114, in run for message in generator: File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py", line 127, in read raise e File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py", line 113, in read yield from self._read_stream( File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py", line 182, in _read_stream for record in record_iterator: File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py", line 285, in _read_full_refresh for record in records: File "/airbyte/integration_code/source_instagram/streams.py", line 124, in read_records "date": insight["values"][0]["end_time"], KeyError: 'end_time' 2022-11-03 14:21:18 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):372 - Source has no more messages, closing connection. 2022-11-03 14:21:18 INFO i.a.w.g.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$7):464 - State in DefaultReplicationWorker from destination: io.airbyte.protocol.models.AirbyteMessage@1524820b[type=STATE,log=,spec=,connectionStatus=,catalog=,record=,state=io.airbyte.protocol.models.AirbyteStateMessage@1d4e46e2[type=STREAM,stream=io.airbyte.protocol.models.AirbyteStreamState@15349726[streamDescriptor=io.airbyte.protocol.models.StreamDescriptor@763c2dff[name=user_insights,namespace=,additionalProperties={}],streamState={"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}},additionalProperties={}],global=,data={"user_insights":{"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}}},additionalProperties={}],trace=,additionalProperties={}] 2022-11-03 14:21:18 INFO i.a.w.g.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$7):464 - State in DefaultReplicationWorker from destination: io.airbyte.protocol.models.AirbyteMessage@47b9dde9[type=STATE,log=,spec=,connectionStatus=,catalog=,record=,state=io.airbyte.protocol.models.AirbyteStateMessage@282ffaaa[type=STREAM,stream=io.airbyte.protocol.models.AirbyteStreamState@1913c52e[streamDescriptor=io.airbyte.protocol.models.StreamDescriptor@e574026[name=user_insights,namespace=,additionalProperties={}],streamState={"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}},additionalProperties={}],global=,data={"user_insights":{"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}}},additionalProperties={}],trace=,additionalProperties={}] 2022-11-03 14:21:18 INFO i.a.w.g.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$7):464 - State in DefaultReplicationWorker from destination: io.airbyte.protocol.models.AirbyteMessage@7888290[type=STATE,log=,spec=,connectionStatus=,catalog=,record=,state=io.airbyte.protocol.models.AirbyteStateMessage@50a5c261[type=STREAM,stream=io.airbyte.protocol.models.AirbyteStreamState@571847ee[streamDescriptor=io.airbyte.protocol.models.StreamDescriptor@63fa7b5b[name=user_insights,namespace=,additionalProperties={}],streamState={"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}},additionalProperties={}],global=,data={"user_insights":{"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}}},additionalProperties={}],trace=,additionalProperties={}] 2022-11-03 14:21:18 INFO i.a.w.g.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$7):464 - State in DefaultReplicationWorker from destination: io.airbyte.protocol.models.AirbyteMessage@20a5e9b6[type=STATE,log=,spec=,connectionStatus=,catalog=,record=,state=io.airbyte.protocol.models.AirbyteStateMessage@5e6d8109[type=STREAM,stream=io.airbyte.protocol.models.AirbyteStreamState@4b5f8a1d[streamDescriptor=io.airbyte.protocol.models.StreamDescriptor@7bcf108e[name=user_insights,namespace=,additionalProperties={}],streamState={"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}},additionalProperties={}],global=,data={"user_insights":{"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}}},additionalProperties={}],trace=,additionalProperties={}] 2022-11-03 14:21:18 INFO i.a.w.g.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$7):464 - State in DefaultReplicationWorker from destination: io.airbyte.protocol.models.AirbyteMessage@74a8ae18[type=STATE,log=,spec=,connectionStatus=,catalog=,record=,state=io.airbyte.protocol.models.AirbyteStateMessage@467f1c4d[type=STREAM,stream=io.airbyte.protocol.models.AirbyteStreamState@714779fd[streamDescriptor=io.airbyte.protocol.models.StreamDescriptor@720f5c3b[name=user_insights,namespace=,additionalProperties={}],streamState={"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}},additionalProperties={}],global=,data={"user_insights":{"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}}},additionalProperties={}],trace=,additionalProperties={}] 2022-11-03 14:21:18 INFO i.a.w.g.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$7):464 - State in DefaultReplicationWorker from destination: io.airbyte.protocol.models.AirbyteMessage@4366e40c[type=STATE,log=,spec=,connectionStatus=,catalog=,record=,state=io.airbyte.protocol.models.AirbyteStateMessage@7d451559[type=STREAM,stream=io.airbyte.protocol.models.AirbyteStreamState@3787039d[streamDescriptor=io.airbyte.protocol.models.StreamDescriptor@3f616fd2[name=user_insights,namespace=,additionalProperties={}],streamState={"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}},additionalProperties={}],global=,data={"user_insights":{"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}}},additionalProperties={}],trace=,additionalProperties={}] 2022-11-03 14:21:18 INFO i.a.w.g.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$7):464 - State in DefaultReplicationWorker from destination: io.airbyte.protocol.models.AirbyteMessage@4bd3aab6[type=STATE,log=,spec=,connectionStatus=,catalog=,record=,state=io.airbyte.protocol.models.AirbyteStateMessage@1e698148[type=STREAM,stream=io.airbyte.protocol.models.AirbyteStreamState@11fde2f3[streamDescriptor=io.airbyte.protocol.models.StreamDescriptor@25d610e1[name=user_insights,namespace=,additionalProperties={}],streamState={"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}},additionalProperties={}],global=,data={"user_insights":{"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}}},additionalProperties={}],trace=,additionalProperties={}] 2022-11-03 14:21:18 INFO i.a.w.g.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$7):464 - State in DefaultReplicationWorker from destination: io.airbyte.protocol.models.AirbyteMessage@730698f7[type=STATE,log=,spec=,connectionStatus=,catalog=,record=,state=io.airbyte.protocol.models.AirbyteStateMessage@21b7241e[type=STREAM,stream=io.airbyte.protocol.models.AirbyteStreamState@5f23b0a1[streamDescriptor=io.airbyte.protocol.models.StreamDescriptor@4a67f2bc[name=user_insights,namespace=,additionalProperties={}],streamState={"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}},additionalProperties={}],global=,data={"user_insights":{"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}}},additionalProperties={}],trace=,additionalProperties={}] 2022-11-03 14:21:18 destination > Airbyte message consumer: succeeded. 2022-11-03 14:21:18 destination > Started closing all connections 2022-11-03 14:21:19 destination > Closing connector: AbstractBigQueryUploader{table=_airbyte_raw_instagram_story_insights, tmpTable=_airbyte_tmp_gmb_instagram_story_insights, syncMode=WRITE_TRUNCATE, writer=class io.airbyte.integrations.destination.bigquery.writer.BigQueryTableWriter, recordFormatter=class io.airbyte.integrations.destination.bigquery.formatter.DefaultBigQueryRecordFormatter} 2022-11-03 14:21:19 destination > Waiting for job finish Job{job=JobId{project=spg-misc-data, job=cf5298b8-c5f8-462b-83b6-83d506e8bcbb, location=europe-north1}, status=JobStatus{state=RUNNING, error=null, executionErrors=null}, statistics=LoadStatistics{creationTime=1667485279391, endTime=null, startTime=1667485279598, numChildJobs=null, parentJobId=null, scriptStatistics=null, reservationUsage=null, inputBytes=null, inputFiles=null, outputBytes=null, outputRows=null, badRecords=null}, userEmail=spg-misc-service@spg-misc-data.iam.gserviceaccount.com, etag=nMYBKjMg1nXIcjQwxVifyQ==, generatedId=spg-misc-data:europe-north1.cf5298b8-c5f8-462b-83b6-83d506e8bcbb, selfLink=https://www.googleapis.com/bigquery/v2/projects/spg-misc-data/jobs/cf5298b8-c5f8-462b-83b6-83d506e8bcbb?location=europe-north1, configuration=LoadJobConfiguration{type=LOAD, destinationTable=GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, projectId=spg-misc-data, tableId=_airbyte_tmp_gmb_instagram_story_insights}}, decimalTargetTypes=null, destinationEncryptionConfiguration=null, createDisposition=CREATE_IF_NEEDED, writeDisposition=null, formatOptions=FormatOptions{format=NEWLINE_DELIMITED_JSON}, nullMarker=null, maxBadRecords=null, schema=Schema{fields=[Field{name=_airbyte_ab_id, type=STRING, mode=null, description=null, policyTags=null}, Field{name=_airbyte_emitted_at, type=TIMESTAMP, mode=null, description=null, policyTags=null}, Field{name=_airbyte_data, type=STRING, mode=null, description=null, policyTags=null}]}, ignoreUnknownValue=null, sourceUris=null, schemaUpdateOptions=null, autodetect=null, timePartitioning=null, clustering=null, useAvroLogicalTypes=null, labels=null, jobTimeoutMs=null, rangePartitioning=null, hivePartitioningOptions=null}}. Status: JobStatus{state=RUNNING, error=null, executionErrors=null} 2022-11-03 14:21:23 destination > Job finish Job{job=JobId{project=spg-misc-data, job=cf5298b8-c5f8-462b-83b6-83d506e8bcbb, location=europe-north1}, status=JobStatus{state=RUNNING, error=null, executionErrors=null}, statistics=LoadStatistics{creationTime=1667485279391, endTime=null, startTime=1667485279598, numChildJobs=null, parentJobId=null, scriptStatistics=null, reservationUsage=null, inputBytes=null, inputFiles=null, outputBytes=null, outputRows=null, badRecords=null}, userEmail=spg-misc-service@spg-misc-data.iam.gserviceaccount.com, etag=nMYBKjMg1nXIcjQwxVifyQ==, generatedId=spg-misc-data:europe-north1.cf5298b8-c5f8-462b-83b6-83d506e8bcbb, selfLink=https://www.googleapis.com/bigquery/v2/projects/spg-misc-data/jobs/cf5298b8-c5f8-462b-83b6-83d506e8bcbb?location=europe-north1, configuration=LoadJobConfiguration{type=LOAD, destinationTable=GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, projectId=spg-misc-data, tableId=_airbyte_tmp_gmb_instagram_story_insights}}, decimalTargetTypes=null, destinationEncryptionConfiguration=null, createDisposition=CREATE_IF_NEEDED, writeDisposition=null, formatOptions=FormatOptions{format=NEWLINE_DELIMITED_JSON}, nullMarker=null, maxBadRecords=null, schema=Schema{fields=[Field{name=_airbyte_ab_id, type=STRING, mode=null, description=null, policyTags=null}, Field{name=_airbyte_emitted_at, type=TIMESTAMP, mode=null, description=null, policyTags=null}, Field{name=_airbyte_data, type=STRING, mode=null, description=null, policyTags=null}]}, ignoreUnknownValue=null, sourceUris=null, schemaUpdateOptions=null, autodetect=null, timePartitioning=null, clustering=null, useAvroLogicalTypes=null, labels=null, jobTimeoutMs=null, rangePartitioning=null, hivePartitioningOptions=null}} with status JobStatus{state=RUNNING, error=null, executionErrors=null} 2022-11-03 14:21:23 destination > Uploading data from the tmp table _airbyte_tmp_gmb_instagram_story_insights to the source table _airbyte_raw_instagram_story_insights. 2022-11-03 14:21:23 destination > Replication finished with no explicit errors. Copying data from tmp tables to permanent 2022-11-03 14:21:27 destination > successfully copied table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, tableId=_airbyte_tmp_gmb_instagram_story_insights}} to table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, tableId=_airbyte_raw_instagram_story_insights}} 2022-11-03 14:21:27 destination > Data is successfully loaded to the source table _airbyte_raw_instagram_story_insights! 2022-11-03 14:21:27 INFO i.a.w.g.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$7):464 - State in DefaultReplicationWorker from destination: io.airbyte.protocol.models.AirbyteMessage@d611a27[type=STATE,log=,spec=,connectionStatus=,catalog=,record=,state=io.airbyte.protocol.models.AirbyteStateMessage@156e4841[type=STREAM,stream=io.airbyte.protocol.models.AirbyteStreamState@578a54f5[streamDescriptor=io.airbyte.protocol.models.StreamDescriptor@220dbeaa[name=user_insights,namespace=,additionalProperties={}],streamState={"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}},additionalProperties={}],global=,data={"user_insights":{"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}}},additionalProperties={}],trace=,additionalProperties={}] 2022-11-03 14:21:27 WARN i.a.w.i.AirbyteMessageTracker(handleDestinationEmittedState):207 - The state message tracker was unable to match the destination state message to a corresponding source state message. 2022-11-03 14:21:27 WARN i.a.w.i.AirbyteMessageTracker(handleDestinationEmittedState):208 - This only impacts metrics and does not indicate a problem with actual sync data. 2022-11-03 14:21:27 WARN i.a.w.i.AirbyteMessageTracker(handleDestinationEmittedState):209 - Destination state message cannot be matched to corresponding Source state message. io.airbyte.workers.internal.StateMetricsTracker$StateMetricsTrackerNoStateMatchException: Destination state message cannot be matched to corresponding Source state message. at io.airbyte.workers.internal.StateMetricsTracker.findStartingTimeStampAndRemoveOlderEntries(StateMetricsTracker.java:147) ~[io.airbyte-airbyte-commons-worker-0.40.16.jar:?] at io.airbyte.workers.internal.StateMetricsTracker.updateStates(StateMetricsTracker.java:80) ~[io.airbyte-airbyte-commons-worker-0.40.16.jar:?] at io.airbyte.workers.internal.AirbyteMessageTracker.handleDestinationEmittedState(AirbyteMessageTracker.java:204) ~[io.airbyte-airbyte-commons-worker-0.40.16.jar:?] at io.airbyte.workers.internal.AirbyteMessageTracker.acceptFromDestination(AirbyteMessageTracker.java:119) ~[io.airbyte-airbyte-commons-worker-0.40.16.jar:?] at io.airbyte.workers.general.DefaultReplicationWorker.lambda$getDestinationOutputRunnable$7(DefaultReplicationWorker.java:465) ~[io.airbyte-airbyte-commons-worker-0.40.16.jar:?] at java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1804) ~[?:?] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) ~[?:?] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) ~[?:?] at java.lang.Thread.run(Thread.java:1589) ~[?:?] 2022-11-03 14:21:27 destination > Final state message is accepted. 2022-11-03 14:21:27 destination > Removing tmp tables... 2022-11-03 14:21:27 destination > Finishing destination process...completed 2022-11-03 14:21:27 destination > Closed connector: AbstractBigQueryUploader{table=_airbyte_raw_instagram_story_insights, tmpTable=_airbyte_tmp_gmb_instagram_story_insights, syncMode=WRITE_TRUNCATE, writer=class io.airbyte.integrations.destination.bigquery.writer.BigQueryTableWriter, recordFormatter=class io.airbyte.integrations.destination.bigquery.formatter.DefaultBigQueryRecordFormatter} 2022-11-03 14:21:27 destination > Closing connector: AbstractBigQueryUploader{table=_airbyte_raw_instagram_users, tmpTable=_airbyte_tmp_fxh_instagram_users, syncMode=WRITE_TRUNCATE, writer=class io.airbyte.integrations.destination.bigquery.writer.BigQueryTableWriter, recordFormatter=class io.airbyte.integrations.destination.bigquery.formatter.DefaultBigQueryRecordFormatter} 2022-11-03 14:21:27 destination > Uploading data from the tmp table _airbyte_tmp_fxh_instagram_users to the source table _airbyte_raw_instagram_users. 2022-11-03 14:21:27 destination > Replication finished with no explicit errors. Copying data from tmp tables to permanent 2022-11-03 14:21:27 destination > successfully copied table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, tableId=_airbyte_tmp_fxh_instagram_users}} to table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, tableId=_airbyte_raw_instagram_users}} 2022-11-03 14:21:27 destination > Data is successfully loaded to the source table _airbyte_raw_instagram_users! 2022-11-03 14:21:27 INFO i.a.w.g.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$7):464 - State in DefaultReplicationWorker from destination: io.airbyte.protocol.models.AirbyteMessage@273828ee[type=STATE,log=,spec=,connectionStatus=,catalog=,record=,state=io.airbyte.protocol.models.AirbyteStateMessage@40735008[type=STREAM,stream=io.airbyte.protocol.models.AirbyteStreamState@455b990f[streamDescriptor=io.airbyte.protocol.models.StreamDescriptor@aec97e0[name=user_insights,namespace=,additionalProperties={}],streamState={"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}},additionalProperties={}],global=,data={"user_insights":{"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}}},additionalProperties={}],trace=,additionalProperties={}] 2022-11-03 14:21:27 destination > Final state message is accepted. 2022-11-03 14:21:27 destination > Removing tmp tables... 2022-11-03 14:21:27 destination > Finishing destination process...completed 2022-11-03 14:21:27 destination > Closed connector: AbstractBigQueryUploader{table=_airbyte_raw_instagram_users, tmpTable=_airbyte_tmp_fxh_instagram_users, syncMode=WRITE_TRUNCATE, writer=class io.airbyte.integrations.destination.bigquery.writer.BigQueryTableWriter, recordFormatter=class io.airbyte.integrations.destination.bigquery.formatter.DefaultBigQueryRecordFormatter} 2022-11-03 14:21:27 destination > Closing connector: AbstractBigQueryUploader{table=_airbyte_raw_instagram_stories, tmpTable=_airbyte_tmp_izy_instagram_stories, syncMode=WRITE_TRUNCATE, writer=class io.airbyte.integrations.destination.bigquery.writer.BigQueryTableWriter, recordFormatter=class io.airbyte.integrations.destination.bigquery.formatter.DefaultBigQueryRecordFormatter} 2022-11-03 14:21:28 destination > Waiting for job finish Job{job=JobId{project=spg-misc-data, job=55e21d8c-8f5d-4885-a039-ae298f1d8201, location=europe-north1}, status=JobStatus{state=RUNNING, error=null, executionErrors=null}, statistics=LoadStatistics{creationTime=1667485288017, endTime=null, startTime=1667485288186, numChildJobs=null, parentJobId=null, scriptStatistics=null, reservationUsage=null, inputBytes=null, inputFiles=null, outputBytes=null, outputRows=null, badRecords=null}, userEmail=spg-misc-service@spg-misc-data.iam.gserviceaccount.com, etag=fvVwqLcpV0zjQ25SfkHj1Q==, generatedId=spg-misc-data:europe-north1.55e21d8c-8f5d-4885-a039-ae298f1d8201, selfLink=https://www.googleapis.com/bigquery/v2/projects/spg-misc-data/jobs/55e21d8c-8f5d-4885-a039-ae298f1d8201?location=europe-north1, configuration=LoadJobConfiguration{type=LOAD, destinationTable=GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, projectId=spg-misc-data, tableId=_airbyte_tmp_izy_instagram_stories}}, decimalTargetTypes=null, destinationEncryptionConfiguration=null, createDisposition=CREATE_IF_NEEDED, writeDisposition=null, formatOptions=FormatOptions{format=NEWLINE_DELIMITED_JSON}, nullMarker=null, maxBadRecords=null, schema=Schema{fields=[Field{name=_airbyte_ab_id, type=STRING, mode=null, description=null, policyTags=null}, Field{name=_airbyte_emitted_at, type=TIMESTAMP, mode=null, description=null, policyTags=null}, Field{name=_airbyte_data, type=STRING, mode=null, description=null, policyTags=null}]}, ignoreUnknownValue=null, sourceUris=null, schemaUpdateOptions=null, autodetect=null, timePartitioning=null, clustering=null, useAvroLogicalTypes=null, labels=null, jobTimeoutMs=null, rangePartitioning=null, hivePartitioningOptions=null}}. Status: JobStatus{state=RUNNING, error=null, executionErrors=null} 2022-11-03 14:21:30 destination > Job finish Job{job=JobId{project=spg-misc-data, job=55e21d8c-8f5d-4885-a039-ae298f1d8201, location=europe-north1}, status=JobStatus{state=RUNNING, error=null, executionErrors=null}, statistics=LoadStatistics{creationTime=1667485288017, endTime=null, startTime=1667485288186, numChildJobs=null, parentJobId=null, scriptStatistics=null, reservationUsage=null, inputBytes=null, inputFiles=null, outputBytes=null, outputRows=null, badRecords=null}, userEmail=spg-misc-service@spg-misc-data.iam.gserviceaccount.com, etag=fvVwqLcpV0zjQ25SfkHj1Q==, generatedId=spg-misc-data:europe-north1.55e21d8c-8f5d-4885-a039-ae298f1d8201, selfLink=https://www.googleapis.com/bigquery/v2/projects/spg-misc-data/jobs/55e21d8c-8f5d-4885-a039-ae298f1d8201?location=europe-north1, configuration=LoadJobConfiguration{type=LOAD, destinationTable=GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, projectId=spg-misc-data, tableId=_airbyte_tmp_izy_instagram_stories}}, decimalTargetTypes=null, destinationEncryptionConfiguration=null, createDisposition=CREATE_IF_NEEDED, writeDisposition=null, formatOptions=FormatOptions{format=NEWLINE_DELIMITED_JSON}, nullMarker=null, maxBadRecords=null, schema=Schema{fields=[Field{name=_airbyte_ab_id, type=STRING, mode=null, description=null, policyTags=null}, Field{name=_airbyte_emitted_at, type=TIMESTAMP, mode=null, description=null, policyTags=null}, Field{name=_airbyte_data, type=STRING, mode=null, description=null, policyTags=null}]}, ignoreUnknownValue=null, sourceUris=null, schemaUpdateOptions=null, autodetect=null, timePartitioning=null, clustering=null, useAvroLogicalTypes=null, labels=null, jobTimeoutMs=null, rangePartitioning=null, hivePartitioningOptions=null}} with status JobStatus{state=RUNNING, error=null, executionErrors=null} 2022-11-03 14:21:30 destination > Uploading data from the tmp table _airbyte_tmp_izy_instagram_stories to the source table _airbyte_raw_instagram_stories. 2022-11-03 14:21:30 destination > Replication finished with no explicit errors. Copying data from tmp tables to permanent 2022-11-03 14:21:31 destination > successfully copied table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, tableId=_airbyte_tmp_izy_instagram_stories}} to table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, tableId=_airbyte_raw_instagram_stories}} 2022-11-03 14:21:31 destination > Data is successfully loaded to the source table _airbyte_raw_instagram_stories! 2022-11-03 14:21:31 INFO i.a.w.g.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$7):464 - State in DefaultReplicationWorker from destination: io.airbyte.protocol.models.AirbyteMessage@6cf5a10b[type=STATE,log=,spec=,connectionStatus=,catalog=,record=,state=io.airbyte.protocol.models.AirbyteStateMessage@365c5f8d[type=STREAM,stream=io.airbyte.protocol.models.AirbyteStreamState@2fd63ba8[streamDescriptor=io.airbyte.protocol.models.StreamDescriptor@416bea25[name=user_insights,namespace=,additionalProperties={}],streamState={"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}},additionalProperties={}],global=,data={"user_insights":{"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}}},additionalProperties={}],trace=,additionalProperties={}] 2022-11-03 14:21:31 destination > Final state message is accepted. 2022-11-03 14:21:31 destination > Removing tmp tables... 2022-11-03 14:21:31 destination > Finishing destination process...completed 2022-11-03 14:21:31 destination > Closed connector: AbstractBigQueryUploader{table=_airbyte_raw_instagram_stories, tmpTable=_airbyte_tmp_izy_instagram_stories, syncMode=WRITE_TRUNCATE, writer=class io.airbyte.integrations.destination.bigquery.writer.BigQueryTableWriter, recordFormatter=class io.airbyte.integrations.destination.bigquery.formatter.DefaultBigQueryRecordFormatter} 2022-11-03 14:21:31 destination > Closing connector: AbstractBigQueryUploader{table=_airbyte_raw_instagram_media, tmpTable=_airbyte_tmp_lgl_instagram_media, syncMode=WRITE_TRUNCATE, writer=class io.airbyte.integrations.destination.bigquery.writer.BigQueryTableWriter, recordFormatter=class io.airbyte.integrations.destination.bigquery.formatter.DefaultBigQueryRecordFormatter} 2022-11-03 14:21:32 destination > Waiting for job finish Job{job=JobId{project=spg-misc-data, job=d2e08d4b-9dcb-47a6-b1e7-1714fd7c36a4, location=europe-north1}, status=JobStatus{state=RUNNING, error=null, executionErrors=null}, statistics=LoadStatistics{creationTime=1667485292602, endTime=null, startTime=1667485292769, numChildJobs=null, parentJobId=null, scriptStatistics=null, reservationUsage=null, inputBytes=null, inputFiles=null, outputBytes=null, outputRows=null, badRecords=null}, userEmail=spg-misc-service@spg-misc-data.iam.gserviceaccount.com, etag=IVyK2VEpgK/zw8CUyYuUgw==, generatedId=spg-misc-data:europe-north1.d2e08d4b-9dcb-47a6-b1e7-1714fd7c36a4, selfLink=https://www.googleapis.com/bigquery/v2/projects/spg-misc-data/jobs/d2e08d4b-9dcb-47a6-b1e7-1714fd7c36a4?location=europe-north1, configuration=LoadJobConfiguration{type=LOAD, destinationTable=GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, projectId=spg-misc-data, tableId=_airbyte_tmp_lgl_instagram_media}}, decimalTargetTypes=null, destinationEncryptionConfiguration=null, createDisposition=CREATE_IF_NEEDED, writeDisposition=null, formatOptions=FormatOptions{format=NEWLINE_DELIMITED_JSON}, nullMarker=null, maxBadRecords=null, schema=Schema{fields=[Field{name=_airbyte_ab_id, type=STRING, mode=null, description=null, policyTags=null}, Field{name=_airbyte_emitted_at, type=TIMESTAMP, mode=null, description=null, policyTags=null}, Field{name=_airbyte_data, type=STRING, mode=null, description=null, policyTags=null}]}, ignoreUnknownValue=null, sourceUris=null, schemaUpdateOptions=null, autodetect=null, timePartitioning=null, clustering=null, useAvroLogicalTypes=null, labels=null, jobTimeoutMs=null, rangePartitioning=null, hivePartitioningOptions=null}}. Status: JobStatus{state=RUNNING, error=null, executionErrors=null} 2022-11-03 14:21:35 destination > Job finish Job{job=JobId{project=spg-misc-data, job=d2e08d4b-9dcb-47a6-b1e7-1714fd7c36a4, location=europe-north1}, status=JobStatus{state=RUNNING, error=null, executionErrors=null}, statistics=LoadStatistics{creationTime=1667485292602, endTime=null, startTime=1667485292769, numChildJobs=null, parentJobId=null, scriptStatistics=null, reservationUsage=null, inputBytes=null, inputFiles=null, outputBytes=null, outputRows=null, badRecords=null}, userEmail=spg-misc-service@spg-misc-data.iam.gserviceaccount.com, etag=IVyK2VEpgK/zw8CUyYuUgw==, generatedId=spg-misc-data:europe-north1.d2e08d4b-9dcb-47a6-b1e7-1714fd7c36a4, selfLink=https://www.googleapis.com/bigquery/v2/projects/spg-misc-data/jobs/d2e08d4b-9dcb-47a6-b1e7-1714fd7c36a4?location=europe-north1, configuration=LoadJobConfiguration{type=LOAD, destinationTable=GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, projectId=spg-misc-data, tableId=_airbyte_tmp_lgl_instagram_media}}, decimalTargetTypes=null, destinationEncryptionConfiguration=null, createDisposition=CREATE_IF_NEEDED, writeDisposition=null, formatOptions=FormatOptions{format=NEWLINE_DELIMITED_JSON}, nullMarker=null, maxBadRecords=null, schema=Schema{fields=[Field{name=_airbyte_ab_id, type=STRING, mode=null, description=null, policyTags=null}, Field{name=_airbyte_emitted_at, type=TIMESTAMP, mode=null, description=null, policyTags=null}, Field{name=_airbyte_data, type=STRING, mode=null, description=null, policyTags=null}]}, ignoreUnknownValue=null, sourceUris=null, schemaUpdateOptions=null, autodetect=null, timePartitioning=null, clustering=null, useAvroLogicalTypes=null, labels=null, jobTimeoutMs=null, rangePartitioning=null, hivePartitioningOptions=null}} with status JobStatus{state=RUNNING, error=null, executionErrors=null} 2022-11-03 14:21:35 destination > Uploading data from the tmp table _airbyte_tmp_lgl_instagram_media to the source table _airbyte_raw_instagram_media. 2022-11-03 14:21:35 destination > Replication finished with no explicit errors. Copying data from tmp tables to permanent 2022-11-03 14:21:38 destination > successfully copied table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, tableId=_airbyte_tmp_lgl_instagram_media}} to table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, tableId=_airbyte_raw_instagram_media}} 2022-11-03 14:21:38 destination > Data is successfully loaded to the source table _airbyte_raw_instagram_media! 2022-11-03 14:21:38 INFO i.a.w.g.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$7):464 - State in DefaultReplicationWorker from destination: io.airbyte.protocol.models.AirbyteMessage@d7e6fa[type=STATE,log=,spec=,connectionStatus=,catalog=,record=,state=io.airbyte.protocol.models.AirbyteStateMessage@5423715a[type=STREAM,stream=io.airbyte.protocol.models.AirbyteStreamState@4a360b0d[streamDescriptor=io.airbyte.protocol.models.StreamDescriptor@5412faac[name=user_insights,namespace=,additionalProperties={}],streamState={"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}},additionalProperties={}],global=,data={"user_insights":{"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}}},additionalProperties={}],trace=,additionalProperties={}] 2022-11-03 14:21:38 destination > Final state message is accepted. 2022-11-03 14:21:38 destination > Removing tmp tables... 2022-11-03 14:21:38 destination > Finishing destination process...completed 2022-11-03 14:21:38 destination > Closed connector: AbstractBigQueryUploader{table=_airbyte_raw_instagram_media, tmpTable=_airbyte_tmp_lgl_instagram_media, syncMode=WRITE_TRUNCATE, writer=class io.airbyte.integrations.destination.bigquery.writer.BigQueryTableWriter, recordFormatter=class io.airbyte.integrations.destination.bigquery.formatter.DefaultBigQueryRecordFormatter} 2022-11-03 14:21:38 destination > Closing connector: AbstractBigQueryUploader{table=_airbyte_raw_instagram_user_lifetime_insights, tmpTable=_airbyte_tmp_kvd_instagram_user_lifetime_insights, syncMode=WRITE_APPEND, writer=class io.airbyte.integrations.destination.bigquery.writer.BigQueryTableWriter, recordFormatter=class io.airbyte.integrations.destination.bigquery.formatter.DefaultBigQueryRecordFormatter} 2022-11-03 14:21:38 destination > Uploading data from the tmp table _airbyte_tmp_kvd_instagram_user_lifetime_insights to the source table _airbyte_raw_instagram_user_lifetime_insights. 2022-11-03 14:21:38 destination > Replication finished with no explicit errors. Copying data from tmp tables to permanent 2022-11-03 14:21:41 destination > successfully copied table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, tableId=_airbyte_tmp_kvd_instagram_user_lifetime_insights}} to table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, tableId=_airbyte_raw_instagram_user_lifetime_insights}} 2022-11-03 14:21:41 destination > Data is successfully loaded to the source table _airbyte_raw_instagram_user_lifetime_insights! 2022-11-03 14:21:41 INFO i.a.w.g.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$7):464 - State in DefaultReplicationWorker from destination: io.airbyte.protocol.models.AirbyteMessage@6b4d26e2[type=STATE,log=,spec=,connectionStatus=,catalog=,record=,state=io.airbyte.protocol.models.AirbyteStateMessage@24ab3370[type=STREAM,stream=io.airbyte.protocol.models.AirbyteStreamState@5e3f2a8b[streamDescriptor=io.airbyte.protocol.models.StreamDescriptor@1d3b7c7a[name=user_insights,namespace=,additionalProperties={}],streamState={"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}},additionalProperties={}],global=,data={"user_insights":{"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}}},additionalProperties={}],trace=,additionalProperties={}] 2022-11-03 14:21:41 destination > Final state message is accepted. 2022-11-03 14:21:41 destination > Removing tmp tables... 2022-11-03 14:21:41 destination > Finishing destination process...completed 2022-11-03 14:21:41 destination > Closed connector: AbstractBigQueryUploader{table=_airbyte_raw_instagram_user_lifetime_insights, tmpTable=_airbyte_tmp_kvd_instagram_user_lifetime_insights, syncMode=WRITE_APPEND, writer=class io.airbyte.integrations.destination.bigquery.writer.BigQueryTableWriter, recordFormatter=class io.airbyte.integrations.destination.bigquery.formatter.DefaultBigQueryRecordFormatter} 2022-11-03 14:21:41 destination > Closing connector: AbstractBigQueryUploader{table=_airbyte_raw_instagram_media_insights, tmpTable=_airbyte_tmp_xot_instagram_media_insights, syncMode=WRITE_TRUNCATE, writer=class io.airbyte.integrations.destination.bigquery.writer.BigQueryTableWriter, recordFormatter=class io.airbyte.integrations.destination.bigquery.formatter.DefaultBigQueryRecordFormatter} 2022-11-03 14:21:42 destination > Waiting for job finish Job{job=JobId{project=spg-misc-data, job=ff2dfed2-95c8-4ea4-a3f6-472ee4c07550, location=europe-north1}, status=JobStatus{state=RUNNING, error=null, executionErrors=null}, statistics=LoadStatistics{creationTime=1667485301867, endTime=null, startTime=1667485302039, numChildJobs=null, parentJobId=null, scriptStatistics=null, reservationUsage=null, inputBytes=null, inputFiles=null, outputBytes=null, outputRows=null, badRecords=null}, userEmail=spg-misc-service@spg-misc-data.iam.gserviceaccount.com, etag=09mlsaxrku3QhkeDUHHUAw==, generatedId=spg-misc-data:europe-north1.ff2dfed2-95c8-4ea4-a3f6-472ee4c07550, selfLink=https://www.googleapis.com/bigquery/v2/projects/spg-misc-data/jobs/ff2dfed2-95c8-4ea4-a3f6-472ee4c07550?location=europe-north1, configuration=LoadJobConfiguration{type=LOAD, destinationTable=GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, projectId=spg-misc-data, tableId=_airbyte_tmp_xot_instagram_media_insights}}, decimalTargetTypes=null, destinationEncryptionConfiguration=null, createDisposition=CREATE_IF_NEEDED, writeDisposition=null, formatOptions=FormatOptions{format=NEWLINE_DELIMITED_JSON}, nullMarker=null, maxBadRecords=null, schema=Schema{fields=[Field{name=_airbyte_ab_id, type=STRING, mode=null, description=null, policyTags=null}, Field{name=_airbyte_emitted_at, type=TIMESTAMP, mode=null, description=null, policyTags=null}, Field{name=_airbyte_data, type=STRING, mode=null, description=null, policyTags=null}]}, ignoreUnknownValue=null, sourceUris=null, schemaUpdateOptions=null, autodetect=null, timePartitioning=null, clustering=null, useAvroLogicalTypes=null, labels=null, jobTimeoutMs=null, rangePartitioning=null, hivePartitioningOptions=null}}. Status: JobStatus{state=RUNNING, error=null, executionErrors=null} 2022-11-03 14:21:44 destination > Job finish Job{job=JobId{project=spg-misc-data, job=ff2dfed2-95c8-4ea4-a3f6-472ee4c07550, location=europe-north1}, status=JobStatus{state=RUNNING, error=null, executionErrors=null}, statistics=LoadStatistics{creationTime=1667485301867, endTime=null, startTime=1667485302039, numChildJobs=null, parentJobId=null, scriptStatistics=null, reservationUsage=null, inputBytes=null, inputFiles=null, outputBytes=null, outputRows=null, badRecords=null}, userEmail=spg-misc-service@spg-misc-data.iam.gserviceaccount.com, etag=09mlsaxrku3QhkeDUHHUAw==, generatedId=spg-misc-data:europe-north1.ff2dfed2-95c8-4ea4-a3f6-472ee4c07550, selfLink=https://www.googleapis.com/bigquery/v2/projects/spg-misc-data/jobs/ff2dfed2-95c8-4ea4-a3f6-472ee4c07550?location=europe-north1, configuration=LoadJobConfiguration{type=LOAD, destinationTable=GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, projectId=spg-misc-data, tableId=_airbyte_tmp_xot_instagram_media_insights}}, decimalTargetTypes=null, destinationEncryptionConfiguration=null, createDisposition=CREATE_IF_NEEDED, writeDisposition=null, formatOptions=FormatOptions{format=NEWLINE_DELIMITED_JSON}, nullMarker=null, maxBadRecords=null, schema=Schema{fields=[Field{name=_airbyte_ab_id, type=STRING, mode=null, description=null, policyTags=null}, Field{name=_airbyte_emitted_at, type=TIMESTAMP, mode=null, description=null, policyTags=null}, Field{name=_airbyte_data, type=STRING, mode=null, description=null, policyTags=null}]}, ignoreUnknownValue=null, sourceUris=null, schemaUpdateOptions=null, autodetect=null, timePartitioning=null, clustering=null, useAvroLogicalTypes=null, labels=null, jobTimeoutMs=null, rangePartitioning=null, hivePartitioningOptions=null}} with status JobStatus{state=RUNNING, error=null, executionErrors=null} 2022-11-03 14:21:44 destination > Uploading data from the tmp table _airbyte_tmp_xot_instagram_media_insights to the source table _airbyte_raw_instagram_media_insights. 2022-11-03 14:21:44 destination > Replication finished with no explicit errors. Copying data from tmp tables to permanent 2022-11-03 14:21:46 destination > successfully copied table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, tableId=_airbyte_tmp_xot_instagram_media_insights}} to table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, tableId=_airbyte_raw_instagram_media_insights}} 2022-11-03 14:21:46 destination > Data is successfully loaded to the source table _airbyte_raw_instagram_media_insights! 2022-11-03 14:21:46 INFO i.a.w.g.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$7):464 - State in DefaultReplicationWorker from destination: io.airbyte.protocol.models.AirbyteMessage@1fc32309[type=STATE,log=,spec=,connectionStatus=,catalog=,record=,state=io.airbyte.protocol.models.AirbyteStateMessage@620ea332[type=STREAM,stream=io.airbyte.protocol.models.AirbyteStreamState@45c2a68a[streamDescriptor=io.airbyte.protocol.models.StreamDescriptor@35cdae4[name=user_insights,namespace=,additionalProperties={}],streamState={"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}},additionalProperties={}],global=,data={"user_insights":{"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}}},additionalProperties={}],trace=,additionalProperties={}] 2022-11-03 14:21:46 destination > Final state message is accepted. 2022-11-03 14:21:46 destination > Removing tmp tables... 2022-11-03 14:21:46 destination > Finishing destination process...completed 2022-11-03 14:21:46 destination > Closed connector: AbstractBigQueryUploader{table=_airbyte_raw_instagram_media_insights, tmpTable=_airbyte_tmp_xot_instagram_media_insights, syncMode=WRITE_TRUNCATE, writer=class io.airbyte.integrations.destination.bigquery.writer.BigQueryTableWriter, recordFormatter=class io.airbyte.integrations.destination.bigquery.formatter.DefaultBigQueryRecordFormatter} 2022-11-03 14:21:46 destination > Closing connector: AbstractBigQueryUploader{table=_airbyte_raw_instagram_user_insights, tmpTable=_airbyte_tmp_obs_instagram_user_insights, syncMode=WRITE_APPEND, writer=class io.airbyte.integrations.destination.bigquery.writer.BigQueryTableWriter, recordFormatter=class io.airbyte.integrations.destination.bigquery.formatter.DefaultBigQueryRecordFormatter} 2022-11-03 14:21:46 destination > Waiting for job finish Job{job=JobId{project=spg-misc-data, job=3972fba1-9fe4-4934-847e-31b5bb5f2e1e, location=europe-north1}, status=JobStatus{state=RUNNING, error=null, executionErrors=null}, statistics=LoadStatistics{creationTime=1667485306539, endTime=null, startTime=1667485306717, numChildJobs=null, parentJobId=null, scriptStatistics=null, reservationUsage=null, inputBytes=null, inputFiles=null, outputBytes=null, outputRows=null, badRecords=null}, userEmail=spg-misc-service@spg-misc-data.iam.gserviceaccount.com, etag=A1Pv5IK1VYpsCgRTY3+ZGg==, generatedId=spg-misc-data:europe-north1.3972fba1-9fe4-4934-847e-31b5bb5f2e1e, selfLink=https://www.googleapis.com/bigquery/v2/projects/spg-misc-data/jobs/3972fba1-9fe4-4934-847e-31b5bb5f2e1e?location=europe-north1, configuration=LoadJobConfiguration{type=LOAD, destinationTable=GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, projectId=spg-misc-data, tableId=_airbyte_tmp_obs_instagram_user_insights}}, decimalTargetTypes=null, destinationEncryptionConfiguration=null, createDisposition=CREATE_IF_NEEDED, writeDisposition=null, formatOptions=FormatOptions{format=NEWLINE_DELIMITED_JSON}, nullMarker=null, maxBadRecords=null, schema=Schema{fields=[Field{name=_airbyte_ab_id, type=STRING, mode=null, description=null, policyTags=null}, Field{name=_airbyte_emitted_at, type=TIMESTAMP, mode=null, description=null, policyTags=null}, Field{name=_airbyte_data, type=STRING, mode=null, description=null, policyTags=null}]}, ignoreUnknownValue=null, sourceUris=null, schemaUpdateOptions=null, autodetect=null, timePartitioning=null, clustering=null, useAvroLogicalTypes=null, labels=null, jobTimeoutMs=null, rangePartitioning=null, hivePartitioningOptions=null}}. Status: JobStatus{state=RUNNING, error=null, executionErrors=null} 2022-11-03 14:21:49 destination > Job finish Job{job=JobId{project=spg-misc-data, job=3972fba1-9fe4-4934-847e-31b5bb5f2e1e, location=europe-north1}, status=JobStatus{state=RUNNING, error=null, executionErrors=null}, statistics=LoadStatistics{creationTime=1667485306539, endTime=null, startTime=1667485306717, numChildJobs=null, parentJobId=null, scriptStatistics=null, reservationUsage=null, inputBytes=null, inputFiles=null, outputBytes=null, outputRows=null, badRecords=null}, userEmail=spg-misc-service@spg-misc-data.iam.gserviceaccount.com, etag=A1Pv5IK1VYpsCgRTY3+ZGg==, generatedId=spg-misc-data:europe-north1.3972fba1-9fe4-4934-847e-31b5bb5f2e1e, selfLink=https://www.googleapis.com/bigquery/v2/projects/spg-misc-data/jobs/3972fba1-9fe4-4934-847e-31b5bb5f2e1e?location=europe-north1, configuration=LoadJobConfiguration{type=LOAD, destinationTable=GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, projectId=spg-misc-data, tableId=_airbyte_tmp_obs_instagram_user_insights}}, decimalTargetTypes=null, destinationEncryptionConfiguration=null, createDisposition=CREATE_IF_NEEDED, writeDisposition=null, formatOptions=FormatOptions{format=NEWLINE_DELIMITED_JSON}, nullMarker=null, maxBadRecords=null, schema=Schema{fields=[Field{name=_airbyte_ab_id, type=STRING, mode=null, description=null, policyTags=null}, Field{name=_airbyte_emitted_at, type=TIMESTAMP, mode=null, description=null, policyTags=null}, Field{name=_airbyte_data, type=STRING, mode=null, description=null, policyTags=null}]}, ignoreUnknownValue=null, sourceUris=null, schemaUpdateOptions=null, autodetect=null, timePartitioning=null, clustering=null, useAvroLogicalTypes=null, labels=null, jobTimeoutMs=null, rangePartitioning=null, hivePartitioningOptions=null}} with status JobStatus{state=RUNNING, error=null, executionErrors=null} 2022-11-03 14:21:49 destination > Uploading data from the tmp table _airbyte_tmp_obs_instagram_user_insights to the source table _airbyte_raw_instagram_user_insights. 2022-11-03 14:21:49 destination > Replication finished with no explicit errors. Copying data from tmp tables to permanent 2022-11-03 14:21:52 destination > successfully copied table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, tableId=_airbyte_tmp_obs_instagram_user_insights}} to table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, tableId=_airbyte_raw_instagram_user_insights}} 2022-11-03 14:21:52 destination > Data is successfully loaded to the source table _airbyte_raw_instagram_user_insights! 2022-11-03 14:21:52 INFO i.a.w.g.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$7):464 - State in DefaultReplicationWorker from destination: io.airbyte.protocol.models.AirbyteMessage@5816aed[type=STATE,log=,spec=,connectionStatus=,catalog=,record=,state=io.airbyte.protocol.models.AirbyteStateMessage@12014e5c[type=STREAM,stream=io.airbyte.protocol.models.AirbyteStreamState@42a75c60[streamDescriptor=io.airbyte.protocol.models.StreamDescriptor@27c9352a[name=user_insights,namespace=,additionalProperties={}],streamState={"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}},additionalProperties={}],global=,data={"user_insights":{"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}}},additionalProperties={}],trace=,additionalProperties={}] 2022-11-03 14:21:52 destination > Final state message is accepted. 2022-11-03 14:21:52 destination > Removing tmp tables... 2022-11-03 14:21:52 destination > Finishing destination process...completed 2022-11-03 14:21:52 destination > Closed connector: AbstractBigQueryUploader{table=_airbyte_raw_instagram_user_insights, tmpTable=_airbyte_tmp_obs_instagram_user_insights, syncMode=WRITE_APPEND, writer=class io.airbyte.integrations.destination.bigquery.writer.BigQueryTableWriter, recordFormatter=class io.airbyte.integrations.destination.bigquery.formatter.DefaultBigQueryRecordFormatter} 2022-11-03 14:21:52 destination > Completed integration: io.airbyte.integrations.destination.bigquery.BigQueryDestination 2022-11-03 14:21:53 ERROR i.a.w.g.DefaultReplicationWorker(run):196 - Sync worker failed. java.util.concurrent.ExecutionException: io.airbyte.workers.general.DefaultReplicationWorker$SourceException: Source cannot be stopped! at java.util.concurrent.CompletableFuture.reportGet(CompletableFuture.java:396) ~[?:?] at java.util.concurrent.CompletableFuture.get(CompletableFuture.java:2073) ~[?:?] at io.airbyte.workers.general.DefaultReplicationWorker.run(DefaultReplicationWorker.java:189) ~[io.airbyte-airbyte-commons-worker-0.40.16.jar:?] at io.airbyte.workers.general.DefaultReplicationWorker.run(DefaultReplicationWorker.java:71) ~[io.airbyte-airbyte-commons-worker-0.40.16.jar:?] at io.airbyte.workers.temporal.TemporalAttemptExecution.lambda$getWorkerThread$4(TemporalAttemptExecution.java:190) ~[io.airbyte-airbyte-workers-0.40.16.jar:?] at java.lang.Thread.run(Thread.java:1589) ~[?:?] Suppressed: io.airbyte.workers.exception.WorkerException: Source process exit with code 1. This warning is normal if the job was cancelled. at io.airbyte.workers.internal.DefaultAirbyteSource.close(DefaultAirbyteSource.java:135) ~[io.airbyte-airbyte-commons-worker-0.40.16.jar:?] at io.airbyte.workers.general.DefaultReplicationWorker.run(DefaultReplicationWorker.java:151) ~[io.airbyte-airbyte-commons-worker-0.40.16.jar:?] at io.airbyte.workers.general.DefaultReplicationWorker.run(DefaultReplicationWorker.java:71) ~[io.airbyte-airbyte-commons-worker-0.40.16.jar:?] at io.airbyte.workers.temporal.TemporalAttemptExecution.lambda$getWorkerThread$4(TemporalAttemptExecution.java:190) ~[io.airbyte-airbyte-workers-0.40.16.jar:?] at java.lang.Thread.run(Thread.java:1589) ~[?:?] Caused by: io.airbyte.workers.general.DefaultReplicationWorker$SourceException: Source cannot be stopped! at io.airbyte.workers.general.DefaultReplicationWorker.lambda$getReplicationRunnable$6(DefaultReplicationWorker.java:376) ~[io.airbyte-airbyte-commons-worker-0.40.16.jar:?] at java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1804) ~[?:?] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) ~[?:?] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) ~[?:?] ... 1 more Caused by: io.airbyte.workers.exception.WorkerException: Source process exit with code 1. This warning is normal if the job was cancelled. at io.airbyte.workers.internal.DefaultAirbyteSource.close(DefaultAirbyteSource.java:135) ~[io.airbyte-airbyte-commons-worker-0.40.16.jar:?] at io.airbyte.workers.general.DefaultReplicationWorker.lambda$getReplicationRunnable$6(DefaultReplicationWorker.java:374) ~[io.airbyte-airbyte-commons-worker-0.40.16.jar:?] at java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1804) ~[?:?] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) ~[?:?] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) ~[?:?] ... 1 more 2022-11-03 14:21:53 WARN i.a.w.g.DefaultReplicationWorker(run):236 - Could not reliably determine committed record counts, committed record stats will be set to null 2022-11-03 14:21:53 INFO i.a.w.g.DefaultReplicationWorker(run):295 - Source output at least one state message 2022-11-03 14:21:53 INFO i.a.w.g.DefaultReplicationWorker(run):301 - State capture: Updated state to: Optional[io.airbyte.config.State@46770b3d[state=[{"type":"STREAM","stream":{"stream_descriptor":{"name":"user_insights"},"stream_state":{"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}}}}]]] 2022-11-03 14:21:53 INFO i.a.w.g.DefaultReplicationWorker(run):316 - sync summary: { "status" : "failed", "recordsSynced" : 6518, "bytesSynced" : 4387150, "startTime" : 1667482288585, "endTime" : 1667485313078, "totalStats" : { "recordsEmitted" : 6518, "bytesEmitted" : 4387150, "sourceStateMessagesEmitted" : 10, "destinationStateMessagesEmitted" : 17, "meanSecondsBeforeSourceStateMessageEmitted" : 296, "maxSecondsBeforeSourceStateMessageEmitted" : 2968, "replicationStartTime" : 1667482288585, "replicationEndTime" : 1667485313078, "sourceReadStartTime" : 1667482288639, "sourceReadEndTime" : 0, "destinationWriteStartTime" : 1667482288794, "destinationWriteEndTime" : 1667485313077 }, "streamStats" : [ { "streamName" : "instagram_stories", "stats" : { "recordsEmitted" : 9, "bytesEmitted" : 7126 } }, { "streamName" : "instagram_user_insights", "stats" : { "recordsEmitted" : 10, "bytesEmitted" : 3939 } }, { "streamName" : "instagram_media_insights", "stats" : { "recordsEmitted" : 3003, "bytesEmitted" : 479140 } }, { "streamName" : "instagram_story_insights", "stats" : { "recordsEmitted" : 9, "bytesEmitted" : 1641 } }, { "streamName" : "instagram_media", "stats" : { "recordsEmitted" : 3487, "bytesEmitted" : 3895304 } } ] } 2022-11-03 14:21:53 INFO i.a.w.g.DefaultReplicationWorker(run):317 - failures: [ { "failureOrigin" : "source", "failureType" : "system_error", "internalMessage" : "'end_time'", "externalMessage" : "Something went wrong in the connector. See the logs for more details.", "metadata" : { "attemptNumber" : 0, "jobId" : 887, "from_trace_message" : true, "connector_command" : "read" }, "stacktrace" : "Traceback (most recent call last):\n File \"/airbyte/integration_code/main.py\", line 13, in \n launch(source, sys.argv[1:])\n File \"/usr/local/lib/python3.9/site-packages/airbyte_cdk/entrypoint.py\", line 123, in launch\n for message in source_entrypoint.run(parsed_args):\n File \"/usr/local/lib/python3.9/site-packages/airbyte_cdk/entrypoint.py\", line 114, in run\n for message in generator:\n File \"/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py\", line 127, in read\n raise e\n File \"/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py\", line 113, in read\n yield from self._read_stream(\n File \"/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py\", line 182, in _read_stream\n for record in record_iterator:\n File \"/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py\", line 285, in _read_full_refresh\n for record in records:\n File \"/airbyte/integration_code/source_instagram/streams.py\", line 124, in read_records\n \"date\": insight[\"values\"][0][\"end_time\"],\nKeyError: 'end_time'\n", "timestamp" : 1667485278645 }, { "failureOrigin" : "source", "internalMessage" : "io.airbyte.workers.general.DefaultReplicationWorker$SourceException: Source cannot be stopped!", "externalMessage" : "Something went wrong within the source connector", "metadata" : { "attemptNumber" : 0, "jobId" : 887, "connector_command" : "read" }, "stacktrace" : "java.util.concurrent.CompletionException: io.airbyte.workers.general.DefaultReplicationWorker$SourceException: Source cannot be stopped!\n\tat java.base/java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:315)\n\tat java.base/java.util.concurrent.CompletableFuture.completeThrowable(CompletableFuture.java:320)\n\tat java.base/java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1807)\n\tat java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)\n\tat java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)\n\tat java.base/java.lang.Thread.run(Thread.java:1589)\nCaused by: io.airbyte.workers.general.DefaultReplicationWorker$SourceException: Source cannot be stopped!\n\tat io.airbyte.workers.general.DefaultReplicationWorker.lambda$getReplicationRunnable$6(DefaultReplicationWorker.java:376)\n\tat java.base/java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1804)\n\t... 3 more\nCaused by: io.airbyte.workers.exception.WorkerException: Source process exit with code 1. This warning is normal if the job was cancelled.\n\tat io.airbyte.workers.internal.DefaultAirbyteSource.close(DefaultAirbyteSource.java:135)\n\tat io.airbyte.workers.general.DefaultReplicationWorker.lambda$getReplicationRunnable$6(DefaultReplicationWorker.java:374)\n\t... 4 more\n", "timestamp" : 1667485278922 } ] 2022-11-03 14:21:53 INFO i.a.w.t.TemporalAttemptExecution(get):162 - Stopping cancellation check scheduling... 2022-11-03 14:21:53 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-11-03 14:21:53 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- END REPLICATION ----- 2022-11-03 14:21:53 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-11-03 14:21:53 INFO i.a.w.t.s.ReplicationActivityImpl(lambda$replicate$3):176 - sync summary: io.airbyte.config.StandardSyncOutput@40b4fdf2[standardSyncSummary=io.airbyte.config.StandardSyncSummary@5a64dfea[status=failed,recordsSynced=6518,bytesSynced=4387150,startTime=1667482288585,endTime=1667485313078,totalStats=io.airbyte.config.SyncStats@5c4c9690[recordsEmitted=6518,bytesEmitted=4387150,sourceStateMessagesEmitted=10,destinationStateMessagesEmitted=17,recordsCommitted=,meanSecondsBeforeSourceStateMessageEmitted=296,maxSecondsBeforeSourceStateMessageEmitted=2968,maxSecondsBetweenStateMessageEmittedandCommitted=,meanSecondsBetweenStateMessageEmittedandCommitted=,replicationStartTime=1667482288585,replicationEndTime=1667485313078,sourceReadStartTime=1667482288639,sourceReadEndTime=0,destinationWriteStartTime=1667482288794,destinationWriteEndTime=1667485313077,additionalProperties={}],streamStats=[io.airbyte.config.StreamSyncStats@305e05e[streamName=instagram_stories,stats=io.airbyte.config.SyncStats@6439d6a1[recordsEmitted=9,bytesEmitted=7126,sourceStateMessagesEmitted=,destinationStateMessagesEmitted=,recordsCommitted=,meanSecondsBeforeSourceStateMessageEmitted=,maxSecondsBeforeSourceStateMessageEmitted=,maxSecondsBetweenStateMessageEmittedandCommitted=,meanSecondsBetweenStateMessageEmittedandCommitted=,replicationStartTime=,replicationEndTime=,sourceReadStartTime=,sourceReadEndTime=,destinationWriteStartTime=,destinationWriteEndTime=,additionalProperties={}]], io.airbyte.config.StreamSyncStats@18dece43[streamName=instagram_user_insights,stats=io.airbyte.config.SyncStats@209e23de[recordsEmitted=10,bytesEmitted=3939,sourceStateMessagesEmitted=,destinationStateMessagesEmitted=,recordsCommitted=,meanSecondsBeforeSourceStateMessageEmitted=,maxSecondsBeforeSourceStateMessageEmitted=,maxSecondsBetweenStateMessageEmittedandCommitted=,meanSecondsBetweenStateMessageEmittedandCommitted=,replicationStartTime=,replicationEndTime=,sourceReadStartTime=,sourceReadEndTime=,destinationWriteStartTime=,destinationWriteEndTime=,additionalProperties={}]], io.airbyte.config.StreamSyncStats@cb52083[streamName=instagram_media_insights,stats=io.airbyte.config.SyncStats@2693636a[recordsEmitted=3003,bytesEmitted=479140,sourceStateMessagesEmitted=,destinationStateMessagesEmitted=,recordsCommitted=,meanSecondsBeforeSourceStateMessageEmitted=,maxSecondsBeforeSourceStateMessageEmitted=,maxSecondsBetweenStateMessageEmittedandCommitted=,meanSecondsBetweenStateMessageEmittedandCommitted=,replicationStartTime=,replicationEndTime=,sourceReadStartTime=,sourceReadEndTime=,destinationWriteStartTime=,destinationWriteEndTime=,additionalProperties={}]], io.airbyte.config.StreamSyncStats@48d11d2d[streamName=instagram_story_insights,stats=io.airbyte.config.SyncStats@1900573a[recordsEmitted=9,bytesEmitted=1641,sourceStateMessagesEmitted=,destinationStateMessagesEmitted=,recordsCommitted=,meanSecondsBeforeSourceStateMessageEmitted=,maxSecondsBeforeSourceStateMessageEmitted=,maxSecondsBetweenStateMessageEmittedandCommitted=,meanSecondsBetweenStateMessageEmittedandCommitted=,replicationStartTime=,replicationEndTime=,sourceReadStartTime=,sourceReadEndTime=,destinationWriteStartTime=,destinationWriteEndTime=,additionalProperties={}]], io.airbyte.config.StreamSyncStats@3c94cda1[streamName=instagram_media,stats=io.airbyte.config.SyncStats@1a1616a[recordsEmitted=3487,bytesEmitted=3895304,sourceStateMessagesEmitted=,destinationStateMessagesEmitted=,recordsCommitted=,meanSecondsBeforeSourceStateMessageEmitted=,maxSecondsBeforeSourceStateMessageEmitted=,maxSecondsBetweenStateMessageEmittedandCommitted=,meanSecondsBetweenStateMessageEmittedandCommitted=,replicationStartTime=,replicationEndTime=,sourceReadStartTime=,sourceReadEndTime=,destinationWriteStartTime=,destinationWriteEndTime=,additionalProperties={}]]]],normalizationSummary=,webhookOperationSummary=,state=io.airbyte.config.State@46770b3d[state=[{"type":"STREAM","stream":{"stream_descriptor":{"name":"user_insights"},"stream_state":{"17841401993121167":{"date":"2022-11-03T07:00:00+00:00"},"17841452328191037":{"date":"2022-11-03T07:00:00+00:00"},"17841421145487667":{"date":"2022-11-03T07:00:00+00:00"},"17841400844997659":{"date":"2022-11-03T07:00:00+00:00"},"17841452674376878":{"date":"2022-11-03T07:00:00+00:00"},"17841406448385387":{"date":"2022-11-03T07:00:00+00:00"},"17841400657993479":{"date":"2022-11-03T07:00:00+00:00"},"17841440493306537":{"date":"2022-11-03T07:00:00+00:00"},"17841417388884180":{"date":"2022-11-03T07:00:00+00:00"},"17841403860219174":{"date":"2022-11-03T07:00:00+00:00"}}}}]],outputCatalog=io.airbyte.protocol.models.ConfiguredAirbyteCatalog@41d92c06[streams=[io.airbyte.protocol.models.ConfiguredAirbyteStream@5afb1a80[stream=io.airbyte.protocol.models.AirbyteStream@40183dbb[name=instagram_media,jsonSchema={"type":"object","properties":{"id":{"type":["null","string"]},"ig_id":{"type":["null","string"]},"owner":{"type":["null","object"],"properties":{"id":{"type":["null","string"]}}},"caption":{"type":["null","string"]},"page_id":{"type":["null","string"]},"children":{"type":["null","array"],"items":{"type":"object","properties":{"id":{"type":["null","string"]},"ig_id":{"type":["null","string"]},"owner":{"type":["null","object"],"properties":{"id":{"type":["null","string"]}}},"username":{"type":["null","string"]},"media_url":{"type":["null","string"]},"permalink":{"type":["null","string"]},"shortcode":{"type":["null","string"]},"timestamp":{"type":["null","string"],"format":"date-time"},"media_type":{"type":["null","string"]},"thumbnail_url":{"type":["null","string"]}}}},"username":{"type":["null","string"]},"media_url":{"type":["null","string"]},"permalink":{"type":["null","string"]},"shortcode":{"type":["null","string"]},"timestamp":{"type":["null","string"],"format":"date-time"},"like_count":{"type":["null","integer"]},"media_type":{"type":["null","string"]},"thumbnail_url":{"type":["null","string"]},"comments_count":{"type":["null","integer"]},"is_comment_enabled":{"type":["null","boolean"]},"business_account_id":{"type":["null","string"]}}},supportedSyncModes=[full_refresh],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[id]],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@4ab8bee3[stream=io.airbyte.protocol.models.AirbyteStream@428902ae[name=instagram_media_insights,jsonSchema={"type":"object","properties":{"id":{"type":["null","string"]},"reach":{"type":["null","integer"]},"saved":{"type":["null","integer"]},"page_id":{"type":["null","string"]},"engagement":{"type":["null","integer"]},"impressions":{"type":["null","integer"]},"video_views":{"type":["null","integer"]},"business_account_id":{"type":["null","string"]},"carousel_album_reach":{"type":["null","integer"]},"carousel_album_saved":{"type":["null","integer"]},"carousel_album_engagement":{"type":["null","integer"]},"carousel_album_impressions":{"type":["null","integer"]}}},supportedSyncModes=[full_refresh],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[id]],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@40a43f65[stream=io.airbyte.protocol.models.AirbyteStream@4150272f[name=instagram_stories,jsonSchema={"type":"object","properties":{"id":{"type":["null","string"]},"ig_id":{"type":["null","string"]},"owner":{"type":["null","object"],"properties":{"id":{"type":["null","string"]}}},"caption":{"type":["null","string"]},"page_id":{"type":["null","string"]},"username":{"type":["null","string"]},"media_url":{"type":["null","string"]},"permalink":{"type":["null","string"]},"shortcode":{"type":["null","string"]},"timestamp":{"type":["null","string"],"format":"date-time"},"like_count":{"type":["null","integer"]},"media_type":{"type":["null","string"]},"thumbnail_url":{"type":["null","string"]},"business_account_id":{"type":["null","string"]}}},supportedSyncModes=[full_refresh],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[id]],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@4e10c640[stream=io.airbyte.protocol.models.AirbyteStream@4486215e[name=instagram_story_insights,jsonSchema={"type":"object","properties":{"id":{"type":["null","string"]},"exits":{"type":["null","integer"]},"reach":{"type":["null","integer"]},"page_id":{"type":["null","string"]},"replies":{"type":["null","integer"]},"taps_back":{"type":["null","integer"]},"impressions":{"type":["null","integer"]},"taps_forward":{"type":["null","integer"]},"business_account_id":{"type":["null","string"]}}},supportedSyncModes=[full_refresh],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[id]],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@25b861bc[stream=io.airbyte.protocol.models.AirbyteStream@6511537b[name=instagram_user_insights,jsonSchema={"type":"object","properties":{"date":{"type":["null","string"],"format":"date-time"},"reach":{"type":["null","integer"]},"page_id":{"type":["null","string"]},"reach_week":{"type":["null","integer"]},"impressions":{"type":["null","integer"]},"profile_views":{"type":["null","integer"]},"reach_days_28":{"type":["null","integer"]},"follower_count":{"type":["null","integer"]},"website_clicks":{"type":["null","integer"]},"impressions_week":{"type":["null","integer"]},"online_followers":{"type":["null","object"]},"phone_call_clicks":{"type":["null","integer"]},"business_account_id":{"type":["null","string"]},"impressions_days_28":{"type":["null","integer"]},"text_message_clicks":{"type":["null","integer"]},"get_directions_clicks":{"type":["null","integer"]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[date],sourceDefinedPrimaryKey=[],namespace=,additionalProperties={}],syncMode=incremental,cursorField=[date],destinationSyncMode=append,primaryKey=[],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@2dfbab5f[stream=io.airbyte.protocol.models.AirbyteStream@5802f36f[name=instagram_user_lifetime_insights,jsonSchema={"type":"object","properties":{"date":{"type":["null","string"],"format":"date-time"},"value":{"type":["integer","object"]},"metric":{"type":["null","string"]},"page_id":{"type":["null","string"]},"business_account_id":{"type":["null","string"]}}},supportedSyncModes=[full_refresh],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=append,primaryKey=[],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@3e51cc52[stream=io.airbyte.protocol.models.AirbyteStream@51b4da68[name=instagram_users,jsonSchema={"type":"object","properties":{"id":{"type":["null","string"]},"name":{"type":["null","string"]},"ig_id":{"type":["null","integer"]},"page_id":{"type":["null","string"]},"website":{"type":["null","string"]},"username":{"type":["null","string"]},"biography":{"type":["null","string"]},"media_count":{"type":["null","integer"]},"follows_count":{"type":["null","integer"]},"followers_count":{"type":["null","integer"]},"profile_picture_url":{"type":["null","string"]}}},supportedSyncModes=[full_refresh],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[id]],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[id]],additionalProperties={}]],additionalProperties={}],failures=[io.airbyte.config.FailureReason@21e53252[failureOrigin=source,failureType=system_error,internalMessage='end_time',externalMessage=Something went wrong in the connector. See the logs for more details.,metadata=io.airbyte.config.Metadata@6e33248a[additionalProperties={attemptNumber=0, jobId=887, from_trace_message=true, connector_command=read}],stacktrace=Traceback (most recent call last): File "/airbyte/integration_code/main.py", line 13, in launch(source, sys.argv[1:]) File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/entrypoint.py", line 123, in launch for message in source_entrypoint.run(parsed_args): File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/entrypoint.py", line 114, in run for message in generator: File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py", line 127, in read raise e File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py", line 113, in read yield from self._read_stream( File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py", line 182, in _read_stream for record in record_iterator: File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py", line 285, in _read_full_refresh for record in records: File "/airbyte/integration_code/source_instagram/streams.py", line 124, in read_records "date": insight["values"][0]["end_time"], KeyError: 'end_time' ,retryable=,timestamp=1667485278645], io.airbyte.config.FailureReason@5e304642[failureOrigin=source,failureType=,internalMessage=io.airbyte.workers.general.DefaultReplicationWorker$SourceException: Source cannot be stopped!,externalMessage=Something went wrong within the source connector,metadata=io.airbyte.config.Metadata@2920b076[additionalProperties={attemptNumber=0, jobId=887, connector_command=read}],stacktrace=java.util.concurrent.CompletionException: io.airbyte.workers.general.DefaultReplicationWorker$SourceException: Source cannot be stopped! 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:1144) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) at java.base/java.lang.Thread.run(Thread.java:1589) Caused by: io.airbyte.workers.general.DefaultReplicationWorker$SourceException: Source cannot be stopped! at io.airbyte.workers.general.DefaultReplicationWorker.lambda$getReplicationRunnable$6(DefaultReplicationWorker.java:376) at java.base/java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1804) ... 3 more Caused by: io.airbyte.workers.exception.WorkerException: Source process exit with code 1. This warning is normal if the job was cancelled. at io.airbyte.workers.internal.DefaultAirbyteSource.close(DefaultAirbyteSource.java:135) at io.airbyte.workers.general.DefaultReplicationWorker.lambda$getReplicationRunnable$6(DefaultReplicationWorker.java:374) ... 4 more ,retryable=,timestamp=1667485278922]]] 2022-11-03 14:21:53 INFO i.a.w.t.s.ReplicationActivityImpl(lambda$replicate$3):181 - Sync summary length: 15635 2022-11-03 14:21:53 INFO i.a.c.t.TemporalUtils(withBackgroundHeartbeat):283 - Stopping temporal heartbeating... 2022-11-03 14:21:53 INFO i.a.c.f.EnvVariableFeatureFlags(getEnvOrDefault):50 - Using default value for environment variable NEED_STATE_VALIDATION: 'true' 2022-11-03 14:21:53 INFO i.a.w.t.TemporalAttemptExecution(get):136 - Docker volume job log path: /tmp/workspace/887/0/logs.log 2022-11-03 14:21:53 INFO i.a.w.t.TemporalAttemptExecution(get):141 - Executing worker wrapper. Airbyte version: 0.40.16 2022-11-03 14:21:53 INFO i.a.w.n.DefaultNormalizationRunner(runProcess):134 - Running with normalization version: airbyte/normalization:0.2.23 2022-11-03 14:21:53 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-11-03 14:21:53 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- START DEFAULT NORMALIZATION ----- 2022-11-03 14:21:53 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-11-03 14:21:53 INFO i.a.c.i.LineGobbler(voidCall):114 - Checking if airbyte/normalization:0.2.23 exists... 2022-11-03 14:21:53 INFO i.a.c.i.LineGobbler(voidCall):114 - airbyte/normalization:0.2.23 was found locally. 2022-11-03 14:21:53 INFO i.a.w.p.DockerProcessFactory(create):119 - Creating docker container = normalization-normalize-887-0-pgdgk with resources io.airbyte.config.ResourceRequirements@3bcefe9e[cpuRequest=,cpuLimit=,memoryRequest=,memoryLimit=] 2022-11-03 14:21:53 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/887/0/normalize --log-driver none --name normalization-normalize-887-0-pgdgk --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e WORKER_ENVIRONMENT=DOCKER -e AIRBYTE_ROLE= -e AIRBYTE_VERSION=0.40.16 airbyte/normalization:0.2.23 run --integration-type bigquery --config destination_config.json --catalog destination_catalog.json 2022-11-03 14:21:53 normalization > Running: transform-config --config destination_config.json --integration-type bigquery --out /data/887/0/normalize 2022-11-03 14:21:54 normalization > Namespace(config='destination_config.json', integration_type=, out='/data/887/0/normalize') 2022-11-03 14:21:54 normalization > transform_bigquery 2022-11-03 14:21:54 normalization > Running: transform-catalog --integration-type bigquery --profile-config-dir /data/887/0/normalize --catalog destination_catalog.json --out /data/887/0/normalize/models/generated/ --json-column _airbyte_data 2022-11-03 14:21:55 normalization > Processing destination_catalog.json... 2022-11-03 14:21:55 normalization > Generating airbyte_ctes/misc/instagram_media_ab1.sql from instagram_media 2022-11-03 14:21:55 normalization > Generating airbyte_ctes/misc/instagram_media_ab2.sql from instagram_media 2022-11-03 14:21:55 normalization > Generating airbyte_ctes/misc/instagram_media_ab3.sql from instagram_media 2022-11-03 14:21:55 normalization > Generating airbyte_tables/misc/instagram_media.sql from instagram_media 2022-11-03 14:21:55 normalization > Generating airbyte_ctes/misc/instagram_media_insights_ab1.sql from instagram_media_insights 2022-11-03 14:21:55 normalization > Generating airbyte_ctes/misc/instagram_media_insights_ab2.sql from instagram_media_insights 2022-11-03 14:21:55 normalization > Generating airbyte_ctes/misc/instagram_media_insights_ab3.sql from instagram_media_insights 2022-11-03 14:21:55 normalization > Generating airbyte_tables/misc/instagram_media_insights.sql from instagram_media_insights 2022-11-03 14:21:55 normalization > Generating airbyte_ctes/misc/instagram_stories_ab1.sql from instagram_stories 2022-11-03 14:21:55 normalization > Generating airbyte_ctes/misc/instagram_stories_ab2.sql from instagram_stories 2022-11-03 14:21:55 normalization > Generating airbyte_ctes/misc/instagram_stories_ab3.sql from instagram_stories 2022-11-03 14:21:55 normalization > Generating airbyte_tables/misc/instagram_stories.sql from instagram_stories 2022-11-03 14:21:55 normalization > Generating airbyte_ctes/misc/instagram_story_insights_ab1.sql from instagram_story_insights 2022-11-03 14:21:55 normalization > Generating airbyte_ctes/misc/instagram_story_insights_ab2.sql from instagram_story_insights 2022-11-03 14:21:55 normalization > Generating airbyte_ctes/misc/instagram_story_insights_ab3.sql from instagram_story_insights 2022-11-03 14:21:55 normalization > Generating airbyte_tables/misc/instagram_story_insights.sql from instagram_story_insights 2022-11-03 14:21:55 normalization > Generating airbyte_ctes/misc/instagram_user_insights_ab1.sql from instagram_user_insights 2022-11-03 14:21:55 normalization > Generating airbyte_ctes/misc/instagram_user_insights_ab2.sql from instagram_user_insights 2022-11-03 14:21:55 normalization > Generating airbyte_ctes/misc/instagram_user_insights_ab3.sql from instagram_user_insights 2022-11-03 14:21:55 normalization > Generating airbyte_incremental/misc/instagram_user_insights.sql from instagram_user_insights 2022-11-03 14:21:55 normalization > Generating airbyte_ctes/misc/instagram_user_lifetime_insights_ab1.sql from instagram_user_lifetime_insights 2022-11-03 14:21:55 normalization > Generating airbyte_ctes/misc/instagram_user_lifetime_insights_ab2.sql from instagram_user_lifetime_insights 2022-11-03 14:21:55 normalization > Generating airbyte_ctes/misc/instagram_user_lifetime_insights_ab3.sql from instagram_user_lifetime_insights 2022-11-03 14:21:55 normalization > Generating airbyte_incremental/misc/instagram_user_lifetime_insights.sql from instagram_user_lifetime_insights 2022-11-03 14:21:55 normalization > Generating airbyte_ctes/misc/instagram_users_ab1.sql from instagram_users 2022-11-03 14:21:55 normalization > Generating airbyte_ctes/misc/instagram_users_ab2.sql from instagram_users 2022-11-03 14:21:55 normalization > Generating airbyte_ctes/misc/instagram_users_ab3.sql from instagram_users 2022-11-03 14:21:55 normalization > Generating airbyte_tables/misc/instagram_users.sql from instagram_users 2022-11-03 14:21:55 normalization > Generating airbyte_ctes/misc/instagram_media_owner_ab1.sql from instagram_media/owner 2022-11-03 14:21:55 normalization > Generating airbyte_ctes/misc/instagram_media_owner_ab2.sql from instagram_media/owner 2022-11-03 14:21:55 normalization > Generating airbyte_ctes/misc/instagram_media_owner_ab3.sql from instagram_media/owner 2022-11-03 14:21:55 normalization > Generating airbyte_tables/misc/instagram_media_owner.sql from instagram_media/owner 2022-11-03 14:21:55 normalization > Generating airbyte_ctes/misc/instagram_media_children_ab1.sql from instagram_media/children 2022-11-03 14:21:55 normalization > Generating airbyte_ctes/misc/instagram_media_children_ab2.sql from instagram_media/children 2022-11-03 14:21:55 normalization > Generating airbyte_ctes/misc/instagram_media_children_ab3.sql from instagram_media/children 2022-11-03 14:21:55 normalization > Generating airbyte_tables/misc/instagram_media_children.sql from instagram_media/children 2022-11-03 14:21:55 normalization > Generating airbyte_ctes/misc/instagram_stories_owner_ab1.sql from instagram_stories/owner 2022-11-03 14:21:55 normalization > Generating airbyte_ctes/misc/instagram_stories_owner_ab2.sql from instagram_stories/owner 2022-11-03 14:21:55 normalization > Generating airbyte_ctes/misc/instagram_stories_owner_ab3.sql from instagram_stories/owner 2022-11-03 14:21:55 normalization > Generating airbyte_tables/misc/instagram_stories_owner.sql from instagram_stories/owner 2022-11-03 14:21:55 normalization > Ignoring stream 'value' from instagram_user_lifetime_insights/value because properties list is empty 2022-11-03 14:21:55 normalization > Generating airbyte_ctes/misc/instagram_media_children_owner_ab1.sql from instagram_media/children/owner 2022-11-03 14:21:55 normalization > Generating airbyte_ctes/misc/instagram_media_children_owner_ab2.sql from instagram_media/children/owner 2022-11-03 14:21:55 normalization > Generating airbyte_ctes/misc/instagram_media_children_owner_ab3.sql from instagram_media/children/owner 2022-11-03 14:21:55 normalization > Generating airbyte_tables/misc/instagram_media_children_owner.sql from instagram_media/children/owner 2022-11-03 14:21:55 normalization > detected no config file for ssh, assuming ssh is off. 2022-11-03 14:21:58 normalization > [--event-buffer-size EVENT_BUFFER_SIZE] 2022-11-03 14:21:58 normalization > --event-buffer-size EVENT_BUFFER_SIZE 2022-11-03 14:21:58 INFO i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 2022-11-03 14:21:58 normalization > DBT >=1.0.0 detected; using 10K event buffer size 2022-11-03 14:21:58 INFO i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 2022-11-03 14:22:02 normalization > Running with dbt=1.0.0 2022-11-03 14:22:02 normalization > Partial parse save file not found. Starting full parse. 2022-11-03 14:22:05 normalization > [WARNING]: Configuration paths exist in your dbt_project.yml file which do not apply to any resources. There are 1 unused configuration paths: - models.airbyte_utils.generated.airbyte_views 2022-11-03 14:22:05 normalization > Found 44 models, 0 tests, 0 snapshots, 0 analyses, 602 macros, 0 operations, 0 seed files, 7 sources, 0 exposures, 0 metrics 2022-11-03 14:22:09 normalization > Concurrency: 8 threads (target='prod') 2022-11-03 14:22:09 normalization > 1 of 11 START table model misc.instagram_stories........................................................................ [RUN] 2022-11-03 14:22:09 normalization > 2 of 11 START table model misc.instagram_media_insights................................................................. [RUN] 2022-11-03 14:22:09 normalization > 3 of 11 START table model misc.instagram_story_insights................................................................. [RUN] 2022-11-03 14:22:09 normalization > 4 of 11 START table model misc.instagram_users.......................................................................... [RUN] 2022-11-03 14:22:10 normalization > 5 of 11 START table model misc.instagram_media.......................................................................... [RUN] 2022-11-03 14:22:10 normalization > 6 of 11 START incremental model misc.instagram_user_lifetime_insights................................................... [RUN] 2022-11-03 14:22:10 normalization > 7 of 11 START incremental model misc.instagram_user_insights............................................................ [RUN] 2022-11-03 14:22:12 normalization > 3 of 11 OK created table model misc.instagram_story_insights............................................................ [CREATE TABLE (9.0 rows, 2.0 KB processed) in 2.71s] 2022-11-03 14:22:12 normalization > 4 of 11 OK created table model misc.instagram_users..................................................................... [CREATE TABLE (0.0 rows, 0 processed) in 2.67s] 2022-11-03 14:22:12 normalization > 1 of 11 OK created table model misc.instagram_stories................................................................... [CREATE TABLE (9.0 rows, 7.4 KB processed) in 3.14s] 2022-11-03 14:22:12 normalization > 2 of 11 OK created table model misc.instagram_media_insights............................................................ [CREATE TABLE (3.0k rows, 608.7 KB processed) in 3.02s] 2022-11-03 14:22:12 normalization > 8 of 11 START table model misc.instagram_stories_owner.................................................................. [RUN] 2022-11-03 14:22:13 normalization > 5 of 11 OK created table model misc.instagram_media..................................................................... [CREATE TABLE (3.5k rows, 3.9 MB processed) in 3.54s] 2022-11-03 14:22:13 normalization > 9 of 11 START table model misc.instagram_media_owner.................................................................... [RUN] 2022-11-03 14:22:13 normalization > 10 of 11 START table model misc.instagram_media_children................................................................ [RUN] 2022-11-03 14:22:15 normalization > 8 of 11 OK created table model misc.instagram_stories_owner............................................................. [CREATE TABLE (9.0 rows, 972.0 Bytes processed) in 2.29s] 2022-11-03 14:22:16 normalization > 9 of 11 OK created table model misc.instagram_media_owner............................................................... [CREATE TABLE (3.5k rows, 367.8 KB processed) in 2.29s] 2022-11-03 14:22:16 normalization > 10 of 11 OK created table model misc.instagram_media_children........................................................... [CREATE TABLE (1.2k rows, 947.6 KB processed) in 2.34s] 2022-11-03 14:22:16 normalization > 11 of 11 START table model misc.instagram_media_children_owner.......................................................... [RUN] 2022-11-03 14:22:16 normalization > 6 of 11 OK created incremental model misc.instagram_user_lifetime_insights.............................................. [MERGE (0.0 rows, 0 processed) in 5.70s] 2022-11-03 14:22:18 normalization > 7 of 11 OK created incremental model misc.instagram_user_insights....................................................... [MERGE (11.0 rows, 60.2 KB processed) in 7.32s] 2022-11-03 14:22:18 normalization > 11 of 11 OK created table model misc.instagram_media_children_owner..................................................... [CREATE TABLE (1.2k rows, 124.3 KB processed) in 2.24s] 2022-11-03 14:22:18 normalization > Finished running 9 table models, 2 incremental models in 13.18s. 2022-11-03 14:22:18 normalization > Completed successfully 2022-11-03 14:22:18 normalization > Done. PASS=11 WARN=0 ERROR=0 SKIP=0 TOTAL=11 2022-11-03 14:22:18 INFO i.a.w.g.DefaultNormalizationWorker(run):82 - Normalization executed in 25 seconds. 2022-11-03 14:22:18 INFO i.a.w.g.DefaultNormalizationWorker(run):95 - Normalization summary: io.airbyte.config.NormalizationSummary@524a7e4[startTime=1667485313322,endTime=1667485338977,failures=[]] 2022-11-03 14:22:18 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-11-03 14:22:18 INFO i.a.w.t.TemporalAttemptExecution(get):162 - Stopping cancellation check scheduling... 2022-11-03 14:22:18 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- END DEFAULT NORMALIZATION ----- 2022-11-03 14:22:18 INFO i.a.c.t.TemporalUtils(withBackgroundHeartbeat):283 - Stopping temporal heartbeating... 2022-11-03 14:22:18 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-11-03 14:22:19 INFO i.a.w.t.TemporalAttemptExecution(get):136 - Docker volume job log path: /tmp/workspace/887/1/logs.log 2022-11-03 14:22:19 INFO i.a.w.t.TemporalAttemptExecution(get):141 - Executing worker wrapper. Airbyte version: 0.40.16 2022-11-03 14:22:19 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-11-03 14:22:19 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- START CHECK ----- 2022-11-03 14:22:19 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-11-03 14:22:19 INFO i.a.c.i.LineGobbler(voidCall):114 - Checking if airbyte/source-instagram:1.0.0 exists... 2022-11-03 14:22:19 INFO i.a.c.i.LineGobbler(voidCall):114 - airbyte/source-instagram:1.0.0 was found locally. 2022-11-03 14:22:19 INFO i.a.w.p.DockerProcessFactory(create):119 - Creating docker container = source-instagram-check-887-1-ytcst with resources io.airbyte.config.ResourceRequirements@3dd35bf6[cpuRequest=,cpuLimit=,memoryRequest=,memoryLimit=] 2022-11-03 14:22:19 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/887/1 --log-driver none --name source-instagram-check-887-1-ytcst --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=true -e WORKER_ENVIRONMENT=DOCKER -e AIRBYTE_ROLE= -e WORKER_JOB_ATTEMPT=1 -e WORKER_CONNECTOR_IMAGE=airbyte/source-instagram:1.0.0 -e AIRBYTE_VERSION=0.40.16 -e WORKER_JOB_ID=887 airbyte/source-instagram:1.0.0 check --config source_config.json 2022-11-03 14:22:24 INFO i.a.w.i.DefaultAirbyteStreamFactory(internalLog):117 - Available accounts: [{'page_id': '102749291163959', 'instagram_business_account': { "id": "17841421145487667" }}, {'page_id': '103060399076772', 'instagram_business_account': { "id": "17841452674376878" }}, {'page_id': '104664184731323', 'instagram_business_account': { "id": "17841440493306537" }}, {'page_id': '105860508692773', 'instagram_business_account': { "id": "17841452328191037" }}, {'page_id': '112693045416373', 'instagram_business_account': { "id": "17841400844997659" }}, {'page_id': '125387384800730', 'instagram_business_account': { "id": "17841406448385387" }}, {'page_id': '170433679646459', 'instagram_business_account': { "id": "17841400657993479" }}, {'page_id': '186733888443088', 'instagram_business_account': { "id": "17841403860219174" }}, {'page_id': '759141440879871', 'instagram_business_account': { "id": "17841417388884180" }}, {'page_id': '785571031595001', 'instagram_business_account': { "id": "17841401993121167" }}] 2022-11-03 14:22:24 INFO i.a.w.i.DefaultAirbyteStreamFactory(internalLog):117 - Check succeeded 2022-11-03 14:22:24 INFO i.a.w.t.TemporalAttemptExecution(get):162 - Stopping cancellation check scheduling... 2022-11-03 14:22:24 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-11-03 14:22:24 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- END CHECK ----- 2022-11-03 14:22:24 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-11-03 14:22:24 INFO i.a.w.t.TemporalAttemptExecution(get):136 - Docker volume job log path: /tmp/workspace/887/1/logs.log 2022-11-03 14:22:24 INFO i.a.w.t.TemporalAttemptExecution(get):141 - Executing worker wrapper. Airbyte version: 0.40.16 2022-11-03 14:22:24 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-11-03 14:22:24 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- START CHECK ----- 2022-11-03 14:22:24 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-11-03 14:22:24 INFO i.a.c.i.LineGobbler(voidCall):114 - Checking if airbyte/destination-bigquery:1.2.5 exists... 2022-11-03 14:22:24 INFO i.a.c.i.LineGobbler(voidCall):114 - airbyte/destination-bigquery:1.2.5 was found locally. 2022-11-03 14:22:24 INFO i.a.w.p.DockerProcessFactory(create):119 - Creating docker container = destination-bigquery-check-887-1-uniwn with resources io.airbyte.config.ResourceRequirements@3dd35bf6[cpuRequest=,cpuLimit=,memoryRequest=,memoryLimit=] 2022-11-03 14:22:24 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/887/1 --log-driver none --name destination-bigquery-check-887-1-uniwn --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=true -e WORKER_ENVIRONMENT=DOCKER -e AIRBYTE_ROLE= -e WORKER_JOB_ATTEMPT=1 -e WORKER_CONNECTOR_IMAGE=airbyte/destination-bigquery:1.2.5 -e AIRBYTE_VERSION=0.40.16 -e WORKER_JOB_ID=887 airbyte/destination-bigquery:1.2.5 check --config source_config.json 2022-11-03 14:22:29 INFO i.a.w.i.DefaultAirbyteStreamFactory(internalLog):117 - integration args: {check=null, config=source_config.json} 2022-11-03 14:22:29 INFO i.a.w.i.DefaultAirbyteStreamFactory(internalLog):117 - Running integration: io.airbyte.integrations.destination.bigquery.BigQueryDestination 2022-11-03 14:22:29 INFO i.a.w.i.DefaultAirbyteStreamFactory(internalLog):117 - Command: CHECK 2022-11-03 14:22:29 INFO i.a.w.i.DefaultAirbyteStreamFactory(internalLog):117 - Integration config: IntegrationConfig{command=CHECK, configPath='source_config.json', catalogPath='null', statePath='null'} 2022-11-03 14:22:29 WARN i.a.w.i.DefaultAirbyteStreamFactory(internalLog):114 - Unknown keyword order - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-11-03 14:22:29 WARN i.a.w.i.DefaultAirbyteStreamFactory(internalLog):114 - Unknown keyword airbyte_secret - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-11-03 14:22:29 INFO i.a.w.i.DefaultAirbyteStreamFactory(internalLog):117 - Selected loading method is set to: STANDARD 2022-11-03 14:22:31 INFO i.a.w.i.DefaultAirbyteStreamFactory(internalLog):117 - Completed integration: io.airbyte.integrations.destination.bigquery.BigQueryDestination 2022-11-03 14:22:31 INFO i.a.w.t.TemporalAttemptExecution(get):162 - Stopping cancellation check scheduling... 2022-11-03 14:22:31 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-11-03 14:22:31 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- END CHECK ----- 2022-11-03 14:22:31 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-11-03 14:22:32 INFO i.a.w.t.TemporalAttemptExecution(get):136 - Docker volume job log path: /tmp/workspace/887/1/logs.log 2022-11-03 14:22:32 INFO i.a.w.t.TemporalAttemptExecution(get):141 - Executing worker wrapper. Airbyte version: 0.40.16 2022-11-03 14:22:32 INFO i.a.c.f.EnvVariableFeatureFlags(getEnvOrDefault):50 - Using default value for environment variable LOG_CONNECTOR_MESSAGES: 'false' 2022-11-03 14:22:32 INFO i.a.c.EnvConfigs(getEnvOrDefault):1091 - Using default value for environment variable METRIC_CLIENT: '' 2022-11-03 14:22:32 WARN i.a.m.l.MetricClientFactory(initialize):60 - Metric client is already initialized to 2022-11-03 14:22:32 INFO i.a.c.f.EnvVariableFeatureFlags(getEnvOrDefault):50 - Using default value for environment variable LOG_CONNECTOR_MESSAGES: 'false' 2022-11-03 14:22:32 INFO i.a.w.g.DefaultReplicationWorker(run):125 - start sync worker. job id: 887 attempt id: 1 2022-11-03 14:22:32 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-11-03 14:22:32 INFO i.a.w.g.DefaultReplicationWorker(run):141 - configured sync modes: {null.media_insights=full_refresh - overwrite, null.stories=full_refresh - overwrite, null.story_insights=full_refresh - overwrite, null.user_lifetime_insights=full_refresh - append, null.users=full_refresh - overwrite, null.media=full_refresh - overwrite, null.user_insights=incremental - append} 2022-11-03 14:22:32 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- START REPLICATION ----- 2022-11-03 14:22:32 INFO i.a.w.i.DefaultAirbyteDestination(start):65 - Running destination... 2022-11-03 14:22:32 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-11-03 14:22:32 INFO i.a.c.i.LineGobbler(voidCall):114 - Checking if airbyte/destination-bigquery:1.2.5 exists... 2022-11-03 14:22:32 INFO i.a.c.i.LineGobbler(voidCall):114 - airbyte/destination-bigquery:1.2.5 was found locally. 2022-11-03 14:22:32 INFO i.a.w.p.DockerProcessFactory(create):119 - Creating docker container = destination-bigquery-write-887-1-cpmvs with resources io.airbyte.config.ResourceRequirements@27ce573b[cpuRequest=,cpuLimit=,memoryRequest=,memoryLimit=] 2022-11-03 14:22:32 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/887/1 --log-driver none --name destination-bigquery-write-887-1-cpmvs --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=true -e WORKER_ENVIRONMENT=DOCKER -e AIRBYTE_ROLE= -e WORKER_JOB_ATTEMPT=1 -e WORKER_CONNECTOR_IMAGE=airbyte/destination-bigquery:1.2.5 -e AIRBYTE_VERSION=0.40.16 -e WORKER_JOB_ID=887 airbyte/destination-bigquery:1.2.5 write --config destination_config.json --catalog destination_catalog.json 2022-11-03 14:22:32 INFO i.a.c.i.LineGobbler(voidCall):114 - Checking if airbyte/source-instagram:1.0.0 exists... 2022-11-03 14:22:32 INFO i.a.c.i.LineGobbler(voidCall):114 - airbyte/source-instagram:1.0.0 was found locally. 2022-11-03 14:22:32 INFO i.a.w.p.DockerProcessFactory(create):119 - Creating docker container = source-instagram-read-887-1-kceaf with resources io.airbyte.config.ResourceRequirements@164c2109[cpuRequest=,cpuLimit=,memoryRequest=,memoryLimit=] 2022-11-03 14:22:32 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/887/1 --log-driver none --name source-instagram-read-887-1-kceaf --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=true -e WORKER_ENVIRONMENT=DOCKER -e AIRBYTE_ROLE= -e WORKER_JOB_ATTEMPT=1 -e WORKER_CONNECTOR_IMAGE=airbyte/source-instagram:1.0.0 -e AIRBYTE_VERSION=0.40.16 -e WORKER_JOB_ID=887 airbyte/source-instagram:1.0.0 read --config source_config.json --catalog source_catalog.json --state input_state.json 2022-11-03 14:22:32 INFO i.a.w.g.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$7):454 - Destination output thread started. 2022-11-03 14:22:32 INFO i.a.w.g.DefaultReplicationWorker(run):185 - Waiting for source and destination threads to complete. 2022-11-03 14:22:32 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):339 - Replication thread started. 2022-11-03 14:22:33 source > Starting syncing SourceInstagram 2022-11-03 14:22:33 source > Syncing stream: media 2022-11-03 14:22:34 destination > integration args: {catalog=destination_catalog.json, write=null, config=destination_config.json} 2022-11-03 14:22:34 destination > Running integration: io.airbyte.integrations.destination.bigquery.BigQueryDestination 2022-11-03 14:22:34 destination > Command: WRITE 2022-11-03 14:22:34 destination > Integration config: IntegrationConfig{command=WRITE, configPath='destination_config.json', catalogPath='destination_catalog.json', statePath='null'} 2022-11-03 14:22:35 destination > Unknown keyword order - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-11-03 14:22:35 destination > Unknown keyword airbyte_secret - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-11-03 14:22:35 destination > Selected loading method is set to: STANDARD 2022-11-03 14:22:35 destination > The "standard" upload mode is not performant, and is not recommended for production. Please use the GCS upload mode if you are syncing a large amount of data. 2022-11-03 14:22:35 destination > Selected loading method is set to: STANDARD 2022-11-03 14:22:35 source > /usr/local/lib/python3.9/site-packages/facebook_business/utils/api_utils.py:30: UserWarning: media does not allow field children 2022-11-03 14:22:35 source > warnings.warn(message) 2022-11-03 14:22:36 destination > Partitioned table created successfully: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, tableId=_airbyte_tmp_bmn_instagram_media}} 2022-11-03 14:22:36 destination > Selected loading method is set to: STANDARD 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 destination > Selected loading method is set to: STANDARD 2022-11-03 14:22:37 destination > Partitioned table created successfully: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, tableId=_airbyte_tmp_bpy_instagram_media_insights}} 2022-11-03 14:22:37 destination > Selected loading method is set to: STANDARD 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:37 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000 2022-11-03 14:22:38 destination > Selected loading method is set to: STANDARD 2022-11-03 14:22:38 destination > Partitioned table created successfully: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, tableId=_airbyte_tmp_ijk_instagram_stories}} 2022-11-03 14:22:38 destination > Selected loading method is set to: STANDARD 2022-11-03 14:22:38 destination > Selected loading method is set to: STANDARD 2022-11-03 14:22:39 destination > Partitioned table created successfully: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, tableId=_airbyte_tmp_wfe_instagram_story_insights}} 2022-11-03 14:22:39 destination > Selected loading method is set to: STANDARD 2022-11-03 14:22:39 destination > Selected loading method is set to: STANDARD 2022-11-03 14:22:39 destination > Partitioned table created successfully: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, tableId=_airbyte_tmp_ihr_instagram_user_insights}} 2022-11-03 14:22:39 destination > Selected loading method is set to: STANDARD 2022-11-03 14:22:40 destination > Selected loading method is set to: STANDARD 2022-11-03 14:22:40 destination > Partitioned table created successfully: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, tableId=_airbyte_tmp_daw_instagram_user_lifetime_insights}} 2022-11-03 14:22:40 destination > Selected loading method is set to: STANDARD 2022-11-03 14:22:40 destination > Selected loading method is set to: STANDARD 2022-11-03 14:22:41 destination > Partitioned table created successfully: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=misc, tableId=_airbyte_tmp_tnr_instagram_users}} 2022-11-03 14:22:41 destination > Selected loading method is set to: STANDARD 2022-11-03 14:23:02 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):369 - Records read: 1000 (925 KB) 2022-11-03 14:24:28 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):369 - Records read: 2000 (2 MB) 2022-11-03 14:26:25 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):369 - Records read: 3000 (3 MB) 2022-11-03 14:26:29 source > Read 3487 records from media stream 2022-11-03 14:26:29 source > Finished syncing media 2022-11-03 14:26:29 source > SourceInstagram runtimes: Syncing stream media 0:03:56.464724 2022-11-03 14:26:29 source > Syncing stream: media_insights 2022-11-03 14:27:40 source > /usr/local/lib/python3.9/site-packages/facebook_business/utils/api_utils.py:30: UserWarning: value of metric might not be compatible. Expect list; got 2022-11-03 14:27:40 source > warnings.warn(message) 2022-11-03 14:28:57 source > Backing off call(...) for 5.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17866676527332611/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AMcQ93UNA9_xjrkZJ-rOa25" } }) 2022-11-03 14:29:03 source > Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17866676527332611/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AMcQ93UNA9_xjrkZJ-rOa25" } } 2022-11-03 14:29:03 source > Caught retryable error after 1 tries. Waiting 5 more seconds then retrying... 2022-11-03 14:29:03 source > Backing off call(...) for 10.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17866676527332611/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AZoH7sT40NPRoQKmT0qLAJT" } }) 2022-11-03 14:29:13 source > Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17866676527332611/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AZoH7sT40NPRoQKmT0qLAJT" } } 2022-11-03 14:29:13 source > Caught retryable error after 2 tries. Waiting 10 more seconds then retrying... 2022-11-03 14:29:13 source > Backing off call(...) for 20.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17866676527332611/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AOkI1eq_BgEgtffiRhpUd8W" } }) 2022-11-03 14:29:33 source > Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17866676527332611/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AOkI1eq_BgEgtffiRhpUd8W" } } 2022-11-03 14:29:33 source > Caught retryable error after 3 tries. Waiting 20 more seconds then retrying... 2022-11-03 14:29:33 source > Backing off call(...) for 40.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17866676527332611/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AZulQDj-f9XyE3a_UtK2Xsp" } }) 2022-11-03 14:30:13 source > Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17866676527332611/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AZulQDj-f9XyE3a_UtK2Xsp" } } 2022-11-03 14:30:13 source > Caught retryable error after 4 tries. Waiting 40 more seconds then retrying... 2022-11-03 14:30:13 source > Backing off call(...) for 80.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17866676527332611/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AjS0nlhW9EgciaiCgv0XiJz" } }) 2022-11-03 14:31:33 source > Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17866676527332611/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "AjS0nlhW9EgciaiCgv0XiJz" } } 2022-11-03 14:31:33 source > Caught retryable error after 5 tries. Waiting 80 more seconds then retrying... 2022-11-03 14:31:33 source > Backing off call(...) for 160.0s (facebook_business.exceptions.FacebookRequestError: Message: Call was not successful Method: GET Path: https://graph.facebook.com/v11.0/17866676527332611/insights Params: {'metric': '["engagement","impressions","reach","saved"]'} Status: 400 Response: { "error": { "message": "Invalid parameter", "type": "OAuthException", "code": 100, "error_data": { "blame_field_specs": [ [ "" ] ] }, "error_subcode": 2108006, "is_transient": false, "error_user_title": "Media posted before business account conversion", "error_user_msg": "The media was posted before the most recent time that the user's account was converted to a business account from a personal account.", "fbtrace_id": "APAmb3ycPdbNu4lCIuT4f4a" } })