Forum Discussion

cdj's avatar
cdj
Frequent Visitor
7 months ago

Fabric Pipeline Warehouse connection problem

In my data pipeline I have a look up activity that runs a stored procedure on my Warehouse. About once every 14 days i get this error:   ErrorCode=SqlFailedToConnect,'Type=Microsoft.DataTransfer.Co...
data engineering
data pipeline
v-saisrao-msft's avatar
v-saisrao-msft
Icon for Community Support rankCommunity Support
7 months ago

Hi cdj,

This issue occurs when Microsoft Fabric Warehouse is temporarily unavailable due to system updates or backend reconfiguration, rather than from permissions or connector settings. During these times, the SQL endpoint may briefly lose connectivity, leading to temporary errors like system update or shutdown in progress. Because Lookup activities do not retry automatically, enabling retry logic (3–5 retries with 2–5 minute intervals) can help the Warehouse recover on its own.

Warehouse Connectivity - Microsoft Fabric | Microsoft Learn

Troubleshoot the Warehouse - Microsoft Fabric | Microsoft Learn

 

Thank you.