I'm using airbyte OSS and I'm using source faceboo...
# replication-troubleshooting
r
I'm using airbyte OSS and I'm using source facebook pages with destination bigquery and the error
Copy code
Failure Origin: normalization, Message: Something went wrong during normalization
full log attached could you help me to solve this error please?
u
Hello Rafael, could you try to upgrade to latest version of Airbyte. One version was introduced an issue with data types and latest version correct it.
r
updated to 0.40.32 and it still runs unsuccessfully, log attached
m
Could you try to update the connector schema too?
m
I noticed that fetching
comments
from
post_insights
has no pagination, if you have lots of a comment on a post: GraphQl will throw you this error Line 371 in attached logs (I am up to data on Airbyte 0.40.32 and on each connector FB and BQ)
Copy code
airbyte_cdk.sources.declarative.exceptions.ReadException: Request to https://graph.facebook.com/v15.0/1781736778715043/posts?fields=id%2Cactions%2Cadmin_creator%2Capplication%2Cbackdated_time%2Ccall_to_action%2Ccan_reply_privately%2Cchild_attachments%2Ccoordinates%2Ccreated_time%2Cevent%2Cexpanded_height%2Cexpanded_width%2Cfeed_targeting%2Cfrom%2Cheight%2Cicon%2Cinstagram_eligibility%2Cis_eligible_for_promotion%2Cis_expired%2Cis_hidden%2Cis_inline_created%2Cis_instagram_eligible%2Cis_popular%2Cis_published%2Cis_spherical%2Cmessage%2Cmessage_tags%2Cmulti_share_end_card%2Cmulti_share_optimized%2Cparent_id%2Cpermalink_url%2Cplace%2Cprivacy%2Cpromotable_id%2Cpromotion_status%2Cproperties%2Cscheduled_publish_time%2Cshares%2Cstatus_type%2Cstory%2Cstory_tags%2Csubscribed%2Ctarget%2Ctargeting%2Ctimeline_visibility%2Cupdated_time%2Cvia%2Cvideo_buying_eligibility%2Cwidth%2Ccomments%2Cdynamic_posts%2Clikes%2Creactions%2Csharedposts%2Csponsor_tags%2Cto&page_size=100&access_token=EAACb9ZCv82ZBEBAM07v3j1SXfwsZBOshISatpy8vZCqPMsuiIpUmOE4RGtVRpZAZBxeQFR0JX9HxkCxragfZCcJ4b0YWmVqOkjkd3GCi6iWNa62oie92IJt9eCWALCR4vybHnl9EUK50W6850OgrdYZAxtaCebquZCL06uj7LIY3ZBtnACy20gFEWV1f3AfE6SGMoZD failed with status code 500 and error message Please reduce the amount of data you're asking for, then retry your request
When I have some time this week or the next I will remove the
comment
field from schema and rerun see if it works Will keep you posted
u
Thanks! Let me know if you need any further assistance
r
Thanks for the help Max, I'll update the connector schematic and listen right now. I'll be back soon with the answer.
airbyte rocket 1
failed... even changing the source schema and removing the comments as per max attached log
m
Hi @Rafael Paraíso Rossim, thanks for the heads-up I did not, have time to investigate this week possibly next one In any case, I shall you keep you posted here
r
Thank you for your help @Max Perdrigeat