Hi Team, We have just setup Airbyte to import into...
# advice-data-transformationk
Kris Houston
05/25/2022, 4:37 AMHi Team, We have just setup Airbyte to import into our PostgreSQL data warehouse but when we enable the normalisation process it continues to fail. Setting the normalisation to Raw Data (JSON) competes successfully. Here is part of the error log.
io.airbyte.workers.WorkerException: Normalization Failed.at io.airbyte.workers.DefaultNormalizationWorker.run(DefaultNormalizationWorker.java:61) ~[io.airbyte-airbyte-workers-0.38.4-alpha.jar:?]at io.airbyte.workers.DefaultNormalizationWorker.run(DefaultNormalizationWorker.java:19) ~[io.airbyte-airbyte-workers-0.38.4-alpha.jar:?]at io.airbyte.workers.temporal.TemporalAttemptExecution.lambda$getWorkerThread$2(TemporalAttemptExecution.java:158) ~[io.airbyte-airbyte-workers-0.38.4-alpha.jar:?]at java.lang.Thread.run(Thread.java:833) [?:?]m
Marcos Marx (Airbyte)
05/25/2022, 5:09 PMHello @Kris Houston we’re moving our support to discuss can you use the template and post there? https://discuss.airbyte.io/ This channel si for general data transformation discussion
k
Kris Houston
05/25/2022, 10:13 PMI've posted it here. https://discuss.airbyte.io/t/normalization-process-wasnt-keeps-failing/1217
m
Marcos Marx (Airbyte)
05/25/2022, 10:14 PMcan you post the complete file log?
Marcos Marx (Airbyte)
05/25/2022, 10:15 PMposting only the line saying normalization failed doesn’t allow us discovery the root cause of failure…
k
Kris Houston
05/25/2022, 10:17 PMi've now attached the log to the discussion
Kris Houston
06/01/2022, 2:34 AMHi @Marcos Marx (Airbyte) . I'm still seeing the connection job failing. I see in the destination DB, plenty of tmp and raw tables but no normalised tables. I have attached the log to this thread.
3 Views