Unanswered

Excel Run Script return error with no detail

(1) Share

Report

Posted on by testingMSK

I have a excel script work fine in browser Excel, basically just copy the existing sheet and create a new one and parse some value and save in the same row at different column. Like other previous topics, I have 502 BadGateway error however, with nothing telling me whats wrong

"body": {

"error": {

"code": 502,

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

"clientRequestId": "0a1ed183-a464-4b93-9255-faa9ae3159fa",

"message": "BadGateway",

"innerError": {

"message": "We were unable to run the script. Please try again.\r\nclientRequestId: 0a1ed183-a464-4b93-9255-faa9ae3159fa",

"logs": null

}

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (0)

cam_scott 8 on at

Like (0)

Report
Copy link

Link copied!

I'm having the same problem too, even when testing with a very simple office script in excel.

{
  "error": {
    "code": 502,
    "source": "australia-001.azure-apim.net",
    "clientRequestId": "557326b1-74d8-4932-927e-c2ea16fadf86",
    "message": "BadGateway",
    "innerError": {
      "message": "We were unable to run the script. Please try again.\r\nclientRequestId: 557326b1-74d8-4932-927e-c2ea16fadf86",
      "logs": null
    }
  }
}

Have you managed to find a solution to this?

Was this reply helpful? Yes No
testingMSK 8 on at

Like (1)

Report
Copy link

Link copied!

I cannot find the solution, I have contact Microsoft and have a meeting with them. They said they are looking into this matter but do not have any workaround at the moment

Was this reply helpful? Yes No
cam_scott 8 on at

Like (0)

Report
Copy link

Link copied!

That's frustrating, thank you for letting me know. Please let me know how it goes : )

Was this reply helpful? Yes No
Alex_MSFT Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hello, my name is Alex and I'm with the Office Scripts team at Microsoft.

Thank you for providing the requestID. I looked into our logs, and it looks like this issue should have been transient -- at the time of your request, we were not able to handle the request due to the volume we were receiving at that time. If you try again now, I expect it to work.

Was this reply helpful? Yes No
Alex_MSFT Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Are you still having this problem? Looking at our logs based on your requestID, it seems to me that this issue should have been transient, and should be resolved and working fine now. Please let me know if that isn't the case.

Was this reply helpful? Yes No
cam_scott 8 on at

Like (0)

Report
Copy link

Link copied!

Thank you Alex, I can confirm that it is working as expected now : )

Was this reply helpful? Yes No
testingMSK 8 on at

Like (0)

Report
Copy link

Link copied!

Hi Alex,
Thank for your reply, the simple script is working now, i will test with my intended script now, thanks again.

Was this reply helpful? Yes No