Answered

BadGateway 502 Excel connector failing after months of success

(0) Share

Report

Posted on by Bill51106

152

I have a lot of production Flows that have been running for over a year successfully. They utilize a few scripts between them. Starting on 9/28 they started failing when running the Excel connector. The files themselves range between 500K and 2.5MB. On a single small account, I have one Flow that who's file is 250K and it works perfectly through PA still. Also running the scripts outside power automate but in the cloud Excel version now fails. Opening the file locally in Excel and running the scripts works great.

We were unable to run the script. Please try again.\nOffice JS error: Line 158: {\"message\":\"The request failed with status code of 400, error code invalidSessionReCreatable and the following error message: The session specified in the request does not exist or is invalid due to a transient error.\",\"code\":\"invalidSessionReCreatable\",\"type\":\"Table\",\"method\":\"addColumn\",\"line\":79}\r\nclientRequestId: 69a96fa2-9c45-4706-aa3f-c98ca36bafdb",

We were unable to run the script. Please try again.\nOffice JS error: Line 76: Table addColumn: The request failed with status code of 400, error code invalidSessionReCreatable and the following error message: The session specified in the request does not exist or is invalid due to a transient error.\r\nclientRequestId: 203b33db-add1-4989-9137-f5bfb0586b02",

Any help would be appreciated!!!

All responses (24)

Answers (1)

Yutao Huang Microsoft Employee on at

Like (0)

Report

Re: BadGateway 502 Excel connector failing after months of success

Unfortunately, we ran into some temporary capacity issues earlier, but it should be addressed now. Please give it a try again and see if you are still experiencing the same issue. Thanks!
AndyB1000 14 on at

Like (0)

Report

Re: BadGateway 502 Excel connector failing after months of success

Hi @syahmisamsudin - I've raised a ticket with MS on this, currently awaiting a response, if a resolution is found I'll post the results here too, thanks, Andy
syahmisamsudin 3 on at

Like (0)

Report

Re: BadGateway 502 Excel connector failing after months of success

I have exactly the same issue. Can someone help with this issue? Thanks.
Jake112314 2 on at

Like (0)

Report

Re: BadGateway 502 Excel connector failing after months of success

Hi @Yuto
Could you help me take a look on my issues? Thanks
{
  "error": {
    "code": 502,
    "source": "asia-001.azure-apim.net",
    "clientRequestId": "54ad2456-b37d-49fb-a13c-e13785f752b4",
    "message": "BadGateway",
    "innerError": {
      "message": "We were unable to run the script. Please try again.\r\nclientRequestId: 54ad2456-b37d-49fb-a13c-e13785f752b4",
      "logs": null
    }
  }
}
Satya2804 2 on at

Like (0)

Report

Re: BadGateway 502 Excel connector failing after months of success

HI @Yutao .. am receiving a similar error the clientrequestid is fe49b10d-67dd-42c3-ab51-ca1988144f4e. Can you help?
Yutao Huang Microsoft Employee on at

Like (0)

Report

Re: BadGateway 502 Excel connector failing after months of success

@AndyB1000 if you can share the client request id of a failed Run script action, I can try taking a quick look at the logs and see what the problem could be.
AndyB1000 14 on at

Like (0)

Report

Re: BadGateway 502 Excel connector failing after months of success

Hi @Yutao, I've been seeing the same issue using the range.setValues() function - I actually think it's more to do with whether you are using dynamic values in the update. Where fixed values are specified in the function it runs fine, where I'm determining field values using variable in my logic app.
Yutao Huang Microsoft Employee on at

Like (0)

Report

Re: BadGateway 502 Excel connector failing after months of success

Yes, the fix is now 100% in production. Please help to validate your code that has the range.copyFrom() API with ExcelScript.RangeCopyType.values as copyType. Thanks again for your patience!
Bill51106 152 on at

Like (1)

Report

Re: BadGateway 502 Excel connector failing after months of success

Resolved, thank you!
Verified answer

Yutao Huang Microsoft Employee on at

Like (1)

Report

Re: BadGateway 502 Excel connector failing after months of success

UPDATE: Unfortunately, there have been several unforeseen issues that have slowed down the rollout process. We may still need another 2~3 days on the safe side. We want to assure you that we are doing everything in our power to resolve the issue and push the fix as soon as possible. We apologize for the delay and thank you for your patience and understanding.

Community site session details

BadGateway 502 Excel connector failing after months of success

Helpful resources

News and Announcements

Quick Links

Understanding Microsoft Agents - Introductory Session

Markus Franz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

BadGateway 502 Excel connector failing after months of success

Helpful resources

News and Announcements

Quick Links

Understanding Microsoft Agents - Introductory Session

Markus Franz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates