Unanswered

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

Categories:

Using flows

I have the same question (0)

All responses (24)

Answers (1)

Yutao Huang Microsoft Employee on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Bill51106 152 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Yutao Huang Microsoft Employee on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Yutao Huang Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Bill51106 152 on at

Like (0)

Report

@Yutao that is the exact one.

Was this reply helpful? Yes No
Yutao Huang Microsoft Employee on at

Like (0)

Report

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?

Was this reply helpful? Yes No
MarcellSzeles 10 on at

Like (0)

Report
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": [] } } }

Was this reply helpful? Yes No
MarcellSzeles 10 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Yutao Huang Microsoft Employee on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Bill51106 152 on at

Like (0)

Report

@Yutao Thank you!

Was this reply helpful? Yes No