BadGateway 502 Excel connector failing after months of success

[Bill51106]

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!!!

[Yutao]

Hi @Bill51106 , sorry to hear you are running into this issue. It might be related to a regression that we are actively investigating on. The problem seems to have something to do with the workbook size.

I'll keep you posted for any progress. Thanks for your patience!

[Bill51106]

@Yutao Thank you very much. I appreciate your time.

[Yutao]

FYI, we have a local repro and the team is actively working on it as the highest priority to locate the root cause and look for a fix/mitigation. Thanks for your patience!

[Yutao]

@Bill51106 - just wanted to confirm if you happen to be using the range.copyFrom() API in your code. We are now suspecting that API could be the culprit based on our troubleshooting so far.

[Bill51106]

@Yutao that is the exact one.

[Yutao]

I see! While we're working on a fix to the range.copyFrom() API, do you think for now it's possible to work around it using things like range.getValues() then range.setValues() in your code?

[MarcellSzeles]

Hi @Yutao ,

We are seeing the very same issue happening with larger (300KB) workbook sizes with the use of 

(row 25 in question) table.getRange().getColumnCount();

{
  "error": {
    "code": 502,
    "source": "flow-apim-europe-002-northeurope-01.azure-apim.net",
    "clientRequestId": "3edec818-b200-4048-94a7-01c9c36ca781",
    "message": "BadGateway",
    "innerError": {
      "message": "We were unable to run the script. Please try again.\nOffice JS error: Line 25: {\"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\":\"Range\",\"method\":\"copyFrom\",\"line\":19}\r\nclientRequestId: 3edec818-b200-4048-94a7-01c9c36ca781",
      "logs": []
    }
  }
}

[MarcellSzeles]

Oh yeah, right before this we have a .copyFrom()

Any expected fix ETA?

Fyi we use this function to remove formulas from sheets. The function fails only on sheets where we have lots of formulas. Regular (even larger) sheets with values only are not failing.

[Yutao]

To clarify, based on our current investigation, at this moment Range.copyFrom() only has issues when copyType is ExcelScript.RangeCopyType.values. The temporary workaround is to use range.getValues() and range.setValues() plus some batching (e.g., 5,000 rows per batch, with console.log("...") after each batch to flush queued data operations, refer to this for more details and an example).

The other copyTypes (e.g., ExcelScript.RangeCopyType.all, ExcelScript.RangeCopyType.formats, ExcelScript.RangeCopyType.formulas, etc.) should still work as expected.

We have identified the root cause and are now working on a potential fix. Will keep you all posted. Thanks again for your patience.

[Bill51106]

@Yutao Thank you!

[Yutao]

UPDATE: We made a fix and it has been rolling out. ETA 2~3 days reaching all production environments if everything works smoothly. Thanks again for your patience!

[Bill51106]

@Yutao I appreciate you guys!

[Yutao]

UPDATE: While rolling out our initial fix, we identified a potential issue and had to back it out and made another fix. The second fix is rolling out now and ETA 2~3 days reaching all production environments. We sincerely apologize for the delay and appreciate your patience.

[Bill51106]

Anything new? Still failing over here, thank you.

[Yutao · Accepted solution]

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.

[Bill51106]

Resolved, thank you!

[Yutao]

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!

[AndyB1000]

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]

@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.