Closed Bug 1941517 Opened 1 month ago Closed 1 month ago

Airflow task private_bqetl_revenue.fivetran_microsoft_pubcenter_ptag_report_task failed for exec_date 2025-01-13

Categories

(Data Platform and Tools :: General, defect)

defect

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: kik, Assigned: Alekhya)

Details

(Whiteboard: [airflow-triage])

Airflow task private_bqetl_revenue.fivetran_microsoft_pubcenter_ptag_report_task failed for exec_date 2025-01-13

Task link:
https://workflow.telemetry.mozilla.org/dags/private_bqetl_revenue/grid?task_id=fivetran_microsoft_pubcenter_ptag_report_task&tab=details&dag_run_id=scheduled__2025-01-13T04%3A30%3A00%2B00%3A00

It appears the Fivetran connector is broken:
https://fivetran.com/dashboard/connectors/evacuation_stooping/status?groupId=loading_reputation&service=google_cloud_function&syncChartPeriod=1+Day

Log extract:

HTTP 500 Internal Server Error: 500 Internal Server Error: The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application. 

Attempting to test the connection also appears to fail, we're stuck waiting for the Accessing cloud function step to complete.

Looking at the cloud function it appears there is a SSL certificate problem:

requests.exceptions.SSLError: HTTPSConnectionPool(host='searchapi.pubcenter.microsoft.com', port=443): Max retries exceeded with url: /api/v2/report (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1149)'))) 

https://console.cloud.google.com/functions/details/us-central1/microsoft_pubcenter_api?env=gen1&inv=1&invt=Abm0CA&project=dev-fivetran&tab=logs

The job ran successfully after a re-run - seems like a server-side hiccup

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