Closed Bug 1904835 Opened 8 months ago Closed 8 months ago

Airflow task microsoft_store.microsoft_derived__app_conversions__v1 failed for exec_date 2024-06-26

Categories

(Data Platform and Tools :: General, defect)

defect

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: mwilliams, Unassigned)

Details

(Whiteboard: [airflow-triage])

Airflow task microsoft_store.microsoft_derived__app_conversions__v1 failed for exec_date 2024-06-26

Task link:
https://workflow.telemetry.mozilla.org/dags/microsoft_store/grid?dag_run_id=scheduled__2024-06-25T04%3A00%3A00%2B00%3A00&task_id=microsoft_derived__app_conversions__v1&tab=logs

Log extract:

[2024-06-26, 05:02:17 UTC] {pod_manager.py:373} WARNING - Pod not yet started: microsoft-derived-app-conversions-v1-mftsvgpp
[2024-06-26, 05:02:25 UTC] {pod_manager.py:466} INFO - [base] Traceback (most recent call last):
[2024-06-26, 05:02:25 UTC] {pod_manager.py:466} INFO - [base]   File "/app/sql/moz-fx-data-shared-prod/microsoft_derived/app_conversions_v1/query.py", line 228, in <module>
[2024-06-26, 05:02:25 UTC] {pod_manager.py:466} INFO - [base] This is data for Firefox - 9NZVDKPMR9RD
[2024-06-26, 05:02:25 UTC] {pod_manager.py:466} INFO - [base] https://manage.devcenter.microsoft.com/v1.0/my/analytics/appchannelconversions?applicationId=9NZVDKPMR9RD
[2024-06-26, 05:02:25 UTC] {pod_manager.py:466} INFO - [base] no data for today
[2024-06-26, 05:02:25 UTC] {pod_manager.py:466} INFO - [base] This is data for Firefox Beta - 9NZW26FRNDLN
[2024-06-26, 05:02:25 UTC] {pod_manager.py:466} INFO - [base] https://manage.devcenter.microsoft.com/v1.0/my/analytics/appchannelconversions?applicationId=9NZW26FRNDLN
[2024-06-26, 05:02:25 UTC] {pod_manager.py:466} INFO - [base]     main()
[2024-06-26, 05:02:25 UTC] {pod_manager.py:466} INFO - [base]   File "/app/sql/moz-fx-data-shared-prod/microsoft_derived/app_conversions_v1/query.py", line 217, in main
[2024-06-26, 05:02:25 UTC] {pod_manager.py:466} INFO - [base]     if query_export["Value"]:
[2024-06-26, 05:02:25 UTC] {pod_manager.py:466} INFO - [base]        ~~~~~~~~~~~~^^^^^^^^^
[2024-06-26, 05:02:26 UTC] {pod_manager.py:483} INFO - [base] KeyError: 'Value'

DAG succeeded on re-run. However, the job has been failing at this point consistently and then succeeding after a manual trigger.

Status: NEW → RESOLVED
Closed: 8 months ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.