Sync Failing: Normalization Failed (MSSQL --> MySQL)

Troubleshooting
#1
  • Is this your first time deploying Airbyte?: Yes
  • OS Version / Instance: Window
  • Memory / Disk:
  • Deployment: Docker
  • Airbyte Version: 0.35.65-alpha
  • Source name/version: MSSQL (2019)
  • Destination name/version: MySQL (8.0.28)
  • Step: The issue is happening during sync
  • Description:

I successfully add one source (MSSQL) and one destination (MySQL) but I’m facing a problem: Normalized tabular data failed.

Capture1
Capture11302×722 53.7 KB

logs:
logs-28.txt (27.2 KB)

However, when I select “Raw data (JSON)” it’s working properly but it’s not the way I want my data to be in the destination database. I don’t want a column “_airbyte_data” with all my data but a column “id”, a column “date”, etc …

Capture2
Capture21277×103 12.8 KB

logs:
logs-30.txt (17.9 KB)

What am I missing ?
Thank you for your answer.

#2

Hey @Atliax17 do you mind checking the transformation section and enable basic normalisation so that we normalise the data in _airbyte_data column

#3

Yes of course @harshith , the error i got (in the first log) is when I enable “Normalized tabular data”.

Capture3
Capture31112×596 32.2 KB

#5

Any suggestion ?

Best regards.

#6

The same happened with me
Topic
Issue

#7

Hey @Atliax17 can you help us by commenting over the github issue so that team can look into it

#8

I found a temporary solution : downgrading Airbyte Version from 0.35.65-alpha to 0.35.60-alpha.

git clone -b v0.35.60-alpha --single-branch https://github.com/airbytehq/airbyte.git