cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Akshay14
Helper I
Helper I

SQL Insert row bad gateway and 4 retries occurred.

Akshay14_0-1615354811023.png

 

Hi Folks,

 

Can anyone tell me as i am new to work on SQL connector, why i am getting this error ?

Since yesterday i am trying to solve it, its been major error and blocker please do help me.

 

Akshay14_1-1615354867463.png

 

2 REPLIES 2
Akshay14
Helper I
Helper I

 

Akshay14_1-1615355606572.png

{
  "error": {
    "code"502,
    "source""europe-002.azure-apim.net",
    "clientRequestId""xxxxx",
    "message""BadGateway",
    "innerError": {
      "status"502,
      "message""Parse error at line: 1, column: 393: Incorrect syntax near 'OUTPUT'.\r\nclientRequestId: xxx",
      "error": {
        "message""Parse error at line: 1, column: 393: Incorrect syntax near 'OUTPUT'."
      },
      "source""sql-ne.azconn-ne.p.azurewebsites.net"
    }
  }
}

 

 

ajdhingr
Microsoft
Microsoft

@Akshay14  Where is SQL instance ? Is it on Azure ? Are you connection to SQL via Flow first time ? The error indicates you are unable to reach to SQL DB or table .

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (2,664)