question

GarethTerblanche-9138 avatar image
0 Votes"
GarethTerblanche-9138 asked SitaEnrico-8054 commented

Random script failures: Workbook getWorksheet: The request failed with status code of 503, error code UnknownError and the following error message

Are there any know issues with running script in a logic app?
Over the last 3 or 4 days I have had multiple seemingly random failures with this message:

We were unable to run the script. Please try again.\nOffice JS error: Line 2: Workbook getWorksheet: The request failed with status code of 503, error code UnknownError and the following error message: \r\nclientRequestId: d820ca3a-6d4d-4e89-ac4f-06d99a2eed53"

I have tested the files and when I run the script on the file manually there are no issues. in addition to this when there is a failure the file is processed a few hours later with no issue.

azure-logic-apps
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MayankBargali-MSFT avatar image
0 Votes"
MayankBargali-MSFT answered SitaEnrico-8054 commented

@GarethTerblanche-9138 Apology for the delay and inconvenience due to this issue. It looks like the intermittent issue where there might be issue with the logic app or the connector call itself. If someone is still observing the issue feel free to tag me with the latest clientRequestId along with the region where your logic app is deployed and the timeframe in UTC so I can check the backend logs and assist you further.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@MayankBargali-MSFT I am not sure if this issue is still being tracked for support, but I have a recent example for which I could also use assistance:
clientRequestId: 346d8f98-82ff-4cb0-854f-dfae47c80d27 / Western Europe / Wed, 18 May 2022 10:13:14 UTC

Thanks,
Enrico

0 Votes 0 ·
GarethTerblanche-9138 avatar image
0 Votes"
GarethTerblanche-9138 answered

@MayankBargali-MSFT Hi I have three recent examples for you:
1. clientRequestId: 00db1d1e-2be0-4606-bb20-e522b9671ede / Western Europe / Sat, 20 Nov 2021 20:15:24 GMT
2. clientRequestId: 29602e7c-93eb-4a4f-88cc-3c989abede30 / Western Europe / Sat, 20 Nov 2021 20:18:48 GMT
3. clientRequestId: dea0f739-4c83-464c-8d99-60852aa938ab / Western Europe / Sat, 20 Nov 2021 22:09:07 GMT

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.