Error in Data Flows Data Fcatory while connecting to Azure SQL database?

Question

I am encountering an error when trying to debug a data flow in Azure Data Factory that connects to an Azure SQL Database. My linked service and dataset connections to the Azure SQL Database are working fine, and I can preview data without any issues. However, the problem arises specifically when I run the data flows. Could you help me understand why this is happening and how to resolve it?

Error Message :

Spark job failed: { "text/plain": "{"runId":"5a0e91a1-6c60-4b85-af5c-98958cb57b8b","sessionId":"d635311e-484d-4665-a36c-f95715c44a0f","status":"Failed","payload":{"statusCode":400,"shortMessage":"com.microsoft.dataflow.broker.MissingRequiredPropertyException: server is a required property for AzureSqlDatabase2.\ncom.microsoft.dataflow.broker.PropertyNotFoundException: Could not extract value from AzureSqlDatabase2","detailedMessage":"Failure 2024-05-21 02:12:38.407 failed DebugManager.processJob, run=5a0e91a1-6c60-4b85-af5c-98958cb57b8b, errorMessage=com.microsoft.dataflow.broker.MissingRequiredPropertyException: server is a required property for AzureSqlDatabase2.\ncom.microsoft.dataflow.broker.PropertyNotFoundException: Could not extract value from AzureSqlDatabase2"}}\n" } - RunId: 5a0e91a1-6c60-4b85-af5c-98958cb57b8b

Answer 1

Hello Anubha,

Thank you for posting in Microsoft Community forum.  

From the description above, I understand your question is related to SQL Server.   

Since there are no engineers dedicated to SQL Server in this forum. To be able to get a quick and effective handling of your issue, I recommend that you repost your question in the Q&A forum, where there will be a dedicated engineer to give you a professional and effective reply.  

Here is the link for Q&A forum:

Questions - Microsoft Q&A

Click the "Ask a Question" button in the upper right corner to post your question and select "SQL Server" tag and any other tags related to your products.  

Best regards

Rosy