Can anyone help me with this conversion error?
`I...
# ask-community-for-troubleshootingc
CM
05/22/2022, 2:05 PMCan anyone help me with this conversion error?
Copy code
Is this your first time deploying Airbyte?: Yes
OS Version / Instance: Windows
Memory / Disk: 16 gb / 1 tb
Deployment: Docker
Airbyte Version: Latest
Source name/version: Facebook Marketing 0.2.48
Destination name/version: MS SQL Server 0.1.17
Step: The issue happens at the end of the sync
Description: Everything seems to go well, then I get this error and sync fails to complete:
(‘42000’, ‘[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Error converting data type nvarchar to float. (8114) (SQLMoreResults)m
Marcos Marx (Airbyte)
05/23/2022, 5:25 PMPlease can you post the complete log file here.
V
c
CM
05/23/2022, 8:08 PMlooks like it has something to do with ads_account
m
Marcos Marx (Airbyte)
05/23/2022, 8:17 PMAre you using a default account for facebook?
Copy code
"message": "(#17) User request limit reached",Marcos Marx (Airbyte)
05/23/2022, 8:17 PMyou need to ask for a developer account to increase your quota limit
c
CM
05/23/2022, 8:24 PMYes, with a developper account I created an app to get API access. After retrying it ends up being able to make some calls and populate the database. It's only this one table that seems to create an error and fail the synch.
CM
05/23/2022, 8:52 PMOk, I have removed other tables and isolated only ad_account. Now there's no quota limit reached, but still the same conversion error.
m
Marcos Marx (Airbyte)
05/23/2022, 9:05 PMLooks it's a problem with schema: $.tax_id: string found, but [null, number] is required
Marcos Marx (Airbyte)
05/23/2022, 9:06 PMso Airbyte tries to convert this to float but it's a string
c
CM
05/23/2022, 9:06 PMexactly what I was writing at the moment. tax ids in Canada contain a letter.
CM
05/23/2022, 9:06 PMso when it tries to convert to float at the end, there's an error
m
Marcos Marx (Airbyte)
05/23/2022, 9:07 PMno way!
Marcos Marx (Airbyte)
05/23/2022, 9:08 PMyou probably need to change the schema to string, do you mind submitting a PR to fix it?
c
CM
05/23/2022, 9:31 PMfirst time doing this, would you mind reviewing my process? https://github.com/airbytehq/airbyte/pull/13109
m
Marcos Marx (Airbyte)
05/24/2022, 2:16 PMWhy did you close the pr?
c
CM
05/26/2022, 3:18 PM@Marcos Marx (Airbyte) Sorry for the delay, been busy with work. I closed the PR because I realized I didn't follow the guidelines (i had never done PR before). should i open an issue that someone could try and resolve? thanks
2 Views