1852035 - Airflow tasks `bqetl_subplat.mozilla_vpn_derived__survey_*` failed for exec_date 2023-09-06

Status: RESOLVED FIXED

(Data Platform and Tools :: General, defect)

Description

[Frank Bertsch [:frank]]

One log: https://workflow.telemetry.mozilla.org/log?dag_id=bqetl_subplat&task_id=mozilla_vpn_derived__survey_cancellation_of_service__v1&execution_date=2023-09-06T01%3A45%3A00%2B00%3A00&map_index=-1

Error I see is:[2023-09-07, 02:46:43 UTC] {pod_manager.py:235} INFO - requests.exceptions.HTTPError: 401 Client Error: Unauthorized for url: https://restapi.surveygizmo.com/v5/survey/5111573/surveyresponse?api_token=***&api_token_secret=***&results_per_page=500&filter%5Bfield%5D%5B0%5D=date_submitted&filter%5Boperator%5D%5B0%5D=%3E=&filter%5Bvalue%5D%5B0%5D=2023-09-05+20:00:00&filter%5Bfield%5D%5B1%5D=date_submitted&filter%5Boperator%5D%5B1%5D=%3C&filter%5Bvalue%5D%5B1%5D=2023-09-06+20:00:00

Comment 1

[Sean Rose [:srose]]

The bqetl_subplat.mozilla_vpn_derived__survey_* tasks for 2023-09-07 ran successfully overnight, so I reran the tasks for 2023-09-06 and they completed successfully as well. It appears this was a temporary issue on Alchemer/SurveyGizmo's end.