Hey folks, trying out airbyte for the first time. ...
# ask-community-for-troubleshootinga
Arka Bhattacharya
09/14/2022, 6:31 PMHey folks, trying out airbyte for the first time. Following this document https://airbyte.com/connections/HubSpot-to-Redshift to setup a hubspot to redshift connection. Was able to setup the source and destination right. However, each time I go to sync it says successful without any bytes or records moved
m
Marcos Marx (Airbyte)
09/14/2022, 6:37 PMCheck your start date and maybe execute a postman request to make sure your account has access to data
a
Arka Bhattacharya
09/14/2022, 6:42 PMThank you for responding, @Marcos Marx (Airbyte) I am assuming you mean the start date while setting up the Hubspot source? If yes, then I just backdated it on Hubspot and tried doing a sync again. Same result, unfortunately
m
Marcos Marx (Airbyte)
09/14/2022, 6:43 PMweird, if you do a curl call to an endppint in hubspot
Marcos Marx (Airbyte)
09/14/2022, 6:43 PMdoes it work
Marcos Marx (Airbyte)
09/14/2022, 6:43 PM?
a
Arka Bhattacharya
09/14/2022, 6:45 PMreturns a lot of Node.js code but yes
Arka Bhattacharya
09/14/2022, 7:40 PMOK. So I was checking the logs and I see an error like:
Copy code
airbyte-worker | 2022-09-14 19:38:32 ERROR i.a.w.g.DefaultNormalizationWorker(run):90 - Normalization Failed.
airbyte-worker | 2022-09-14 19:38:32 INFO i.a.w.g.DefaultNormalizationWorker(run):95 - Normalization summary: io.airbyte.config.NormalizationSummary@567ec023[startTime=1663183040030,endTime=1663184312784,failures=[io.airbyte.config.FailureReason@5f2f7141[failureOrigin=normalization,failureType=system_error,internalMessage=SSL SYSCALL error: EOF detected,externalMessage=Normalization failed during the dbt run. This may indicate a problem with the data itself.,metadata=io.airbyte.config.Metadata@71c98d45[additionalProperties={attemptNumber=1, jobId=7, from_trace_message=true}],stacktrace=AirbyteDbtError:
airbyte-worker | 28 of 75 ERROR creating table model public.airbyte_contact_lists_metadata............................................... [ERROR in 774.35s]
airbyte-worker | 58 of 75 SKIP relation public.airbyte_property_history_properties due to ephemeral model error.......................... [ERROR SKIP]
airbyte-worker | Database Error in model airbyte_property_history_properties_ab1 (models/generated/airbyte_ctes/public/airbyte_property_history_properties_ab1.sql)
airbyte-worker | SSL SYSCALL error: EOF detected,retryable=<null>,timestamp=1663184312770], io.airbyte.config.FailureReason@3e4b5dfd[failureOrigin=normalization,failureType=system_error,internalMessage=SSL SYSCALL error: EOF detected,externalMessage=Normalization failed during the dbt run. This may indicate a problem with the data itself.,metadata=io.airbyte.config.Metadata@1e14fdcf[additionalProperties={attemptNumber=1, jobId=7, from_trace_message=true}],stacktrace=AirbyteDbtError:
airbyte-worker | 28 of 75 ERROR creating table model public.airbyte_contact_lists_metadata............................................... [ERROR in 774.35s]
airbyte-worker | 58 of 75 SKIP relation public.airbyte_property_history_properties due to ephemeral model error.......................... [ERROR SKIP]