Every app is getting Server Errors! Please advise.

[martinav]

I am getting server errors on every app.  This started on or around Monday 1/21/2019.  

Conditions:

- Appears to be happening with On-Prem gateway calls with SQL connectors

- Ocurr at Run-time.

- Some statements that make calls to the SQL connectors show red "X" with "Server Error" message.

- Despite the errors, it appears that data is being retrieved, and is accurate.

- If an MS Flow .run command contains a call via an SQL connector, and that statement fails, the .run fails.

Mitigations:

- Evaluated my license scheme.  Upgraded all users to PA Plan1 (I had Plan 1 already)

- Posted another thread with session IDs, and that has not been updated by microsoft support for two days.

I NEED HELP!!  Yes, that is me pleading.  This is a production application set that is affecting our business!

Session IDs:

Session ID: a8550553-4056-4516-92da-491b9989d388
PowerApps 3.18124.22

Session ID: fcf96ba0-7603-49e9-ba8d-3ab619c1f73c
PowerApps 3.18124.22

Session ID: bdb1b912-5313-404a-b466-26c43f06e048

PowerApps 3.18124.22

Session ID: 9027e094-c15f-404b-b9e2-3de43c8acb4c

PowerApps 3.18124.22

This one had another error that gives some additional clues:

ECNReleasing22_KDC.Run failed: { "error": { "code": 503, "source": "msmanaged-na.azure-apim.net", "clientRequestId": "cc3868c5-d25d-49f3-b62c-91c1c6c1569c", "message": "BadGateway", "innerError": { "error": { "code": "ServiceTemporarilyUnavailable", "message": "The service is temporarily unable to service your request. The tracking Id is 'dcbcdc8f-b54e-4941-a083-3f7975846c93'." } } } }

Session ID: 7b7d122d-0f92-413a-9668-69821b1890b5
PowerApps 3.18124.22

[v-xida-msft]

Hi @martinav,

Which PowerApps license do your end users own?

Currently, there are some updates on Office licenses which include PowerApps feature. The Custom Connector and On-Premises data gateway would not be supported within Office 365 Business, Office 365 Enterprise E1, Office 365 Enterprise E2 or Office 365 F1 licenses.

Please check the follownig article for more details:

https://powerapps.microsoft.com/en-us/support/

So if your end users have Office 365 Business, Office 365 Enterprise E1, Office 365 Enterprise E2 or Office 365 F1 licenses, they could not use On-premises gateway and custom connector functionality now.

In addition, you could also consider go to PowerApps Pricing page to check these limits:

https://powerapps.microsoft.com/en-us/pricing/

Best regards,

[martinav]

@v-xida-msft,

Per the mitigations in my post, I have had plan 1 for many months.  My users were updated to plan 1 on Tuesday.  Regardless, I get the errors just like everyone else.  

[NigelP]

Hi

I am suddenly getting server errors too.

THis has only started since 3.19012.9 was released in Europe. (24/01/2019)

It looks as if the dreaded ETAG error has made an unwelcome return.

Can someone from Microsoft have a look at this please ?

Thanks

Nigel

[martinav]

@NigelP,

Is the app running properly regardless?  With mine, it seems the data is all good.  It is also mostly (if not all) related to calls through the On-Premesis gateway to my SQL server.

[maverick17]

Looks like ETAG is back.... I have reports from users this morning:

https://powerusers.microsoft.com/t5/General-Discussion/ETAG-Mismatch-App-WAS-working-for-months/m-p/...

[NigelP]

Hi @martinav

I am using SharePoint Online.

I am not seeing any stored items in the list.

Regards

Nigel

[martinav]

@NigelP

Looks like a different set of conditions than from my post.  I have had no issues with sharepoint calls.  I believe its only calls through my On-Prem gateway using SQL connectors.