Hello everyone, I am using a facebook tap with a ...
# troubleshooting
e
Hello everyone, I am using a facebook tap with a postgreSQL destination. I have encountered multiple issues with the facebook tap of which I have created issues. • https://github.com/MeltanoLabs/tap-facebook/issues/416 • https://github.com/MeltanoLabs/tap-facebook/issues/417 But I have one extra issue that I simply cannot reason about and not sure if it's cause by the facebook tap. Here is the error log:
Copy code
2025-10-19T13:22:25.919449Z [info     ] An unhandled error occurred while syncing 'adsinsights_default' cmd_type=elb consumer=False job_name=prod:rosabella_extractor-to-rosabella_loader name=rosabella_extractor producer=True run_id=0199fba6-48d0-7dbb-bc80-981aa317c294 stdio=stderr string_id=rosabella_extractor
2025-10-19T13:22:25.919884Z [info     ] Traceback (most recent call last): cmd_type=elb consumer=False job_name=prod:rosabella_extractor-to-rosabella_loader name=rosabella_extractor producer=True run_id=0199fba6-48d0-7dbb-bc80-981aa317c294 stdio=stderr string_id=rosabella_extractor
2025-10-19T13:22:25.920546Z [info     ]   File "/home/ubuntu/meltano/.meltano/extractors/tap-facebook/venv/lib/python3.12/site-packages/singer_sdk/streams/core.py", line 1329, in sync cmd_type=elb consumer=False job_name=prod:rosabella_extractor-to-rosabella_loader name=rosabella_extractor producer=True run_id=0199fba6-48d0-7dbb-bc80-981aa317c294 stdio=stderr string_id=rosabella_extractor
2025-10-19T13:22:25.925929Z [info     ]     for _ in self._sync_records(context=context): cmd_type=elb consumer=False job_name=prod:rosabella_extractor-to-rosabella_loader name=rosabella_extractor producer=True run_id=0199fba6-48d0-7dbb-bc80-981aa317c294 stdio=stderr string_id=rosabella_extractor
2025-10-19T13:22:25.926566Z [info     ]   File "/home/ubuntu/meltano/.meltano/extractors/tap-facebook/venv/lib/python3.12/site-packages/singer_sdk/streams/core.py", line 1204, in _sync_records cmd_type=elb consumer=False job_name=prod:rosabella_extractor-to-rosabella_loader name=rosabella_extractor producer=True run_id=0199fba6-48d0-7dbb-bc80-981aa317c294 stdio=stderr string_id=rosabella_extractor
2025-10-19T13:22:25.928468Z [info     ]     for idx, record_result in enumerate(self.get_records(current_context)): cmd_type=elb consumer=False job_name=prod:rosabella_extractor-to-rosabella_loader name=rosabella_extractor producer=True run_id=0199fba6-48d0-7dbb-bc80-981aa317c294 stdio=stderr string_id=rosabella_extractor
2025-10-19T13:22:25.929116Z [info     ]   File "/home/ubuntu/meltano/.meltano/extractors/tap-facebook/venv/lib/python3.12/site-packages/tap_facebook/streams/ad_insights.py", line 304, in get_records cmd_type=elb consumer=False job_name=prod:rosabella_extractor-to-rosabella_loader name=rosabella_extractor producer=True run_id=0199fba6-48d0-7dbb-bc80-981aa317c294 stdio=stderr string_id=rosabella_extractor
2025-10-19T13:22:25.929555Z [info     ]     job = self._run_job_to_completion(params)  # type: ignore[func-returns-value] cmd_type=elb consumer=False job_name=prod:rosabella_extractor-to-rosabella_loader name=rosabella_extractor producer=True run_id=0199fba6-48d0-7dbb-bc80-981aa317c294 stdio=stderr string_id=rosabella_extractor
2025-10-19T13:22:25.931300Z [info     ]           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ cmd_type=elb consumer=False job_name=prod:rosabella_extractor-to-rosabella_loader name=rosabella_extractor producer=True run_id=0199fba6-48d0-7dbb-bc80-981aa317c294 stdio=stderr string_id=rosabella_extractor
2025-10-19T13:22:25.931719Z [info     ]   File "/home/ubuntu/meltano/.meltano/extractors/tap-facebook/venv/lib/python3.12/site-packages/tap_facebook/streams/ad_insights.py", line 188, in _run_job_to_completion cmd_type=elb consumer=False job_name=prod:rosabella_extractor-to-rosabella_loader name=rosabella_extractor producer=True run_id=0199fba6-48d0-7dbb-bc80-981aa317c294 stdio=stderr string_id=rosabella_extractor
2025-10-19T13:22:25.932314Z [info     ]     raise RuntimeError(dict(job)) cmd_type=elb consumer=False job_name=prod:rosabella_extractor-to-rosabella_loader name=rosabella_extractor producer=True run_id=0199fba6-48d0-7dbb-bc80-981aa317c294 stdio=stderr string_id=rosabella_extractor
2025-10-19T13:22:25.933301Z [info     ] RuntimeError: {'id': '1525505068583482', 'report_run_id': '1525505068583482', 'account_id': '376900375258324', 'time_ref': 1760880108, 'async_status': 'Job Failed', 'async_percent_completion': 72, 'date_start': '2025-04-27', 'date_stop': '2025-04-28', 'is_running': True} cmd_type=elb consumer=False job_name=prod:rosabella_extractor-to-rosabella_loader name=rosabella_extractor producer=True run_id=0199fba6-48d0-7dbb-bc80-981aa317c294 stdio=stderr string_id=rosabella_extractor
As you can see there is no error from the Facebook API. The only error is:
Copy code
RuntimeError: {'id': '1525505068583482', 'report_run_id': '1525505068583482', 'account_id': '376900375258324', 'time_ref': 1760880108, 'async_status': 'Job Failed', 'async_percent_completion': 72, 'date_start': '2025-04-27', 'date_stop': '2025-04-28', 'is_running': True}
This only happens on small AWS EC2 instance. Is it possible for this issue to be caused by insufficient hardware? Thanks!
āœ… 1
After doing a bit more research I see that it indeed is a Facebook API error from the async insights job from Meta.
šŸ‘ 1