Excel Run Script - 502 Bad Gateway

[MatthewLloyd]

Have a flow which sends an array of objects to be sorted by their date using an office script. Was working fine for months until two hours ago started recieving the below errors. We haven't any significant changes I'm aware of in the past two hours that may have caused this:

{

  "error": {

    "code": 502,

    "source": "australia-001.azure-apim.net",

    "clientRequestId": "xxxxxxx-xxxxxxx-xxxxxxx-xxxx-xxxxxxxxxxx",

    "message": "BadGateway",

    "innerError": {

      "message": "Failed to find certificate with subjects 'aadencrypt.officescripts.microsoftusercontent.com', 'aadencrypt.runtime.arbitraryrunner.com'\r\nclientRequestId: xxxxxxx-xxxxxxx-xxxxxxx-xxxx-xxxxxxxxxxx",

      "storageErrorCode": 0

    }

  }

}

[Yutao]

@AlCow - there had been an outage in the past few days but it should already be fixed now (Re: Execute Excel Script - Unauthorized - Page 2 - Power Platform Community (microsoft.com))

But if you are still seeing issues using the Run script action, can you provide your clientRequestId of the failed Run script action, as shown in the sample screenshot?

[dellonmoy]

@Yutao I think I'm experiencing an outage with the 'run script' action. Located in US. 

What steps do I need to follow to remedy this? TIA

[Yutao]

Hi @dellonmoy ,

Sorry to hear you were experiencing issues with the "Run script" action. There was indeed a glitch in our system, and it should be fixed now. Could you please give it a try again and see if your flow is working?

Thanks for your patience!

[dellonmoy]

Thank you for the timely response and action @Yutao. We're back up and running.

[RafaelRomeroRV]

Since yesterday I have the issue below trying run a script with Power Automate Online:

Não foi possível recuperar os valores. A solicitação de invocação dinâmica falhou com o erro: Unexpected error occurred when calling the ApiHubsRuntime API: 'Microsoft.Azure.ProcessSimple.Data.Entities.Exceptions.ProcessSimpleDataException: The ApiHubsRuntime API call failed with http status code 'BadGateway' and response content '{
"error": {
"code": 502,
"source": "brazil-001.azure-apim.net",
"clientRequestId": "afe36c3d-68cc-4e75-84a1-f3afede39e88",
"message": "BadGateway",
"innerError": {
"status": 502,
"message": "O servidor teve um problema e não pôde concluir a solicitação. Tente novamente em instantes.\r\nclientRequestId: afe36c3d-68cc-4e75-84a1-f3afede39e88",
"error": {
"message": "O servidor teve um problema e não pôde concluir a solicitação. Tente novamente em instantes."
},
"source": "excelonline-bse.azconn-bse.p.azurewebsites.net"
}
}
}'
at Microsoft.Azure.ProcessSimple.Data.DataProviders.HttpClientDataProvider.<>c__DisplayClass47_1`2.<<CallService>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.WindowsAzure.ResourceStack.Common.Algorithms.AsyncRetry.<Retry>d__3`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult()
at Microsoft.Azure.ProcessSimple.Data.DataProviders.HttpClientDataProvider.<CallService>d__47`2.MoveNext()'.

[toothmoves]

Hi,

I think there is a glitch again on "Run Script" with the unusual "Bad Gataway". Could you pleae fix this? Thank you

Location is EU.

[ntaf3llos]

Hi,

I have the same issue on "Run Script". Location EU.

[Yutao]

@RafaelRomeroRV , @toothmoves , @ntaf3llos -

Sorry to hear you were experiencing the issues with the Run script action. We were aware of an outage in one of the services we depend on, and a patch is being rolled out at the moment. Please give it a try and let me know if the issue persists. Thanks for your patience and support!

[toothmoves]

Everything’s working smoothly on my side now! Thank you for your prompt help 

[ntaf3llos]

The issue has been resolved for me. Thank you very much @Yutao, I appreciate your valuable assistance on this matter!

[Anonymous]

Hi, a similar error 502 threw out when trying to add a "Run script from SharePoint library (Preview)" action and save the flow, located in Singapore:

The dynamic operation request to API 'excelonlinebusiness' operation 'GetSingleScriptV2' failed with status code 'BadGateway'. Error response: { "error": { "code": 502, "source": "asia-001.azure-apim.net", "clientRequestId": "xxx", "message": "BadGateway", "innerError": { "status": 502, "message": "The server experienced an issue and couldn't complete the request. Please try again in a few moments. clientRequestId: xxx", "error": { "message": "The server experienced an issue and couldn't complete the request. Please try again in a few moments." }, "source": "excelonline-ea.azconn-ea-001.p.azurewebsites.net" } } }

Could you help with this as well? @Yutao 
Thanks!

[Anonymous]

I figured out the cause and solved the problem. Seems like originally I do not have the full access to the sharepoint site but only to a specific folder which stores the office script file. Now this feature does not support incomplete access to script file. When try to store the file under another sharepoint site of which I am the owner, this action works and no error prompt up.

[hammedabdul]

Having the same issue where. Please anyone got solution on this yet?

{

    "error":

    { "code": 502,

    "source": "flow-apim-europe-002-westeurope-01.azure-apim.net", "clientRequestId": "418daa10-596e-4aee-b113-eb92d971c3fd",

    "message": "BadGateway",

    "innerError": {

        "message": "The server experienced an issue and couldn't run the script. Please try again in a few moments.\r\nclientRequestId: 418daa10-596e-4aee-b113-eb92d971c3fd", "logs": null

    }

        }

    }

[jiwhite]

502 Bad Gateway errors are typically due to issues with the cloud service.  All you can do is report it and wait for them to fix it. I suggest creating a new thread so they see how many people are complaining about a particular region's servers now.

[Yutao]

@hammedabdul - looking at our logs for the client request ID you shared, I noticed some logs indicating that for some reason you might not have permission to access the script you are trying to run. Can you please double check if you can access that script? You can try running the same script against the same workbook from the Office Scripts code editor inside Excel for the web. You can also try directly accessing that script file on your OneDrive for Business (under "Documents/Office Scripts").

[hammedabdul]

@Yutao 

Yes i can access the script and  I am also using the same user account but got the same error. Ran the script from the Office Script code editor, it only pop up the fields no error. Please i need further help.

[toothmoves]

Hi, again the Bad Gateway issue here in Europe....My scripts aren't running

[toothmoves]

In particular, running a script with "Getrange" or Get worksheet gives an error, please reply asap since this is affecting our entire management ecosystem

[Yutao]

Hi @toothmoves , sorry to hear you are experiencing the issues. We are not aware of any service outages on our side at the moment. Can you share the clientRequestId from one of the Run script action failures?

[hammedabdul]

I was able to fix the issue. The issue occurs due to JSON not properly mapped in the Excel Run Script  in the flow. The Array was not in order as place in the Pearse JSON connector.