how i can find error in this log? i find this, ``...
# ask-community-for-troubleshooting
v
how i can find error in this log? i find this,
Copy code
2022-06-21 16:11:17 INFO i.a.v.j.JsonSchemaValidator(test):56 - JSON schema validation failed. 
errors: $.client_id: is missing but it is required, $.client_secret: is missing but it is required, $.refresh_token: is missing but it is required, $.credentials_title: must be a constant value OAuth Credentials
2022-06-21 16:11:16 INFO i.a.w.p.KubePodProcess(close):710 - (pod: airbyte / normalization-redshift-sync-1100-0-ixioh) - Closed all resources for pod
2022-06-21 16:11:16 INFO i.a.w.t.TemporalAttemptExecution(lambda$getWorkerThread$2):158 - Completing future exceptionally...
But i dont know why, source as Hubspot and Destination as Redshift
or this is a error :
Copy code
16:02:53.944441 [debug] [Thread-3  ]: Postgres adapter: Postgres error: Invalid data
2022-06-21 16:11:15 [42mnormalization[0m > DETAIL:  
2022-06-21 16:11:15 [42mnormalization[0m >   -----------------------------------------------
2022-06-21 16:11:15 [42mnormalization[0m >   error:  Invalid data
2022-06-21 16:11:15 [42mnormalization[0m >   code:      8001
2022-06-21 16:11:15 [42mnormalization[0m >   context:   Invalid format or data given: 1655815361218
2022-06-21 16:11:15 [42mnormalization[0m >   query:     5486269
2022-06-21 16:11:15 [42mnormalization[0m >   location:  funcs_timestamp.cpp:274
2022-06-21 16:11:15 [42mnormalization[0m >   process:   query0_85_5486269 [pid=22296]
m
Copy code
2022-06-21 16:00:44 [44msource[0m > Encountered an exception while reading stream property_history
Traceback (most recent call last):
  File "/airbyte/integration_code/source_hubspot/source.py", line 170, in read
    yield from self._read_stream(
  File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py", line 165, in _read_stream
    for record in record_iterator:
  File "/airbyte/integration_code/source_hubspot/source.py", line 202, in _read_incremental
    yield from super()._read_incremental(
  File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py", line 221, in _read_incremental
    for record_counter, record_data in enumerate(records, start=1):
  File "/airbyte/integration_code/source_hubspot/streams.py", line 664, in read_records
    for record in records:
  File "/airbyte/integration_code/source_hubspot/streams.py", line 370, in read_records
    raise e
  File "/airbyte/integration_code/source_hubspot/streams.py", line 351, in read_records
    response = self.handle_request(
  File "/airbyte/integration_code/source_hubspot/streams.py", line 297, in handle_request
    response = self._send_request(request, request_kwargs)
  File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/streams/http/http.py", line 336, in _send_request
    return backoff_handler(user_backoff_handler)(request, request_kwargs)
  File "/usr/local/lib/python3.9/site-packages/backoff/_sync.py", line 94, in retry
    ret = target(*args, **kwargs)
  File "/usr/local/lib/python3.9/site-packages/backoff/_sync.py", line 94, in retry
    ret = target(*args, **kwargs)
  File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/streams/http/http.py", line 301, in _send
    raise exc
  File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/streams/http/http.py", line 298, in _send
    response.raise_for_status()
  File "/usr/local/lib/python3.9/site-packages/requests/models.py", line 953, in raise_for_status
    raise HTTPError(http_error_msg, response=self)
requests.exceptions.HTTPError: 400 Client Error: Bad Request for url: <https://api.hubapi.com/contacts/v1/lists/recently_updated/contacts/recent?hapikey=*****&limit=100&vidOffset=29213951&startTimestamp=1642464000000&endTimestamp=1645056000000&propertyMode=value_and_history&property=capital_de_investimento&property=cidade_de_interesse&property=cnpj&property=cnpj_2&property=cnpj_3&property=cnpj_de_quem_indicou&property=company_size&property=comunicacao_tiquete&property=cpf&property=date_of_birth&property=days_to_close&property=degree&property=empresa&property=executivo_de_vendas&property=faturamento_mensal&property=field_of_study&property=first_conversion_date&property=first_conversion_event_name&property=first_deal_created_date&property=formulario&property=gender&property=graduation_date&property=historico&property=hs_additional_emails&property=hs_all_contact_vids&property=hs_analytics_first_touch_converting_campaign&property=hs_analytics_last_touch_converting_campaign&property=hs_avatar_filemanager_key&property=hs_buying_role&property=hs_calculated_form_submissions&property=hs_calculated_merged_vids&property=hs_calculated_mobile_number&property=hs_calculated_phone_number&property=hs_calculated_phone_number_area_code&property=hs_calculated_phone_number_country_code&property=hs_calculated_phone_number_region_code&property=hs_clicked_linkedin_ad&property=hs_content_membership_email_confirmed&property=hs_content_membership_notes&property=hs_content_membership_registered_at&property=hs_content_membership_registration_domain_sent_to&property=hs_content_membership_registration_email_sent_at&property=hs_content_membership_status&property=hs_conversations_visitor_email&property=hs_count_is_unworked&property=hs_count_is_worked&property=hs_created_by_conversations&property=hs_created_by_user_id&property=hs_createdate&property=hs_date_entered_customer&property=hs_date_entered_evangelist&property=hs_date_entered_lead&property=hs_date_entered_marketingqualifiedlead&property=hs_date_entered_opportunity&property=hs_date_entered_other&property=hs_date_entered_salesqualifiedlead&property=hs_date_entered_subscriber&property=hs_date_exited_customer&property=hs_date_exited_evangelist&property=hs_date_exited_lead&property=hs_date_exited_marketingqualifiedlead&property=hs_date_exited_opportunity&property=hs_date_exited_other&property=hs_date_exited_salesqualifiedlead&property=hs_date_exited_subscriber&property=hs_document_last_revisited&property=hs_email_bad_address&property=hs_email_customer_quarantined_reason&property=hs_email_domain&property=hs_email_hard_bounce_reason&property=hs_email_hard_bounce_reason_enum&property=hs_email_quarantined&property=hs_email_quarantined_reason&property=hs_email_sends_since_last_engagement&property=hs_emailconfirmationstatus&property=hs_facebook_ad_clicked&property=hs_facebook_click_id&property=hs_feedback_last_nps_follow_up&property=hs_feedback_last_nps_rating&property=hs_feedback_last_survey_date&property=hs_feedback_show_nps_web_survey&property=hs_first_engagement_object_id&property=hs_first_subscription_create_date&property=hs_google_click_id&property=hs_has_active_subscription&property=hs_ip_timezone&property=hs_is_contact&property=hs_is_unworked&property=hs_last_sales_activity_date&property=hs_last_sales_activity_timestamp&property=hs_lastmodifieddate&property=hs_latest_sequence_ended_date&property=hs_latest_sequence_enrolled&property=hs_latest_sequence_enrolled_date&property=hs_latest_sequence_finished_date&property=hs_latest_sequence_unenrolled_date&property=hs_latest_subscription_create_date&property=hs_lead_status&property=hs_legal_basis&property=hs_linkedin_ad_clicked&property=hs_marketable_reason_id&property=hs_marketable_reason_type&property=hs_marketable_status&property=hs_marketable_until_renewal&property=hs_merged_object_ids&property=hs_object_id&property=hs_pinned_engagement_id&property=hs_pipeline&property=hs_sa_first_engagement_date&property=hs_sa_first_engagement_descr&property=hs_sa_first_engagement_object_type&property=hs_sales_email_last_clicked&property=hs_sales_email_last_opened&property=hs_searchable_calculated_international_mobile_number&property=hs_searchable_calculated_international_phone_number&property=hs_searchable_calculated_mobile_number&property=hs_searchable_calculated_phone_number&property=hs_sequences_actively_enrolled_count&property=hs_sequences_enrolled_count&property=hs_sequences_is_enrolled&property=hs_testpurge&property=hs_testrollback&property=hs_time_between_contact_creation_and_deal_close&property=hs_time_between_contact_creation_and_deal_creation&property=hs_time_in_customer&property=hs_time_in_evangelist&property=hs_time_in_lead&property=hs_time_in_marketingqualifiedlead&property=hs_time_in_opportunity&property=hs_time_in_other&property=hs_time_in_salesqualifiedlead&property=hs_time_in_subscriber&property=hs_time_to_first_engagement&property=hs_time_to_move_from_lead_to_customer&property=hs_time_to_move_from_marketingqualifiedlead_to_customer&property=hs_time_to_move_from_opportunity_to_customer&property=hs_time_to_move_from_salesqualifiedlead_to_customer&property=hs_time_to_move_from_subscriber_to_customer&property=hs_timezone&property=hs_unique_creation_key&property=hs_updated_by_user_id&property=hs_user_ids_of_all_notification_followers&property=hs_user_ids_of_all_notification_unfollowers&property=hs_user_ids_of_all_owners&property=hubspot_owner_assigneddate&property=hubspot_teste&property=ip_city&property=ip_country&property=ip_country_code&property=ip_latlon&property=ip_state&property=ip_state_code&property=ip_zipcode&property=ja_e_cliente_q2_&property=job_function&property=lastmodifieddate&property=licenciado&property=licenciado_onboarding&property=marital_status&property=military_status&property=nome_completo&property=nome_de_quem_indicou&property=nome_fantasia&property=num_associated_deals&property=num_conversion_events&property=num_unique_conversion_events&property=pessoa_fisica_ou_juridica&property=qual_a_sua_atividade_atual&property=qual_a_sua_atividade_atual_&property=quantas_mquinas_de_carto_voc_vende_por_ms_&property=quantidade_de_maquinas&property=quanto_investiria_para_ser_um_licenciado_&property=ramo_de_atividade&property=recent_conversion_date&property=recent_conversion_event_name&property=recent_deal_amount&property=recent_deal_close_date&property=relationship_status&property=school&property=seniority&property=start_date&property=telefone&property=tipo_de_cadastro&property=total_revenue&property=treble_created&property=treble_synced&property=whatsapp&property=work_email&property=zoom_webinar_attendance_average_duration&property=zoom_webinar_attendance_count&property=zoom_webinar_joinlink&property=zoom_webinar_registration_count&property=firstname&property=hs_analytics_first_url&property=hs_email_delivered&property=hs_email_optout_14845720&property=hs_email_optout_16032491&property=hs_email_optout_16105464&property=twitterhandle&property=calendly_question_1&property=currentlyinworkflow&property=hs_analytics_last_url&property=hs_email_open&property=lastname&property=calendly_answer_1&property=hs_analytics_num_page_views&property=hs_email_click&property=salutation&property=calendly_question_2&property=email&property=hs_analytics_num_visits&property=hs_email_bounce&property=hs_persona&property=calendly_answer_2&property=hs_analytics_num_event_completions&property=hs_email_optout&property=mobilephone&property=phone&property=calendly_question_3&property=fax&property=hs_analytics_first_timestamp&property=hs_email_last_email_name&property=hs_email_last_send_date&property=address&property=calendly_answer_3&property=engagements_last_meeting_booked&property=engagements_last_meeting_booked_campaign&property=engagements_last_meeting_booked_medium&property=engagements_last_meeting_booked_source&property=hs_analytics_first_visit_timestamp&property=hs_email_last_open_date&property=hs_latest_meeting_activity&property=hs_sales_email_last_replied&property=hubspot_owner_id&property=notes_last_contacted&property=notes_last_updated&property=notes_next_activity_date&property=num_contacted_notes&property=num_notes&property=surveymonkeyeventlastupdated&property=webinareventlastupdated&property=calendly_question_4&property=city&property=hs_analytics_last_timestamp&property=hs_email_last_click_date&property=hubspot_team_id&property=calendly_answer_4&property=hs_all_owner_ids&property=hs_analytics_last_visit_timestamp&property=hs_email_first_send_date&property=state&property=calendly_question_5&property=hs_all_team_ids&property=hs_analytics_source&property=hs_email_first_open_date&property=hs_latest_source&property=zip&property=calendly_answer_5&property=country&property=hs_all_accessible_team_ids&property=hs_analytics_source_data_1&property=hs_email_first_click_date&property=hs_latest_source_data_1&property=calendly_question_6&property=hs_analytics_source_data_2&property=hs_email_is_ineligible&property=hs_language&property=hs_latest_source_data_2&property=calendly_answer_6&property=hs_analytics_first_referrer&property=hs_email_first_reply_date&property=jobtitle&property=calendly_question_7&property=hs_analytics_last_referrer&property=hs_email_last_reply_date&property=message&property=calendly_ans>