Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,986 questions
Generic Error in Synapse Studio Pipeline
Jaryd
177
Reputation points
Hello, I am just starting to use Synapse Studio. However, I have been using Azure Data Factory for a few months.
I have a pipeline that is just a single dataflow activity, copying data from our Azure SQL to Synapse SQL Pool. But I keep getting this error:
{
"errorCode": "125",
"message": "Internal Server Error:Failed to submit job on interactive cluster. Integration Runtime '', ActivityId: '3fb6e273-bd09-4c07-b09d-91329a7fc7ba'.",
"failureType": "SystemError",
"target": "toBillingSynapse",
"details": []
}
A normal copy activity does work, just not the data flow ones.
I cant find anything online to assist. One interesting thing I found was, I accidentally ran the pipeline while the the SQL Pool was pause and it still gave that same error.
Anyone have any troubleshooting ideas? Thanks!
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 9%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HarithaMaddi-MSFT 10,136 Reputation points2020-08-18T07:49:40.677+00:00 Hi @Jaryd ,
Welcome to Microsoft Q&A Platform.
Yes, I reproduced with pause state of SQL pool and I observed the same error. However, cannot observe it when SQL pool is online. Please suggest if below steps are taken while running the pipeline.
- Published all the recent changes
- SQL pool is online
- Data flow debug is ready before you triggered the pipeline
If issue persists, to investigate further, please suggest the region where SQL pool is created and the configuration of the pool.
-
HarithaMaddi-MSFT 10,136 Reputation points
2020-08-20T04:53:37.24+00:00 Hi @Jaryd ,
We have not heard back from you. Are you still facing the issue? If you found a solution, would you please share it here with the community? Please let us know if above steps helped, if not, request you to share more details as below and we will continue to engage with you on the issue.
Region of SQL pool:
Pipeline Run ID:
Workspace name: -
HarithaMaddi-MSFT 10,136 Reputation points
2020-08-21T15:33:04.217+00:00 Hi @Jaryd ,
Checking to see if you are still facing the issue. Please share more details as mentioned if the issue persists after suggestions and we will be glad to assist further.
Sign in to comment
Sign in to answer