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.
5,378 questions
how we can fix Upstream service is unreachable error....
![](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(284.8, 91%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVD%3C/text%3E%3C/svg%3E)
Vaishali Dere
10
Reputation points
LivyHttpRequestFailure: Submission failed due to error content =[{"error":{"code":"BadGateway","message":"Upstream service is unreachable","innererror":{"errordetail":"System.Net.Http.HttpRequestException: Connection refused
Azure Synapse Analytics
{count} votes
-
PRADEEPCHEEKATLA 90,651 Reputation points Moderator2023-08-10T04:28:41.2233333+00:00 @Vaishali Dere - Thanks for the question and using MS Q&A platfrom.
Could you please share the below details to understand the ask?
Which Azure Service are you using?
What are you trying to do (kindly share the steps which you are trying)?
Share the screenshot of the error message which you are experiencing?Looking forward for your response.
-
Vaishali Dere 10 Reputation points
2023-08-10T13:52:48.7633333+00:00 HI Pradeep,
Thanks for reply ,
- We are using synapse service
- In synapse, we read file from blob storage and validate it then store into db.
- While validating the things one of the notebook get failed with attached error message
-
Vaishali Dere 10 Reputation points
2023-08-10T14:02:53.3+00:00 Hi @PRADEEPCHEEKATLA ,
Thanks for reply
we are using synapse service,to read files from bolb storage validate and process data and send it to cosmos and then sql.
below is screen shot for error
-
PRADEEPCHEEKATLA 90,651 Reputation points Moderator
2023-08-14T08:30:08.7566667+00:00 @Vaishali Dere - Could you please share the code snippet which you are trying to use?
-
![](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(80, 94%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Dev, Surya 25 Reputation points2023-08-14T18:26:05.6133333+00:00 Hi,
hope you are doing well !!
I am also getting this error.
We are trying to load data from 400 files (total size 500GB) to a delta table using synapse spark notebook. On that time, I am getting this error.
My spark size is Large (16 vCores / 128 GB) - 3 to 20 nodes, allocated vCores - 48 and allocated Memory - 384GB.
-
PRADEEPCHEEKATLA 90,651 Reputation points Moderator
2023-08-16T08:50:51.3+00:00 @Dev, Surya - Could you please share the code snippet which you are trying to use?
-
Vaishali Dere 10 Reputation points
2023-08-16T14:26:22.2433333+00:00 this is code where we get error
-
PRADEEPCHEEKATLA 90,651 Reputation points Moderator
2023-08-18T05:06:35.6133333+00:00 @Vaishali Dere - Please do share the compelete code which you are trying? You can copy the code snippet and paste here to try from our end.
-
PRADEEPCHEEKATLA 90,651 Reputation points Moderator
2023-08-22T08:30:35.13+00:00 @Vaishali Dere - We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sign in to comment
Sign in to answer