Forum Discussion
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
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.
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.
Hi
I have now the same problem. Is there any solution?
