cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BrendonBrooksP1
Post Patron
Post Patron

An Error Occured on the Server

Good morning. I woke up to a few emails from users telling me that there's a random error. 

 

When I log into any of my 5 apps, I get an error that states " An error occured on the server".  error.PNG

 

Everything appears to be functioning, however, when I'm in the studio and try to do a data refresh on my Azure SQL Db, the PA Editor gives me the error "Try Again.    Please see attached photo. 

 

I've checked the username and password and I am able to connect to the SQL db in both Excel and Visual Studio.  All other connections (SharePoint, Office 365, OneDrive) are not affected.  What would cause this?

 

Brendon

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

@v-micsh-msft

 

For me, the issue has been resolved. Thanks.

 

Brendon

View solution in original post

29 REPLIES 29
tomcat318
Helper I
Helper I

I seem to be having the same issue connecting to a PAAS DB. SSMS can open with no issues with the same userID.

 

BrendonBrooksP1
Post Patron
Post Patron

Update: Seems to be occuring in Google Chrome, and not in the Power Apps Editor (windows version) or on Edge. 

seems like the desktop editor is broken, as well as from IOS11 on iphones

Our app seemed to start functioning again after simply re-publishing it. Not sure if that triggered something on the data connectors or what happened, but as soon as I re-published both web and mobile work.

Hi @BrendonBrooksP1,

 

There are connectivity issues under the Environments located in Europe.

Which should be fixed.

"

Impact period was from 09/22/2017 at approximately 10:00 UTC through 12:26 UTC.

"

Please check and see if issue has been resolved.

 

Regards,

Michael

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

@v-micsh-msft

You were saying that the issues should've been fixed, but I still have users experiencing these problems.

 

2 users on 2 different apps - one app uses Azure SQL connection, one app uses on-premise SQL connection (through gateway) - both get 'An error occurred on the server'

 

Having a look at the network trace they both get 404 for the same 3 URLs:

error.png

With one of the users I have tried to connect to the other affected app and when it gets prompted to create the on-prem SQL connection it gets the following error:

 

error2.png

 

Is anyone able to investigate this? Is this caused by the previous problem? It all seems to be very unstable after the latest update.

 

Thanks

 

Anonymous
Not applicable

Hi @Anonymous

 

I have actually also started to receive this same error from time to time on SQL Server connection.

 

All it says is that Error Occurred on Server. The only solution I have found is to tell my users is to reload the app.

 

 

Anonymous
Not applicable

@Anonymous

Refreshing doesn't always fixes it. The user reported that from what he tried it is like 1 in 6 refreshes that it actually works... which is not acceptable for a live application used across the business.

@v-micsh-msft

 

For me, the issue has been resolved. Thanks.

 

Brendon

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,325)