<@U06CE9BN604> This is the broken pipe error that ...
# announcements
c
@douwe_maan This is the broken pipe error that I got: Running extract & load... No state was found, complete import. INFO Syncing Accounts INFO Initializing CustomerManagementService client - Loading WSDL INFO Creating SOAP client with OAuth refresh credentials for service: CustomerManagementService, account_id 1261936 INFO Calling: GetAccount(AccountId=1261936) for account: 1261936 INFO METRIC: {"type": "timer", "metric": "http_request_duration", "value": 0.2996499538421631, "tags": {"endpoint": "GetAccount", "status": "succeeded"}} INFO METRIC: {"type": "counter", "metric": "record_count", "value": 1, "tags": {"endpoint": "accounts"}} INFO Syncing core objects INFO Creating SOAP client with OAuth refresh credentials for service: CampaignManagementService, account_id 1261936 Traceback (most recent call last): File "/Users/cmarchetti/Documents/Datateer/VividFront/base-meltano/.meltano/loaders/target-jsonl/venv/bin/target-jsonl", line 10, in <module> sys.exit(main()) File "/Users/cmarchetti/Documents/Datateer/VividFront/base-meltano/.meltano/loaders/target-jsonl/venv/lib/python3.7/site-packages/target_jsonl.py", line 94, in main state = persist_messages(input_messages, config.get('destination_path', ''), config.get('do_timestamp_file', True)) File "/Users/cmarchetti/Documents/Datateer/VividFront/base-meltano/.meltano/loaders/target-jsonl/venv/lib/python3.7/site-packages/target_jsonl.py", line 64, in persist_messages with open(filename, 'a', encoding='utf-8') as json_file: FileNotFoundError: [Errno 2] No such file or directory: 'output/accounts.jsonl' INFO Syncing Campaigns for Account: 1261936 INFO Calling: GetCampaignsByAccountId(AccountId=1261936,CampaignType=Search Shopping DynamicSearchAds) for account: 1261936 INFO METRIC: {"type": "timer", "metric": "http_request_duration", "value": 0.6882591247558594, "tags": {"endpoint": "GetCampaignsByAccountId", "status": "succeeded"}} CRITICAL [Errno 32] Broken pipe Traceback (most recent call last): File "/Users/cmarchetti/Documents/Datateer/VividFront/base-meltano/.meltano/extractors/tap-bing-ads/venv/bin/tap-bing-ads", line 11, in <module> load_entry_point('tap-bing-ads==2.0.13', 'console_scripts', 'tap-bing-ads')() File "/Users/cmarchetti/Documents/Datateer/VividFront/base-meltano/.meltano/extractors/tap-bing-ads/venv/lib/python3.7/site-packages/tap_bing_ads/__init__.py", line 949, in main raise exc File "/Users/cmarchetti/Documents/Datateer/VividFront/base-meltano/.meltano/extractors/tap-bing-ads/venv/lib/python3.7/site-packages/tap_bing_ads/__init__.py", line 946, in main loop.run_until_complete(main_impl()) File "/Library/Developer/CommandLineTools/Library/Frameworks/Python3.framework/Versions/3.7/lib/python3.7/asyncio/base_events.py", line 584, in run_until_complete return future.result() File "/Users/cmarchetti/Documents/Datateer/VividFront/base-meltano/.meltano/extractors/tap-bing-ads/venv/lib/python3.7/site-packages/tap_bing_ads/__init__.py", line 938, in main_impl await do_sync_all_accounts(account_ids, args.catalog) File "/Users/cmarchetti/Documents/Datateer/VividFront/base-meltano/.meltano/extractors/tap-bing-ads/venv/lib/python3.7/site-packages/tap_bing_ads/__init__.py", line 925, in do_sync_all_accounts await asyncio.gather(*sync_account_data_tasks) File "/Users/cmarchetti/Documents/Datateer/VividFront/base-meltano/.meltano/extractors/tap-bing-ads/venv/lib/python3.7/site-packages/tap_bing_ads/__init__.py", line 906, in sync_account_data sync_core_objects(account_id, selected_streams) File "/Users/cmarchetti/Documents/Datateer/VividFront/base-meltano/.meltano/extractors/tap-bing-ads/venv/lib/python3.7/site-packages/tap_bing_ads/__init__.py", line 603, in sync_core_objects campaign_ids = sync_campaigns(client, account_id, selected_streams) File "/Users/cmarchetti/Documents/Datateer/VividFront/base-meltano/.meltano/extractors/tap-bing-ads/venv/lib/python3.7/site-packages/tap_bing_ads/_…
d
This looks like the target error that did it:
Copy code
FileNotFoundError: [Errno 2] No such file or directory: 'output/accounts.jsonl'
Did you create an
output
directory ahead of time?
(There's an issue to create it automatically, but it hasn't been prioritized yet: https://gitlab.com/meltano/meltano/-/issues/2185)
c
I will make the output directory and try it again.
That worked! Thanks again.
d
@chris_marchetti Awesome!