topic Re: Error running Pipeline from trigger: SQL Data Warehouse cannot connect in Pipelines

Error running Pipeline from trigger: SQL Data Warehouse cannot connect

Anonymous — Wed, 22 Nov 2023 08:51:50 GMT

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.,},],'

Re: Error running Pipeline from trigger: SQL Data Warehouse cannot connect

Anonymous — Thu, 23 Nov 2023 11:08:50 GMT

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.

Re: Error running Pipeline from trigger: SQL Data Warehouse cannot connect

Anonymous — Mon, 27 Nov 2023 06:29:55 GMT

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.

Re: Error running Pipeline from trigger: SQL Data Warehouse cannot connect

Anonymous — Wed, 29 Nov 2023 06:27:09 GMT

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.

Re: Error running Pipeline from trigger: SQL Data Warehouse cannot connect

HarderT — Thu, 22 May 2025 06:55:58 GMT

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