Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now

Reply
Anonymous
Not applicable

Error running Pipeline from trigger: SQL Data Warehouse cannot connect

I am getting this error more often than not, it seems to be isolated to when run from a Pipeline Schedule. Rerunning the Pipelie manually completes successfully


ErrorCode=SqlFailedToConnect,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Cannot connect to SQL Database. Please contact SQL server team for further support. Server: '4pahqt2q2lpu3oy4cxjrivuxzq-wc37jgnjowhubnlb7xgbfhfxqy.datawarehouse.pbidedicated.windows.net', Database: 'c7e2cf0c-5616-48d7-8af2-fe5dcdc059dd', User: ''. Check the connection configuration is correct, and make sure the SQL Database firewall allows the Data Factory runtime to access.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Data.SqlClient.SqlException,Message=Warning: Fatal error 615 occurred at Nov 22 2023 6:06AM. Note the error and time, and contact your system administrator.,Source=.Net SqlClient Data Provider,SqlErrorNumber=21,Class=21,ErrorCode=-2146232060,State=1,Errors=[{Class=21,Number=21,State=1,Message=Warning: Fatal error 615 occurred at Nov 22 2023 6:06AM. Note the error and time, and contact your system administrator.,},],'

4 REPLIES 4
HarderT
Helper II
Helper II

Hi 

I have now the same problem. Is there any solution?

Anonymous
Not applicable

Hi @SteveDevine ,

Apologies for the issue you have been facing. 

This might require a deeper investigation from our engineering team about your workspace, the Pipeline details and the logic behind it to properly understand what might be happening. 

Please go ahead and raise a support ticket to reach our support team:

https://support.fabric.microsoft.com/support
Please provide the ticket number here as we can keep an eye on it.

Thank you.

Anonymous
Not applicable

Hi @Anonymous ,

We haven’t heard from you on the last response and was just checking back to see if you got a chance to create a support ticket? If yes, please provide the ticket number here as we can keep an eye on it.

Anonymous
Not applicable

Hi @SteveDevine ,

We haven’t heard from you on the last response and was just checking back to see if you got a chance to create a support ticket? If yes, please provide the ticket number here as we can keep an eye on it.

Helpful resources

Announcements
FabCon and SQLCon Highlights Carousel

FabCon & SQLCon Highlights

Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.