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".
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?
Solved! Go to Solution.
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.
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.
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:
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:
Is anyone able to investigate this? Is this caused by the previous problem? It all seems to be very unstable after the latest update.
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.
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.
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.